Proc Freq for categorical variables in the case and control groups

[Guerraje]

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, 

[PaigeMiller · Accepted solution]

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

The CHISQ option gives you the p-values. 

[Guerraje]

Thank you!! 

[Rick_SAS]

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

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