BookmarkSubscribeRSS Feed
Maisha_Huq
Quartz | Level 8

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!

3 REPLIES 3
mohamed_zaki
Barite | Level 11

Use

ODS OUTPUT ONEWAYFREQS;

Maisha_Huq
Quartz | Level 8

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!

Reeza
Super User

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1227 views
  • 3 likes
  • 3 in conversation