topic Re: frequency tables and ChiSqu in SAS Programming

frequency tables and ChiSqu

Tamara3 — Thu, 13 Apr 2017 07:03:56 GMT

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;

Re: frequency tables and ChiSqu

ballardw — Thu, 13 Apr 2017 14:33:48 GMT

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;

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.

Re: frequency tables and ChiSqu

Tamara3 — Tue, 18 Apr 2017 19:21:12 GMT

Those codes worked. 🙂

Thank you for your help.