![Screen Shot 2022-04-08 at 10.47.09 AM.png Screen Shot 2022-04-08 at 10.47.09 AM.png](https://communities.sas.com/t5/image/serverpage/image-id/70246i892457FA2205F22C/image-size/small?v=v2&px=200)
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,
![Screen Shot 2022-04-08 at 10.51.54 AM.png Screen Shot 2022-04-08 at 10.51.54 AM.png](https://communities.sas.com/t5/image/serverpage/image-id/70247i01D4E03B9065615E/image-size/large?v=v2&px=999)