The SAS Output Delivery System and reporting techniques

Excel Tagset : Have 4 proc print output in one sheet

Reply
Frequent Contributor
Posts: 99

Excel Tagset : Have 4 proc print output in one sheet

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;

Super User
Posts: 19,188

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

RTM or website.

Try the sheet_interval option.

SAS Super FREQ
Posts: 8,820

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


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;

Trusted Advisor
Posts: 1,296

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

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;

Ask a Question
Discussion stats
  • 3 replies
  • 321 views
  • 0 likes
  • 4 in conversation