I am producing many tables using various procedures (proc means, proc freq and proc tabulate) and from various data sets and I am looking for a way to create a report that combines the results from each procedure. Currently, I am opening html file(s) in Excel and then linking the cells I want from each table to a cell in a master table/report.
I'm hoping for a more efficient way to do this.
Thank you for the suggestion. I see the usefulness of proc DOCUMENT but unfortunately it is not quite what I need - at least at the level of understanding I have of the procedure.
Let me give you an example of what I am trying to do - here is a segment of the table I want to produce:
_____________2007data______2008 data_______2009 data
Resident
Non-Resident
So there are two groups that I am comparing data from across years. Right now I have to produce the results for each year in a separate table(they come from separate data sets) and then combine them into one table in Excel later. I'm curious about producing a table in SAS that is already combined as in the above example.