- Get link
- X
- Other Apps
PROC MEANS | SUM OPTION
1.SUM OPTION :IT IS USED FOR SUM OF THE NUMERIC VALUES IN SAS..
EG1:
PROC MEANS DATA=PROG1.SALES SUM;
VAR SALARY;
CLASS GENDER COUNTRY;
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 65 observations and 6 variables.
NOTE: PROCEDURE MEANS used (Total process time):
real time 2.03 seconds
cpu time 0.23 seconds
RESULT:ALL THE OBSERVATIONS IN THE COUNTRY ARE CALCULATED BY USING SUM OPTION AS WE USED CLASS STATEMENT GENDER AND COUNTRY SO IT SHOWING SEPARATELY FOR BOTH MALES AND FEMALES ..
The SAS System |
The MEANS Procedure
Analysis Variable : Salary | |||
---|---|---|---|
Gender | Country | N Obs | Sum |
F | AU | 23 | 638730.00 |
IN | 4 | 112235.00 | |
UK | 5 | 137210.00 | |
US | 36 | 1067690.00 | |
M | AU | 36 | 1152050.00 |
US | 61 | 2033505.00 |
EG2:
PROC MEANS DATA=PROG1.SALES SUM;
VAR SALARY;
CLASS COUNTRY;
OUTPUT OUT=WORK.MEAN2;
RUN;
LOG:
NOTE: There were 165 observations read from the data set PROG1.SALES.
NOTE: The data set WORK.MEAN1 has 25 observations and 5 variables.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.06 seconds
cpu time 0.00 seconds
RESULT:ALL THE OBSERVATIONS IN THE COUNTRY ARE CALCULATED BY USING SUM OPTION AS WE USED CLASS STATEMENT ONLY COUNTRY.
The SAS System |
The MEANS Procedure
Analysis Variable : Salary | ||
---|---|---|
Country | N Obs | Sum |
AU | 59 | 1790780.00 |
IN | 4 | 112235.00 |
UK | 5 | 137210.00 |
US | 97 | 3101195.00 |
-->PLEASE READ AND COMMENT THE BLOG...
--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