topic Re: Stack 2 Tables with Proc Report in SAS Programming

Stack 2 Tables with Proc Report

angeliquec — Thu, 17 Jan 2019 01:11:10 GMT

Hi, I'd like to stack two of my tables in one sheet. Let's say I made a Proc report output for each table, but I'm unable to combine these two tables into 1 sheet, same as attached. Thank you!

data table1;
input text :$20. column1 column2;
cards;
table_1_counts 6 4
;
run;

data table2;
input text :$20. column1 column2;
cards;
table_2_counts 6 4
;
run;

proc report data=table1 out=t1 nowd;
column text column1 column2;
run;
proc report data=table2 out=t2 nowd;
column text column1 column2;
run;

Re: Stack 2 Tables with Proc Report

Reeza — Thu, 17 Jan 2019 01:21:11 GMT

I would suggest combining your original data and use PROC REPORT with a BY statement or GROUP variable and customize the header for each group.
BY is probably easier.

Re: Stack 2 Tables with Proc Report

ballardw — Thu, 17 Jan 2019 15:50:17 GMT

@angeliquec wrote:

Hi, I'd like to stack two of my tables in one sheet. Let's say I made a Proc report output for each table, but I'm unable to combine these two tables into 1 sheet, same as attached. Thank you!

data table1;
input text :$20. column1 column2;
cards;
table_1_counts 6 4
;
run;

data table2;
input text :$20. column1 column2;
cards;
table_2_counts 6 4
;
run;

proc report data=table1 out=t1 nowd;
column text column1 column2;
run;
proc report data=table2 out=t2 nowd;
column text column1 column2;
run;

One sheet of what?

You don't specify an output destination so we have to assume that the output is HTML which really does not have a concept of "sheet" or "page".

Almost certainly your ODS destination would have one or more options that would attempt to place the output on a single "sheet" if specified properly.

If using ODS Excel or tagsets.excelxp the likely specifying options(sheet_interval='NONE') would have all of the output on a single sheet.

ODS RTF option STARTPAGE=NO would attempt to place all following output on the same page put may not if the tables plus spaces between are too many rows.