topic Re: PROC FREQ / SURVEYFREQ | Multiple 2-way Tables in New SAS User

PROC FREQ / SURVEYFREQ | Multiple 2-way Tables

_maldini_ — Mon, 13 Mar 2023 18:37:42 GMT

I want to create multiple 2-way tables to assess bivariate associations between categorical variables. Basically, I want all possible 2-way combinations of the variables.

I'm using a macro variable to represent the list of variables:

%let cat_vars = 
	sex
	race_all
	edu
	hh_income
	etoh_days_per_wk
	smk_status
	lipid_meds 
	diab_meds 
	;

Is there syntax that will spare me from having to type out all possible combinations of these variables?

Thanks.

Re: PROC FREQ / SURVEYFREQ | Multiple 2-way Tables

ballardw — Mon, 13 Mar 2023 19:02:23 GMT

Since you didn't show any actual Proc freq or surveyfreq code the answer is "maybe".

You can use ( ) to indicate a group of variables to compare with others in a table statement:

(a b c) * (d e) for example will do tables a*d b*d c*d a*e b*e c*e.

So if you have a group of demographic variables such as sex, age group, race, ethnicity that you want to compare with responses like income those are easy. Have the demographics in one set of parentheses and the other responses in a different group.

Or if you really want all with all , where you will get sex*sex as a result

Tables (&cat_vars.) * (&cat_vars);

For the truly lazy that want to generate horrific amounts of output perhaps: tables _all_ * _all_ ;

The tables statements in Freq and Surveyfreq will accept the list words _all_ (every single variable), _numeric_ (all the numeric variables) and/or _character_ all of the character variables.

Re: PROC FREQ / SURVEYFREQ | Multiple 2-way Tables

_maldini_ — Mon, 13 Mar 2023 19:47:53 GMT

proc surveyfreq data=work.data_2009_2018;
 	stratum sdmvstra;
 	cluster sdmvpsu;
 	weight wtmec10yr_09_18;
 	tables 	(&cat_vars)*(&cat_vars) / chisq;
run;

Yes, I do, even though I would just disregard sex*sex, race*race and other 2-way tables involving the same variable.

When I use the syntax above, I get an error in the log:

Thanks for your help.