59.PROC MEANS | CHARTYPE 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 CHARTYPE 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

CHARTYPE:SPECIFIES THAT THE _TYPE_ VARIABLE IN THE OUTPUT DATASET IS A CHARACTER REPRESENTATION OF THE BINARY VALUE OF _TYPE_..

PROC MEANS DATA=PROG1.SALES CHARTYPE ;

VAR SALARY;

CLASS GENDER COUNTRY;

OUTPUT OUT=WORK.MEANS2

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.57 seconds

cpu time 0.34 seconds

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

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.15 seconds

cpu time 0.01 seconds

RESULT:WITH CHARTYPE OPTION OBSERVE THE _TYPE_ VARIABLE..

The SAS System

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

Sas All