46.PROC FREQ | ONE WAY | TWO WAY | THREE WAY

on

                        PROC FREQ | ONE WAY | TWO WAY | THREE WAY


1.ONE-WAY FREQ:

PROC FREQ DATA=SASUSER.CLASS2;

TABLE NAME AGE;

OUTPUT OUT=A23;

RUN;

NOTE:HERE YOU NOTICE A  WARNING MESSAGE AS WE DIDN'T APPLY ANY STATISTICS IN THE TABLE STATEMENT AND NOT CREATED ANY OUTPUT..

LOG:

WARNING: No OUTPUT data set is produced because no statistics are requested in the corresponding TABLES statement.

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

NOTE: PROCEDURE FREQ used (Total process time):

      real time           2.21 seconds

      cpu time            0.29 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


Age
Age Frequency Percent Cumulative
Frequency		 Cumulative
Percent
11 2 10.53 2 10.53
12 5 26.32 7 36.84
13 3 15.79 10 52.63
14 4 21.05 14 73.68
15 4 21.05 18 94.74
16 1 5.26 19 100.00


2.TWO-WAY FREQ:IN THIS TWO WAY FREQ HERE NAME IS ROWS AND AGE IS COLUMN...

PROC FREQ DATA=SASUSER.CLASS2;

TABLE NAME*AGE;

OUTPUT OUT=A24;

RUN;


LOG:

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

NOTE: PROCEDURE FREQ used (Total process time):

      real time           0.18 seconds

      cpu time            0.06 seconds


RESULT:
                                                                               The FREQ Procedure

Frequency
Percent
Row Pct
Col Pct
Table of Name by Age
Name(Name) Age(Age)
11 12 13 14 15 16 Total
Alfred
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
100.00
25.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
 
 
Alice
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
100.00
33.33
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
 
 
Barbara
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
100.00
33.33
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
 
 
Carol
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
100.00
25.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
 
 
Henry
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
100.00
25.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
 
 
James
0
0.00
0.00
0.00
1
5.26
100.00
20.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
 
 
Jane
0
0.00
0.00
0.00
1
5.26
100.00
20.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
 
 
Janet
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
100.00
25.00
0
0.00
0.00
0.00
1
5.26
 
 
Jeffrey
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
100.00
33.33
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
 
 
John
0
0.00
0.00
0.00
1
5.26
100.00
20.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
 
 
Joyce
1
5.26
100.00
50.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
 
 
Judy
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
100.00
25.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
 
 
Louise
0
0.00
0.00
0.00
1
5.26
100.00
20.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
 
 
Mary
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
100.00
25.00
0
0.00
0.00
0.00
1
5.26
 
 
Philip
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
100.00
100.00
1
5.26
 
 
Robert
0
0.00
0.00
0.00
1
5.26
100.00
20.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
 
 
Ronald
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
100.00
25.00
0
0.00
0.00
0.00
1
5.26
 
 
Thomas
1
5.26
100.00
50.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
 
 
William
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
0
0.00
0.00
0.00
1
5.26
100.00
25.00
0
0.00
0.00
0.00
1
5.26
 
 
Total
2
10.53
5
26.32
3
15.79
4
21.05
4
21.05
1
5.26
19
100.00


3.THREE-WAY FREQ:IN THIS THREE WAY FREQ HERE ROWS IS NAME , AGE IS COLUMN AND PAGE IS CLASS.AND HERE EVERY NAME IN THE DATASET WILL GIVE SEPARATELY..


PROC FREQ DATA=SASUSER.CLASS2;

TABLE NAME*AGE*CLASS;

OUTPUT OUT=A25;

RUN;


LOG:

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

NOTE: PROCEDURE FREQ used (Total process time):

      real time           0.23 seconds

      cpu time            0.17 seconds


RESULT:


                                                                          The FREQ Procedure

Frequency
Percent
Row Pct
Col Pct
Table 1 of Age by CLASS
Controlling for Name=Alfred
Age(Age) CLASS
6 7 8 9 10 11 Total
11
0
0.00
.
.
0
0.00
.
.
0
0.00
.
.
0
0.00
.
0.00
0
0.00
.
.
0
0.00
.
.
0
0.00
 
 
12
0
0.00
.
.
0
0.00
.
.
0
0.00
.
.
0
0.00
.
0.00
0
0.00
.
.
0
0.00
.
.
0
0.00
 
 
13
0
0.00
.
.
0
0.00
.
.
0
0.00
.
.
0
0.00
.
0.00
0
0.00
.
.
0
0.00
.
.
0
0.00
 
 
14
0
0.00
0.00
.
0
0.00
0.00
.
0
0.00
0.00
.
1
100.00
100.00
100.00
0
0.00
0.00
.
0
0.00
0.00
.
1
100.00
 
 
15
0
0.00
.
.
0
0.00
.
.
0
0.00
.
.
0
0.00
.
0.00
0
0.00
.
.
0
0.00
.
.
0
0.00
 
 
16
0
0.00
.
.
0
0.00
.
.
0
0.00
.
.
0
0.00
.
0.00
0
0.00
.
.
0
0.00
.
.
0
0.00
 
 
Total
0
0.00
0
0.00
0
0.00
1
100.00
0
0.00
0
0.00
1
100.00

Frequency
Percent
Row Pct
Col Pct
Table 2 of Age by CLASS
Controlling for Name=Alice
Age(Age) CLASS
6 7 8 9 10 11 Total
11
0
0.00
.
.
0
0.00
.
.
0
0.00
.
0.00
0
0.00
.
.
0
0.00
.
.
0
0.00
.
.
0
0.00
 
 
12
0
0.00
.
.
0
0.00
.
.
0
0.00
.
0.00
0
0.00
.
.
0
0.00
.
.
0
0.00
.
.
0
0.00
 
 
13
0
0.00
0.00
.
0
0.00
0.00
.
1
100.00
100.00
100.00
0
0.00
0.00
.
0
0.00
0.00
.
0
0.00
0.00
.
1
100.00
 
 
14
0
0.00
.
.
0
0.00
.
.
0
0.00
.
0.00
0
0.00
.
.
0
0.00
.
.
0
0.00
.
.
0
0.00
 
 
15
0
0.00
.
.
0
0.00
.
.
0
0.00
.
0.00
0
0.00
.
.
0
0.00
.
.
0
0.00
.
.
0
0.00
 
 
16
0
0.00
.
.
0
0.00
.
.
0
0.00
.
0.00
0
0.00
.
.
0
0.00
.
.
0
0.00
.
.
0
0.00
 
 
Total
0
0.00
0
0.00
1
100.00
0
0.00
0
0.00
0
0.00
1
100.00



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

Post a Comment