Not Printing on SAS Output while creating XML based Excel file

asimraja — Mon, 14 Sep 2015 00:41:59 GMT

Hi,

I'm creating an XML based Excel compatible file. However, this file is pretty big so the the SAS Output gets full and keeps asking me to clear it. I tried the "noprint" option but it doesn't work. Is there a way to create the Excel file yet not print anything to the SAS Output?

Thank you in advance!

Asim

-------------------------------------------------------------------------------------------

ods tagsets.excelxp file="&output_dir./Losses_&run_id..xls" style=normal;

   ods tagsets.excelxp options(sheet_name="Losses_&run_id.");
   PROC PRINT DATA=outdir.losses noobs;
       var SECU_CUSIP_ID / style={TAGATTR='format:text'};
       var cf_dt sellhold_sector recourse_group balance principal interest
           base_loss_adj_prin base_prin_loss base_prin_recovery Base_loss_adj_int expected_lossOfPrin
           stress_loss_adj_prin stress_prin_loss stress_prin_recovery Stress_Loss_Adj_int stress_lossOfPrin
           ;
   RUN;

ods tagsets.excelxp close;

Re: Not Printing on SAS Output while creating XML based Excel file

BrunoMueller — Mon, 14 Sep 2015 08:16:15 GMT

You should close the ODS destination that you do not need.

One way is to add

ods _all_ close;

before your code. This will close any open destination.

To get "normal" out put again, you can open the Listing destination after your code.

ods listing;

Re: Not Printing on SAS Output while creating XML based Excel file

asimraja — Mon, 14 Sep 2015 23:29:44 GMT

Bruno_SAS,

Thank you for your help!

Regards,
Asim

topic Not Printing on SAS Output while creating XML based Excel file in ODS and Base Reporting

Not Printing on SAS Output while creating XML based Excel file

Re: Not Printing on SAS Output while creating XML based Excel file

Re: Not Printing on SAS Output while creating XML based Excel file