Turning SAS PROC REPORT output back into tables
August 14, 2008 3:12 PM Subscribe
SAS guru question: Is there an easy way to turn voluminous txt multi-page SAS reports generated with PROC REPORT back into a series "one observation per row" SAS tables? I know I can do it with a medium size Perl or Python script but I'm assuming someone must have dealt with this problem before, likely in SAS itself.
A lot of the reports are also grouped using DEFINE Region / GROUP which is output on the upper left hand side of the page, e.g.
A lot of the reports are also grouped using DEFINE Region / GROUP which is output on the upper left hand side of the page, e.g.
Table 26 Resources by Country 1 Group: USA Region Type Museums Camping ________________________________________ East NM 2 0 NP 8 12 West NM 8 17 NP 4 9 Group: Canada Region Type Museums Camping ________________________________________ East NM 7 0 NP 9 12 West NM 8 7 NP 18 14
[guest answer from the hubbie]
If you have the code that generates the PROC report, try looking at the ODS(output delivery system) options. You should have many options. ODS options are different for every procedure, and he doesn't know them off the top of his head right now, but he thinks this is very doable within SAS.
posted by ebellicosa at 7:24 PM on August 14, 2008
If you have the code that generates the PROC report, try looking at the ODS(output delivery system) options. You should have many options. ODS options are different for every procedure, and he doesn't know them off the top of his head right now, but he thinks this is very doable within SAS.
posted by ebellicosa at 7:24 PM on August 14, 2008
Response by poster: Thanks for the tips, but I do not have access to the original SAS code or tables which generated the output. I should have stated that more clearly in the original question.
posted by benzenedream at 11:28 PM on August 14, 2008
posted by benzenedream at 11:28 PM on August 14, 2008
« Older What qualifies as a 'school cost' for early IRA... | Finding the elusive, decent Brooklyn apartment? Newer »
This thread is closed to new comments.
posted by netbros at 4:28 PM on August 14, 2008