52.PROC MEANS | SUM OPTION

                             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


Comments