58.PROC MEANS | DESCENDTYPES 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 DESCENDTYPES OPTION 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

DESCENDTYPES:ORDERS THE OUTPUT DATASET BY DESCENDING _TYPE_ VALUE..

PROC MEANS DATA=PROG1.SALES DESCENDTYPES ;

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

cpu time 0.28 seconds

NOTE: There were 13 observations read from the data set WORK.MEANS1.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.26 seconds

cpu time 0.01 seconds

RESULT:

The SAS System

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
7	F		2	68	25185	83505	1955865	28762.72
8	M		2	97	22710	243190	3185555	32840.77
9		AU	1	59	25185	108255	1790780	30352.20
10		IN	1	4	27475	28745	112235	28058.75
11		UK	1	5	26205	29525	137210	27442.00
12		US	1	97	22710	243190	3101195	31971.08
13			0	165	22710	243190	5141420	31160.12

Sas All