51.PROC FREQ | OUTCUM | OUTPCT

                      PROC FREQ | OUTCUM | OUTPCT


1.OUTCUMIncludes the cumulative frequency and cumulative percentage in the output data set for one-way frequency tables.

PROC FREQ DATA=SASUSER.CLASS2;

 TABLES NAME AGE / OUT=WORK.FREQ1 OUTCUM;

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.FREQ1 has 6 observations and 5 variables.

NOTE: PROCEDURE FREQ used (Total process time):

      real time           3.76 seconds

      cpu time            0.28 seconds


RESULT:
Obs Age COUNT PERCENT CUM_FREQ CUM_PCT
1 11 2 10.5263 2 10.526
2 12 5 26.3158 7 36.842
3 13 3 15.7895 10 52.632
4 14 4 21.0526 14 73.684
5 15 4 21.0526 18 94.737
6 16 1 5.2632 19 100.000


2.OUTPCT: Includes the percentage of column frequency and row frequency in the output data set for n-way frequency tables.

PROC FREQ DATA=SASUSER.CLASS2;

 TABLES NAME*AGE / OUT=WORK.FREQ2 OUTPCT;

RUN;

PROC PRINT;RUN;

LOG:

NOTE: There were 19 observations read from the data set SASUSER.CLASS2.
NOTE: The data set WORK.FREQ2 has 19 observations and 6 variables.
NOTE: PROCEDURE FREQ used (Total process time):
      real time           0.32 seconds
      cpu time            0.04 seconds

RESULT:
                                                           The SAS System

Obs Name Age COUNT PERCENT PCT_ROW PCT_COL
1 Alfred 14 1 5.26316 100 25.000
2 Alice 13 1 5.26316 100 33.333
3 Barbara 13 1 5.26316 100 33.333
4 Carol 14 1 5.26316 100 25.000
5 Henry 14 1 5.26316 100 25.000
6 James 12 1 5.26316 100 20.000
7 Jane 12 1 5.26316 100 20.000
8 Janet 15 1 5.26316 100 25.000
9 Jeffrey 13 1 5.26316 100 33.333
10 John 12 1 5.26316 100 20.000
11 Joyce 11 1 5.26316 100 50.000
12 Judy 14 1 5.26316 100 25.000
13 Louise 12 1 5.26316 100 20.000
14 Mary 15 1 5.26316 100 25.000
15 Philip 16 1 5.26316 100 100.000
16 Robert 12 1 5.26316 100 20.000
17 Ronald 15 1 5.26316 100 25.000
18 Thomas 11 1 5.26316 100 50.000
19 William 15 1 5.26316 100 25.000


HERE LET INCLUDE ALL THE OPTIONS WE LEARNED LIKE OUT , OUTPUT , CHISQ , OUTCUM...

PROC FREQ DATA=SASUSER.CLASS2;

 TABLES AGE / CHISQ OUT=WORK.FREQ3 OUTCUM;

 OUTPUT OUT=WORK.FREQ4 CHISQ;

RUN;


LOG:


NOTE: There were 19 observations read from the data set SASUSER.CLASS2.
NOTE: The data set WORK.FREQ3 has 6 observations and 5 variables.
NOTE: The data set WORK.FREQ4 has 1 observations and 4 variables.
NOTE: PROCEDURE FREQ used (Total process time):
      real time           2.90 seconds
      cpu time            0.42 seconds

PROC PRINT DATA=WORK.FREQ3;

RUN;

LOG:

NOTE: There were 6 observations read from the data set WORK.FREQ3.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.03 seconds
      cpu time            0.00 seconds

PROC PRINT DATA=WORK.FREQ4;

RUN;

LOG:

NOTE: There were 1 observations read from the data set WORK.FREQ4.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.04 seconds
      cpu time            0.00 seconds



RESULT:
                                                      The SAS System

Obs Age COUNT PERCENT CUM_FREQ CUM_PCT
1 11 2 10.5263 2 10.526
2 12 5 26.3158 7 36.842
3 13 3 15.7895 10 52.632
4 14 4 21.0526 14 73.684
5 15 4 21.0526 18 94.737
6 16 1 5.2632 19 100.000


                                                         The SAS System

Obs N _PCHI_ DF_PCHI P_PCHI
1 19 3.42105 5 0.63537


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





Comments