topic Re: Excel Tagset : Have 4 proc print output in one sheet in ODS and Base Reporting

Excel Tagset : Have 4 proc print output in one sheet

AmitKB — Mon, 11 Feb 2013 20:27:02 GMT

Hi all,

I want to create excel worksheet having output from 4 different proc prints. Currently it is creating 4 different worksheet.

I appreciate all your help.

Regards,

Amit

ods tagsets.excelxp file="Test.xls"
                          path="XXXXX"
                          options(sheet_name='test' autofit_height='yes'
     orientation='landscape' ) style=default;

         proc print data=combo;
run;

proc print data=ModelCStat;
run;

proc print data=ModelCTable;
run;

proc print data=ModelResProfile;
run;
ods tagsets.excelxp close;

Re: Excel Tagset : Have 4 proc print output in one sheet

Reeza — Mon, 11 Feb 2013 21:49:18 GMT

RTM or website.

Try the sheet_interval option.

Re: Excel Tagset : Have 4 proc print output in one sheet

Cynthia_sas — Mon, 11 Feb 2013 22:19:56 GMT

And, in order to read the internal documentation, use the doc='Help' suboption, as shown below.

cynthia

ods tagsets.excelxp file="Test.xls" style=default;

path="XXXXX"

options(doc='Help' sheet_name='test'

autofit_height='yes'

orientation='landscape' );

....more code here....

ods tagsets.excelxp close;

Re: Excel Tagset : Have 4 proc print output in one sheet

MichelleHomes — Tue, 12 Feb 2013 03:35:03 GMT

As Reeza suggests, use the sheet_interval option...

ods tagsets.excelxp file="Test.xls"

path="XXXXX"

options(sheet_interval="none" sheet_name='test' autofit_height='yes'

orientation='landscape' ) style=default;