topic Re: Output multiple proc freq tables in SAS Programming

Output multiple proc freq tables

Maisha_Huq — Tue, 20 Jan 2015 14:40:39 GMT

Hello!

I have multiple frequency tables which I've ouputted to a PDF, where each table is for one of n sites from the a given data set. I'd like to join these n tables together into one, however. Would you have suggestions for how?

Many thanks in advance!

Re: Output multiple proc freq tables

mohamed_zaki — Tue, 20 Jan 2015 14:53:15 GMT

Use

ODS OUTPUT ONEWAYFREQS;

Re: Output multiple proc freq tables

Maisha_Huq — Tue, 20 Jan 2015 14:58:28 GMT

To clarify, I have tables in this format:

Title: Site1

Freq Count

RA=Treatment

RA= Control

but I'd like it as follows

Site1 Freq Count

RA=Treatment

RA= Control

Site2

RA=Treatment

RA= Control

Site3

RA=Treatment

RA= Control

...

Would onewayfreqs work for this?

Thank you!

Re: Output multiple proc freq tables

Reeza — Tue, 20 Jan 2015 15:07:51 GMT

Look at proc tabulate instead since I assume you're using ODS.

If you want a bit more manual control look at the code here:

SAS - One Way Summary Table