Output Data set

[spg]

Hi,

Is it possible to run a series of cross tabulations (say from a survey questionnaire) and save all the outputs in one single table? If I do:

PROC FREQ DATA= WORK. SURVEY;
TABLES Q1*Q51/ NOROW NOPERCENT;
TABLES Q2*Q51/ NOROW NOPERCENT;
TABLES Q3*Q51/ NOROW NOPERCENT/ OUT=WORK.SURVEYOUT;
RUN;

The output table records only the last cross tabulation, in this case Q3*Q51

Thanks.

[Tim_SAS]

You can use the ODS OUTPUT statement for this:

[pre]
ods output crosstabfreqs=surveyout;
proc freq data=survey;
tables q1*q51 / norow nopercent;
tables q2*q51 / norow nopercent;
tables q3*q51 / norow nopercent;
run;
ods output close;
proc print data=surveyout;
run;
[/pre]

[spg]

Thanks Tim!