topic Re: Combining html tables in ODS and Base Reporting

Combining html tables

deleted_user — Tue, 23 Jun 2009 13:41:48 GMT

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.

Re: Combining html tables

Peter_C — Wed, 24 Jun 2009 05:37:53 GMT

have you looked at proc DOCUMENT ?

Re: Combining html tables

deleted_user — Wed, 24 Jun 2009 13:05:46 GMT

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.