All posts tagged: SAS

The Urban Question Continued…Macau Grew the Most in 2010?

This is the last assignment for the introductory course Data Management and Visualization with Coursera, after which I will be moving onto the second course Data Analysis Tools Again, for those who have not read my previous posts, I am currently enrolled in a Data Analysis Specialization with Wesleyan University through Coursera. With data from Gapminder, I am exploring a broad and basic question: does urbanization drive economic growth? For those of you interested in reading my literature review to gain a background on this project, please visit this page. Even though I am learning both SAS and Python, I will only be presenting my work in SAS here. (Python code included as reference).The reason is that at the moment, for my current abilities, SAS produces output that is easier to present. For this last assignment, I will be presenting my data in visual form – through graphing variables individuals and to relate my explanatory variable (urbanization rate) with my response variable (GDP growth rate). Before I present my work, I must admit to a mistake I …

Data Management – Missing Values

Continuing my course in Data Management and Visualization with Coursera… For those that haven’t followed on my previous posts, I am currently enrolled in a Data Analysis Specialization with Wesleyan University through Coursera. With data from Gapminder, I am exploring a broad and basic question: does urbanization drive economic growth? For those of you interested in reading my literature review to gain a background in this project, please visit this page. Though I am working in SAS and Python in an attempt to learn both, I will only be presenting my work in SAS here (though I will also include my Python code for reference). The output format in SAS is easier on the eyes in my opinion. For this third assignment, I was originally going to try to calculate the urban population growth rate for 2010. Instead, I found the data available on Gapminder so I did not have to create a secondary variable for population growth. After inserting the latest variable, I decided to code out missing data. Since my focus is on GDP, …

Frequency Tables…The World is Mainly Poor…

I have always been hungry for knowledge and been ambitious about my goals. Having the chance to finally learn some programming, I decided I was going to learn both SAS and Python. Luckily, this isn’t my first exposure. While at ASU, I learned the basics of R programming and it really helped me to get an understanding of writing syntax in both SAS and Python. For my second assignment for the Data Management and Visualization course with Wesleyan University through Coursera, I am required to post the program I wrote and the frequency tables that it produced. Just as a reminder, I am working with Gapminder data on urbanization and economic growth. For the present analysis, I am using GDP per Capita, GDP Growth, Urban Population as a percentage of total population from 2010 and Urban Population in agglomerations over 1 million people from 2007. This is my code in SAS: FILENAME REFFILE “/home/wfhsu.taiwan0/my_courses/Data1.xlsx” TERMSTR=CR; PROC IMPORT DATAFILE=REFFILE DBMS=XLSX OUT=Gapminder2010; GETNAMES=YES; RUN; PROC CONTENTS DATA=Gapminder2010; RUN; /*to importat data from Excel file upload*/ LIBNAME mydata …