57.PROC MEANS | NWAY OPTION

                                  PROC MEANS | NWAY OPTION

PROC MEANS DATA=PROG1.SALES  ;

 VAR SALARY;

 CLASS GENDER COUNTRY;

 OUTPUT OUT=WORK.MEANS1

        MIN=MINSALARY MAX=MAXSALARY

        SUM=SUMSALARY MEAN=AVGSALARY;

RUN;

PROC PRINT;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.MEANS1 has 13 observations and 8 variables.

NOTE: PROCEDURE MEANS used (Total process time):

      real time           3.88 seconds

      cpu time            0.39 seconds

RESULT:WITHOUT  NWAY OPTIONS OBSERVE THE _TYPE_..

The SAS System

Obs	Gender	Country	_TYPE_	_FREQ_	MINSALARY	MAXSALARY	SUMSALARY	AVGSALARY
1			0	165	22710	243190	5141420	31160.12
2		AU	1	59	25185	108255	1790780	30352.20
3		IN	1	4	27475	28745	112235	28058.75
4		UK	1	5	26205	29525	137210	27442.00
5		US	1	97	22710	243190	3101195	31971.08
6	F		2	68	25185	83505	1955865	28762.72
7	M		2	97	22710	243190	3185555	32840.77
8	F	AU	3	23	25185	30890	638730	27770.87
9	F	IN	3	4	27475	28745	112235	28058.75
10	F	UK	3	5	26205	29525	137210	27442.00
11	F	US	3	36	25390	83505	1067690	29658.06
12	M	AU	3	36	25745	108255	1152050	32001.39
13	M	US	3	61	22710	243190	2033505	33336.15

 

NWAY OPTION:SPECIFIES THAT THE OUTPUT DATASET CONTAINS ONLY STATISTICS FOR THE OBSERVATIONS WITH THE HIGHEST _TYPE_ VALUE..

PROC MEANS DATA=PROG1.SALES NWAY ;

 VAR SALARY;

 CLASS GENDER COUNTRY;

 OUTPUT OUT=WORK.MEANS1

        MIN=MINSALARY MAX=MAXSALARY

        SUM=SUMSALARY MEAN=AVGSALARY;

RUN;

PROC PRINT;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.MEANS1 has 6 observations and 8 variables.

NOTE: PROCEDURE MEANS used (Total process time):

      real time           2.68 seconds

      cpu time            0.28 seconds

OUTPUT:WITH NWAY OPTIONS OBSERVE THE _TYPE_..

Obs	Gender	Country	_TYPE_	_FREQ_	MINSALARY	MAXSALARY	SUMSALARY	AVGSALARY
1	F	AU	3	23	25185	30890	638730	27770.87
2	F	IN	3	4	27475	28745	112235	28058.75
3	F	UK	3	5	26205	29525	137210	27442.00
4	F	US	3	36	25390	83505	1067690	29658.06
5	M	AU	3	36	25745	108255	1152050	32001.39
6	M	US	3	61	22710	243190	2033505	33336.15

TRY THIS OPTION AND COMMENT ...

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