56.OUTPUT OUT STATISTICS | MIN | MAX | SUM

-->THE OUTPUT STATEMENT CAN ALSO DO THE FOLLOWING:

-->SPECIFY THE STATISTICS FOR THE OUTPUT DATASET.

-->SELECT AND NAME VARIABLES.

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:

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

NOTE:HERE _TYPE_ IS A NUMERIC VARIABLE THAT SHOWS WHICH COMBINATION OF CLASS VARIABLES PRODUCED THE SUMMARY STATISTICS IN THAT OBSERVATION.

TRY OTHER STATISTICS 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

Sas All