55.PROC MEANS | SUM | MEAN | RANGE OPTIONS

                         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

                      The MEANS Procedure

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


EG2:

PROC MEANS DATA=PROG1.SALES SUM MEAN RANGE;

 VAR SALARY;

 CLASS GENDER COUNTRY;

 OUTPUT OUT=WORK.MEAN1;

RUN;


LOG:

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           0.14 seconds

      cpu time            0.01 seconds

RESULT:HERE IN CLASS  STATEMENT WE ARE USING TWO VARIABLE.SO THE RESULT WILL BE..

                               The SAS System

                           The MEANS Procedure

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


THERE ARE SOME MORE OPTIONS IN SAS TO USE :

PROC MEANS Statistics

1.Descriptive Statistic Keywords

CLM    CSS     CV      LCLM      MAX     MEAN    MIN     MODE     N     NMISS      KURTOSIS  

 RANGE    SKEWNESS      STDDEV     STDERR     SUM     SUMWGT     UCLM     USS     VAR

2.Quantile Statistic Keywords

MEDIAN|P50      P1       P5      P10      Q1|P25      Q3|P75      P90      P95      P99        QRANGE

3.Hypothesis Testing Keywords

PROBT           T


TRY THIS OPTIONS AND COMMENT YOUR ANSWER..


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