topic Re: How to create a frequency table with two variables in New SAS User

How to create a frequency table with two variables

Kimberly_2020 — Mon, 17 Aug 2020 16:14:33 GMT

Hello there!

My instructions were to create a frequency table for race AND sexual orientation showing percent as well as frequency? What am I doing wrong?

proc freq data=WORK.SYPHILIS;
	tables RACE AND sex_o;
run;

ballardw — Mon, 17 Aug 2020 16:20:37 GMT

You use the * to indicate a "cross" in the tables statement

proc freq data=WORK.SYPHILIS;
	tables RACE * sex_o;
run;

You can use () to compare multiple variables with one or more other groups of variables.

proc freq data=WORK.SYPHILIS;
	tables (RACE othervar) * (sex_o  somevar);
run;

would create tables for race*sex_o, race*somevar, othervar*sex_o and othervar*somevar.

Kimberly_2020 — Mon, 17 Aug 2020 16:39:45 GMT

Thank you!