- Get link
- X
- Other Apps
PROC MEANS | SUM | MEAN | RANGE OPTIONS
SUM OPTION :IT IS USED FOR SUM OF THE NUMERIC VALUES IN SAS..
MEAN OPTION:IT WILL GIVE THE AVERAGE OF THE VALUES IN SAS..
RANGE OPTION:IT WILL GIVE RANGE OF THE VALUES IN SAS..
--> LET'S TRY ALL THE THREE OPTIONS IN ONE SYNTAX..
EG1:
PROC MEANS DATA=PROG1.SALES SUM MEAN RANGE;
VAR SALARY;
CLASS GENDER ;
OUTPUT OUT=WORK.MEAN1;
RUN;
LOG:
NOTE: Writing HTML Body file: sashtml.htm
NOTE: There were 165 observations read from the data set PROG1.SALES.
NOTE: The data set WORK.MEAN1 has 15 observations and 5 variables.
NOTE: PROCEDURE MEANS used (Total process time):
real time 3.26 seconds
cpu time 0.46 seconds
RESULT:HERE IN CLASS STATEMENT WE ARE USING ONLY ONE VARIABLE.SO THE RESULT WILL BE..
The SAS System |
Analysis Variable : Salary | ||||
---|---|---|---|---|
Gender | N Obs | Sum | Mean | Range |
F | 68 | 1955865.00 | 28762.72 | 58320.00 |
M | 97 | 3185555.00 | 32840.77 | 220480.00 |
The SAS System |
Analysis Variable : Salary | |||||
---|---|---|---|---|---|
Gender | Country | N Obs | Sum | Mean | Range |
F | AU | 23 | 638730.00 | 27770.87 | 5705.00 |
IN | 4 | 112235.00 | 28058.75 | 1270.00 | |
UK | 5 | 137210.00 | 27442.00 | 3320.00 | |
US | 36 | 1067690.00 | 29658.06 | 58115.00 | |
M | AU | 36 | 1152050.00 | 32001.39 | 82510.00 |
US | 61 | 2033505.00 | 33336.15 | 220480.00 |
--PLEASE FOLLOW THE BLOG FOR MORE UPDATES...
--FOLLOW US IN FACEBOOK SASALL4YOU AND JOIN ...
--JOIN US IN FACEBOOK AND TELEGRAM CHANNEL FOR MORE UPDATES
CLICK HERE: https://t.me/SasAll4You
- Get link
- X
- Other Apps
Comments
Post a Comment