Repeating Analysis by Subgroups

[ammarhm]

Lets say we have 3 variables (var1, var2, var3)

All are categorical

var3 values could be one of 4: North, South, East, West

I want to do a certain procedure, let us say

Proc Freq data=have;

Tables Var1*Var2/chisq;

run;

And I want this to be repeated automatically for all the subgroups in Var3

Is there a simple way of doing it?

Best wishes for the New Year

[PhilC · Accepted solution]

By statement.  I defer you to this link: Example 3.3 "Chi-Square Goodness-of-Fit Tests", Base SAS(R) 9.2 Procedures Guide: Statistical Proced...

[ammarhm]

Thanks, i did try the BY statement, but didnt notice I had to sort the data first

BW

[SteveDenham]

You might also try:

proc freq data=have;

tables Var3*Var1*Var2/<insert keywords here>;

run;

The advantage here is that if you specify CMH as a keyword that you will get, in addition to the tests and tables for each level of Var3, a stratified analysis over all levels of Var3.

Steve Denham