Calcite | Level 5

## frequency tables and ChiSqu

Among a population, I want to see if there is a significant relationship between being SMI and receiving MHcare using frequency tables and ChiSqu, and there was.

```PROC FREQ;
table MentalSer*SMI/ chisq or;
RUN;```

****Now I want to further investigate to see if there is a relationship between income and those who received MHcare among those who said "yes" to SMI. How do I conduct a frequency table, ChiSqu Odd Ratio? Should I use a control statement? If so, how?

Also, when to us Odd Ratio or Relrisk?

```PROC FREQ;
TABLES SMI * MentalSer / chisq relrisk;
RUN;```

2 REPLIES 2
Super User

## Re: frequency tables and ChiSqu

One way to get analysis for each level of a variable is to use a BY statement, which would require sorting the data by any variables on the by stateement.

PROC FREQ;

by smi;
TABLES income* MentalSer / chisq relrisk;
RUN;

Or

PROC FREQ;

TABLES smi*income* MentalSer / chisq relrisk;
RUN; Which produce a separate table for each smi level.

If you are only interested in one specific level you can use

PROC FREQ;

where smi='Yes'; /* <= the value  has to be actual values of the variable */
TABLES income* MentalSer / chisq relrisk;
RUN;

The approach you take would depend on what you are doing over all. Proc Freq can have multiple TABLES statements each with separate options. you could get both analysis  with

Proc freq;

tables MentalSer*SMI/ chisq or;

tables smi*MentalSer*income/ chisq relrisk;

run;

The BY and WHERE would restrict analysis for all records where the separate tables statments would use all records.

Calcite | Level 5

## Re: frequency tables and ChiSqu

Those codes worked. 🙂

Discussion stats
• 2 replies
• 774 views
• 0 likes
• 2 in conversation