topic Re: proc report mulstiple datasets into one excel sheet in SAS Programming

proc report mulstiple datasets into one excel sheet

bobeng — Tue, 11 May 2021 15:02:39 GMT

HI I need hellp exporting multiple dataset outputs into one sheet in excel. I am using proc report to output my data.

Re: proc report mulstiple datasets into one excel sheet

PaigeMiller — Tue, 11 May 2021 15:10:19 GMT

You can direct SAS to output multiple reports to a single sheet in Excel via the ODS EXCEL option SHEET_INTERVAL='NONE'

Example:

ods excel file="c:\myfolder\myexcelfile.xlsx" options(sheet_interval='NONE');
proc report data=whatever;
...
run;
proc report data=whatever2;
...
run;
ods excel close;

Please note: the column widths have to be the same as they are in one Excel sheet. For examplle, if the second column of the first table is wider than the second column of the second table, the Excel file makes the column wide enough for everything, even though that is too wide in the second table.

Re: proc report mulstiple datasets into one excel sheet

Cynthia_sas — Tue, 11 May 2021 15:09:44 GMT

Hi:

ODS EXCEL has a suboption called "sheet_interval" if you want multiple procedure steps (whether multiple PROC REPORTS or a mix of procedures), all you need to do is use the correct suboption. Here's an example:

Cynthia