Excel Tagset : Have 4 proc print output in one sheet

[AmitKB]

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;

[Reeza]

RTM or website.

Try the sheet_interval option.

[Cynthia_sas]

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;

[MichelleHomes]

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;