SAS : Proc Freq Tutorial

This tutorial explains how to use PROC FREQ.

Create a sample data set
data example1;
input x y $ z;
6 A 60
6 A 70
2 A 100
2 B 10
3 B 67
2 C 81
3 C 63
5 C 55

Example 1 : To check the distribution of a categorical variable (Character)
proc freq data = example1;
tables y;
The TABLES statements tells SAS to return one-way to n-way frequency and crosstabulation tables and computes the statistics for these tables.

Output : PROC FREQ

Example 2 : To remove unwanted statistics in the table

Suppose you do not want cumulative frequency and percent to be displayed in the table.
proc freq data = example1;
tables y /nocum;
If you want only frequency, not percent distribution and cumulative statistics.
proc freq data = example1;
tables y /nopercent nocum;

Example 3 : Cross Tabulation ( 2*2 Table)

Suppose you want to see the distribution of variable "y" by variable "x".
proc freq data = example1;
tables y * x;
Example 4 : Hide Unwanted Statistics in Cross Tabulation
proc freq data = example1;
tables y * x / norow nocol nopercent;
Example 5 : Request Multiple Tables
proc freq data = example1;
tables y * (x z) / norow nocol nopercent;
The tables y*(x z) statement is equivalent to tables y*x y*z statement.
Example - tables (a b)*(c d); is equivalent to tables a*c b*c a*d b*d;

Example 6 : Use WEIGHT Statement

The WEIGHT statement is used when we already have the counts.
Data example2;
input pre $ post $ count;
Yes Yes 30
Yes No 10
No Yes 40
No No 20
proc freq data=example2;
tables pre*post;
weight count;run;
Example 7 : Store result in a data file
proc freq data = example1;
tables y *x / out = temp;
The OUT option is used to store result in a data file.

Example 8 : Run Chi-Square Analysis
proc freq data = example1 noprint;
tables y * x/chisq;
output All out=temp_chi chisq;

SAS Tutorials : 100 Free SAS Tutorials

Get Free Email Updates :
*Please confirm your email address by clicking on the link sent to your Email*

Related Posts:

7 Responses to "SAS : Proc Freq Tutorial"

  1. Good explaination!

  2. Great tutorial...
    could you also explain more on 'WEIGHT statement'

  3. Replies
    1. Good question bank and explanations.Keep posting!!


Next → ← Prev