proc freq like group by

[Angel_Saenz]

Is it possible to use proc freq as like in proc sqp gruoup by? using some variables and counting?

because if I use this:

proc freq data=ds;

table var1 var2;

run;

that creates two separate tables and what I want is to combine var1 and var2

[VDD]

you can use the by statement with proc freq

https://support.sas.com/documentation/cdl/en/statug/63962/HTML/default/viewer.htm#statug_freq_sect00...

https://support.sas.com/documentation/cdl/en/statug/63962/HTML/default/viewer.htm#statug_freq_sect00...

[Astounding · Accepted solution]

See if this comes closer to what you want:

proc freq data=ds;
tables var1 * var2 / missing list;
run;