topic Re: Repeating Analysis by Subgroups in SAS Procedures

Repeating Analysis by Subgroups

ammarhm — Wed, 31 Dec 2014 13:11:21 GMT

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

Re: Repeating Analysis by Subgroups

PhilC — Wed, 31 Dec 2014 13:38:13 GMT

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 Procedures, Third Edition

Re: Repeating Analysis by Subgroups

ammarhm — Wed, 31 Dec 2014 13:47:33 GMT

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

Re: Repeating Analysis by Subgroups

SteveDenham — Wed, 31 Dec 2014 17:53:03 GMT

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