topic Re: Output Data set in SAS Procedures

Output Data set

spg — Tue, 28 Jul 2009 21:04:40 GMT

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.

Re: Output Data set

Tim_SAS — Wed, 29 Jul 2009 12:21:50 GMT

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]

Re: Output Data set

spg — Wed, 29 Jul 2009 19:03:21 GMT

Thanks Tim!