Data Management and Visualization: WEEK 2

My First SAS Program

Project:

Well-Being of a Country vs. Well-Being of its Citizens

Source: New Data Sheet from OECD

In my first program, I uploaded a new data sheet with 34 developed countries (including 24 European countries) and 5 Variables: GDP, Household Disposable Income, Personal Earnings, Work, Education and Satisfaction Index.

*Countries - Australia, Austria, Belgium, Canada, Chile, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Iceland, Ireland, Israel, Italy, Japan, Korea, Luxembourg, Mexico, Netherlands, New Zealand, Norway, Poland, Portugal, Slovak Republic, Slovenia, Spain, Sweden, Switzerland, Turkey, United Kingdom, United States.                                                                                                             

*GDP – Gross Domestic Product

*Personal Earnings – “This indicator refers to the average annual wages per full-time equivalent dependent employee, which are obtained by dividing the national-accounts-based total wage bill by the average number of employees in the total economy, which is then multiplied by the ratio of average usual weekly hours per full-time employee to average usually weekly hours for all employees. It considers the employees’ gross remuneration, that is, the total before any deductions are made by the employer in respect of taxes, contributions of employees to social security and pension schemes, life insurance premiums, union dues and other obligations of employee (source: OECD)

*Household Disposable Income - “It's the maximum amount that a household can afford to consume without having to reduce its assets or to increase its liabilities. It's obtained adding to people’s gross income (earnings, self-employment and capital income, as well as current monetary transfers received from other sectors) the social transfers in-kind that households receive from governments (such as education and health care services), and then subtracting the taxes on income and wealth, the social security contributions paid by households as well as the depreciation of capital goods consumed by households. Available data refer to the sum of households and non-profit institution serving households” (source: OECD)

* Work – Percentage of the working-age population (aged 15-64); "It is the number of employed persons aged 15 to 64 over the population of the same age. Employed people are those aged 15 or more who report that they have worked in gainful employment for at least one hour in the previous week, as defined by the International Labour Organization – ILO." (source: OECD)

* Education – “Educational attainment considers the number of adults aged 25 to 64 holding at least an upper secondary degree over the population of the same age, as defined by the OECD-ISCED classification” (source: OECD)

*Satisfaction Index – “The indicator considers people's evaluation of their life as a whole. It is a weighted-sum of different response categories based on people's rates of their current life relative to the best and worst possible lives for them on a scale from 0 to 10, using the Cantril Ladder (known also as the "Self-Anchoring Striving Scale")” (source: OECD)

I decided to compare top ten countries (with highest GDP) and bottom ten countries (with lowest GDP) and observe the differences in the above variables.

Code:

 Results:

Summary of results:

TOP TEN	BOTTOM TEN
Countries with TOP ten GDP were: Luxembourg, Norway, Switzerland, United States, Ireland, Netherlands, Australia, Austria and Sweden and Germany.	Countries with Bottom ten GDP were: Mexico, Turkey, Chile, Hungary, Poland, Greece, Estonia, Portugal and Slovak Republic.
Category “1” in the next two tables shows that both Personal Earnings and Household disposable income are above the average in all ten countries (100%).	Category “0” in the next two tables shows that Personal Earnings and Household disposable income are below the average in all ten countries.
Education table shows that the percentage of people with at least high-school degree varies between 73% and 89% with the average score of 80.8%. The lowest score (i.e. 73%) belonged to 30% of these countries.	Education table shows that the percentage of people with at least high-school degree varies between 31% and 91% with the average score of 66.8% What is striking is that 30% of these countries had less than 40% of high-school graduates.
Next table shows that the average percentage of the working-age population is 71.3%	Next table shows that the average percentage of the working-age population is 59.3%.
Category “1” in the last table shows that Life Satisfaction Index is higher than average in all ten countries (100%). The average Satisfaction Index for all 34 countries was 6.59/10.	Category “1” shows that two countries (20%) have Life Satisfaction Index over the average. And category “0” shows  that the remaining countries (80%) are below the average.

To sum up, according to the above analysis, the countries with higher GDP are better in respect of all variables i.e. Personal Earnings, Household disposable income, Number of people with at least high-school degree, Number of people of working-age, 

and Life Satisfaction.

There was no missing data - all cells were filled and complete.

____________________________________________
*reference year for all the data was 2013.