topic Re: Combine Two or More Proc Report Outputs into 1 Output in ODS and Base Reporting

Combine Two or More Proc Report Outputs into 1 Output

albertsamaniego — Mon, 23 Apr 2018 02:28:10 GMT

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

Re: Combine Two or More Proc Report Outputs into 1 Output

Reeza — Mon, 23 Apr 2018 02:45:47 GMT

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).

Re: Combine Two or More Proc Report Outputs into 1 Output

albertsamaniego — Mon, 23 Apr 2018 02:50:48 GMT

I need to output it as an rtf file.

Re: Combine Two or More Proc Report Outputs into 1 Output

Reeza — Mon, 23 Apr 2018 03:25:36 GMT

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.

Re: Combine Two or More Proc Report Outputs into 1 Output

Cynthia_sas — Mon, 23 Apr 2018 15:52:38 GMT

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