Search the site...

SASCRUNCH TRAINING
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
  • Home
  • Member's Area
  • How to Start
  • SAS Interface
  • Creating a Data Set
  • Practical SAS Training Course
  • SAS Certified Specialist Training Program
  • Proc SQL Course
  • Introduction to Time Series Analysis
  • SAS Project Training Course
  • Full Training / Membership
  • Sign up
  • About us
  • Contact us
Sentry Page Protection
Please Wait...
Data Analysis [5-15]


Proc Means

​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
Picture

​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.
Picture
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;
Picture

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?
Next

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.

Already a member? Go to member's area.