Not Printing on SAS Output while creating XML based Excel file

[asimraja]

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;

[BrunoMueller · Accepted solution]

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;

[asimraja]

Bruno_SAS,

Thank you for your help!

Regards,
Asim