topic Re: Use Proc Print to put multiple SAS outputs in one table in ODS and Base Reporting

Use Proc Print to put multiple SAS outputs in one table

bzubrick — Wed, 16 Aug 2017 18:24:06 GMT

I use SAS to create 3 data sets. then I use PROC PRINT per the code below to create 3 excel files which show their data. Is there anyway to make a statement that puts all 3 data sets as diffferent tabs in the same excel file???

ods excel file='D:\qsilver\SAS Data\BZ\3_Output\TotalOutput5k.xlsx' style=meadows;
Proc print data=work.histodata_Total noobs label;
run;
ods excel close;



ods excel file='D:\qsilver\SAS Data\BZ\3_Output\RefiOutput5k.xlsx' style=meadows;
Proc print data=work.histodata_refi noobs label;
run;
ods excel close;


ods excel file='D:\qsilver\SAS Data\BZ\3_Output\PurchaseOutput5k.xlsx' style=meadows;
Proc print data=work.histodata_purchase noobs label;
run;
ods excel close;

Re: Use Proc Print to put multiple SAS outputs in one table

DaveHorne — Wed, 16 Aug 2017 18:41:42 GMT

One way is via the XLSX engine:

libname xlout XLSX 'D:\qsilver\SAS Data\BZ\3_Output\Output5k.xlsx';

data xlout.Total;
  set work.histodata_Total;
run;

data xlout.Refi;
  set work.histodata_Refi;
run;

data xlout.Purchase;
  set work.histodata_Purchase;
run;

libname xlout clear;

See Chris' blog post for more details: Using LIBNAME XLSX to read and write Excel files

Re: Use Proc Print to put multiple SAS outputs in one table

bzubrick — Wed, 16 Aug 2017 18:46:34 GMT

Genius! Exactly what I needed, thank you!!!