Combine Two or More Proc Report Outputs into 1 Output

[albertsamaniego]

How do I combine two or more proc report outputs with different column names into 1 single table?

[Reeza]

Depends on how you created the output in the first place....what is the code you're using and what output format/destination (PDF, RTF, Excel).

[albertsamaniego]

I need to output it as an rtf file.

[Reeza]

Depends on how you created the output in the first place....what is the code you're using and what output format/destination (PDF, RTF, Excel).

---

@albertsamaniego wrote:

I need to output it as an rtf file.

---

That's an answer to part of it....You can probably use PROC REPORT with BY statements and BREAKS to create this type of report. 

Note that I'm moving your question to the Reporting forum.

[Cynthia_sas · Accepted solution]

Hi,

As @Reeza pointed out, without seeing your code, it is hard to speculate. However, with PROC REPORT, you only have 2 options for producing your reports -- with COMPUTE BEFORE a break variable or COMPUTE BEFORE _PAGE_ with BY group processing. The headers will repeat with BY groups. I think #2 report comes closer to what you showed (using SASHELP.SHOES, sorted by REGION):

The #1 report used COMPUTE BEFORE REGION and that does not repeat the spanning headers or the column headers, as you can see in #1.

cynthia