crosstab of multiple variables with the same prefix

lizzy28 — Fri, 12 Jul 2019 16:35:39 GMT

Hi everyone,

I'd like to ask if there is an easy to way to do crosstab of many variables with the same prefix.

For my data, there are 45 fields, Q1-Q45, and 45 corresponding recoded variables based on Q1-Q45, rQ1-rQ45. I want to make sure that the recoding is done right by checking crosstab like

proc freq data=mydata;

table Q1*rQ1 Q2*rQ2 Q3*rQ3 … Q45*rQ45;

run;

I want to have something quick rather than typing each set from Q1 to Q45. Any thoughts?

Thank you!

Lizi

Re: crosstab of multiple variables with the same prefix

PaigeMiller — Fri, 12 Jul 2019 16:42:21 GMT

A simple macro would work

%macro dothis;
proc freq data=mydata;
  table %do i=1 %to 45; Q&i*rQ&i %end; ;
run;
%mend;
%dothis

topic crosstab of multiple variables with the same prefix in SAS Procedures

crosstab of multiple variables with the same prefix

Re: crosstab of multiple variables with the same prefix