Data Analysis 1.5

Search the site...

Sentry Page Protection

Data Analysis [5-15]

Proc Means


 Proc Means Data=DS;
 Var var1;
 Run;

Proc Means is one of the most frequently used procedures in SAS.

Similar to Proc Univariate, it computes summary statistics on numeric variable(s).

Example

Data Pharma;
Infile datalines dsd;
Input Rank Company :$30. Rev2014 Rev2013 GrowthR GrowthPer;
Datalines;
1,Novartis,47101,47468,-367,-1
2,Pfizer,45708,47878,-2170,-5
3,Roche,39120,39163,-43,0
4,Sanofi,36437,37124,-687,-2
5,Merck & Co.,36042,37437,-1395,-4
6,Johnson & Johnson,32313,28125,4188,15
7,GlaxoSmithKline,29580,33330,-3750,-11
8,AstraZeneca,26095,25711,384,1
9,Gilead Sciences,24474,10804,13670,127
10,Takeda,20446,19158,1288,7
;
Run;

The PHARMA data set above contains a list of top 10 pharmaceutical companies in the world.

It contains the following variables:

Rank
Company
Rev2014: Revenue in 2014 (million)
Rev2013: Revenue in 2013 (million)
GrowthR: Growth in Revenue (million)
GrowthP: Growth in Revenue (percentage)

The companies are ranked by revenue in 2014.

Default Statistics

By default, Proc Means computes the 5 statistics below:

N
Mean
Standard Deviation
Minimum
Maximum

Example

Proc Means Data=Pharma;
Var Rev2014;
Run;

Proc Means computed the N, Mean, Standard Deviation, Minimum and Maximum values from the Rev2014 variable.

The top 10 pharmaceutical companies generated, on average, 33731.6 million in the year of 2014.

The company with the highest revenue generated 47101 million, while the one at the bottom of the list generated 20446 millions.

Exercise

Compute the 5 statistics on the revenue in 2013.

Did the average revenue from the top 10 pharmaceuticals go up from 2013 to 2014?

Need some help?

HINT:
Simply use Proc Means on the variable Rev2013.

SOLUTION:
Proc Means Data=Pharma;
Var Rev2013;
Run;

The average revenue in 2013 is 32619 million. It went up slightly from 2013 to 2014.

Fill out my online form.