topic Re: 3-Way Tables - PROC TABULATE v. PROC FREQ in New SAS User

3-Way Tables - PROC TABULATE v. PROC FREQ

_maldini_ — Wed, 15 Feb 2023 18:13:07 GMT

Is there a way to create a 3-way table in PROC FREQ where the 3 variables are all in one table? I know this can be done in PROC TABULATE.

In PROC FREQ, when I cross the 3 variables (e.g., tables var1*var2*var3), I get bivariate analyses for var2 and var3 for each level of var1 in a separate table.

Thanks.

Re: 3-Way Tables - PROC TABULATE v. PROC FREQ

data_null__ — Wed, 15 Feb 2023 18:27:01 GMT

I think you may want to the TABLE statement options LIST or CROSSLIST

Re: 3-Way Tables - PROC TABULATE v. PROC FREQ

ballardw — Wed, 15 Feb 2023 18:34:01 GMT

In proc freq the option LIST will place all of the variable on one row with the count and percent similar to a one-way table:

Tables var1*var2*var3*var4 / list ;

IF you might have missing values for any of the variables you likely will want to add the MISSING option as well, otherwise combinations of variables that include missing values will not be shown.