## Repeating Analysis by Subgroups

Solved
Regular Contributor
Posts: 182

# Repeating Analysis by Subgroups

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

Accepted Solutions
Solution
‎12-31-2014 08:38 AM
Regular Contributor
Posts: 194

## Re: Repeating Analysis by Subgroups

All Replies
Solution
‎12-31-2014 08:38 AM
Regular Contributor
Posts: 194

## Re: Repeating Analysis by Subgroups

Regular Contributor
Posts: 182

## Re: Repeating Analysis by Subgroups

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

BW

Posts: 2,655

## Re: Repeating Analysis by Subgroups

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

🔒 This topic is solved and locked.