topic Re: Proc Freq for categorical variables in the case and control groups in New SAS User

Proc Freq for categorical variables in the case and control groups

Guerraje — Fri, 08 Apr 2022 16:52:54 GMT

I am trying to fill out this table of categorical information (ethnicity, smoking status, ..so on) I am asked to use proc freq to do this. The code I have tried is:

Proc freq data= work.query;
by case ethnic sex smoke ;
run;

The output is below and not in the format I need. I am not sure how to change my code to get the information I am trying to get.

Thank you,

Re: Proc Freq for categorical variables in the case and control groups

PaigeMiller — Fri, 08 Apr 2022 17:00:47 GMT

Proc freq data= work.query;
tables case*(ethnic sex smoke)/chisq;
run;

The CHISQ option gives you the p-values.

Re: Proc Freq for categorical variables in the case and control groups

Rick_SAS — Fri, 08 Apr 2022 16:59:48 GMT

If you want the frequency distribution of each variable by itself, use

Proc freq data= work.query;
TABLES case ethnic sex smoke ;
run;

Re: Proc Freq for categorical variables in the case and control groups

Guerraje — Fri, 08 Apr 2022 17:03:48 GMT

Thank you!!