50. PROC FREQ | OUTPUT OPTION

                       PROC FREQ | OUTPUT  OPTION                  

OUTPUT Statement OUT= Option

-->The OUT= option in the OUTPUT statement creates an output data set with the following variables:

1.BY variables

2.The variables requested in the TABLES statement

3. Variables that contain the specified statistics.

HERE SYNTAX IS:  OUTPUT OUT=SAS-data-set <options>;

-->If more than one table request appears in the TABLES statement, the contents of the data set corresponds to the last table request.

-->In order to specify that the output data set contain a particular statistic, you must have PROC FREQ compute the statistic by using the corresponding option in the TABLES statement.

PROC FREQ DATA=SASUSER.CLASS2;

 TABLES NAME / CHISQ ;

 OUTPUT OUT=FREQ01 CHISQ;

RUN;

PROC PRINT ;RUN;

LOG:

NOTE: Writing HTML Body file: sashtml.htm

NOTE: There were 19 observations read from the data set SASUSER.CLASS2.

NOTE: The data set WORK.FREQ01 has 1 observations and 4 variables.

NOTE: PROCEDURE FREQ used (Total process time):

      real time           4.40 seconds

      cpu time            0.68 seconds

NOTE: There were 1 observations read from the data set WORK.FREQ01.

NOTE: PROCEDURE PRINT used (Total process time):

      real time           0.20 seconds

      cpu time            0.00 seconds

RESULT:

                                                           The FREQ Procedure

Name
Name	Frequency	Percent	Cumulative Frequency	Cumulative Percent
Alfred	1	5.26	1	5.26
Alice	1	5.26	2	10.53
Barbara	1	5.26	3	15.79
Carol	1	5.26	4	21.05
Henry	1	5.26	5	26.32
James	1	5.26	6	31.58
Jane	1	5.26	7	36.84
Janet	1	5.26	8	42.11
Jeffrey	1	5.26	9	47.37
John	1	5.26	10	52.63
Joyce	1	5.26	11	57.89
Judy	1	5.26	12	63.16
Louise	1	5.26	13	68.42
Mary	1	5.26	14	73.68
Philip	1	5.26	15	78.95
Robert	1	5.26	16	84.21
Ronald	1	5.26	17	89.47
Thomas	1	5.26	18	94.74
William	1	5.26	19	100.00

THIS IS THE CHISQ:

Chi-Square Test for Equal Proportions
Chi-Square	0.0000
DF	18
Pr > ChiSq	1.0000
WARNING: The table cells have expected counts less than 5. Chi-Square may not be a valid test.

---

The SAS System

Obs	N	_PCHI_	DF_PCHI	P_PCHI
1	19	0	18	1

_PCHI_ :  CHISQ

DF_PCHI : DEGREES OF FREEDOM 

P_PCHI : P VALUE

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