Data Analysis [8-15]

---

Working with Multiple Analysis Variables
​(Proc Means)

You can analyze multiple variable(s) simultaneously using Proc Means.

Example

Data Sales; Input TransacNo Sales1 Sales2; Format Sales1 Sales2 dollar8.; Datalines; 1 1500 2000 2 1200 800 3 560 450 4 690 780 5 1630 520 6 840 460 7 990 1010 8 770 440 9 1800 3650 10 560 890 ; Run;

The SALES data set contains the first 10 sales made by two salespersons. 

Let's compare the sales performance between the two.

Example

Proc Means Data=Sales;
Var Sales1 Sales2;
Run;

The VAR statement has two variables: Sales1 and Sales2.

The statistics are computed for both variables:

Additional Statistics

You can also request other statistics to be computed, just like when you have only 1 variable:

Example

​Proc Means Data=Sales Mean CLM;
Var Sales1 Sales2;
Run;

The Mean and the 95% Confidence Limits will be computed instead:

---

Exercise

Copy and run the STOCKS data set below:

Data Stocks; Infile datalines dlm='~'; Input Date Open High Low Close; Format Date yymmdd10.; datalines; 20384~52.30~54.07~52.25~52.87 20383~47.53~48.95~47.09~48.03 20382~47.92~47.99~47.11~47.20 20381~47.44~47.81~47.02~47.77 20380~47.42~47.88~47.02~47.62 20377~47.02~47.54~46.90~47.51 20376~47.01~47.03~46.53~47.01 20375~46.65~47.10~46.53~46.68 20374~46.56~47.13~46.56~46.89 20373~46.98~47.07~46.50~47.00 ; Run;

The STOCKS data set contains the stock prices for Microsoft Corporation (MSFT) from October 12, 2015 to October 23, 2015.

Below are the list of variables from the STOCKS data set:

• Date
• Open: Opening Price
• High: Highest Price
• Low: Lowest Price
• Close: Closing Price

Compute the 5 default statistics (N, Mean, STD, Min and Max) on the 4 prices.

Next

---

Need some help? 

Get Hint

HINT:
List all of the variables to be analyzed in the VAR statement.

Get Solution

SOLUTION:
Proc Means Data=Stocks;
Var Open High Low Close;
Run;

---

Fill out my online form.