The SAS Output Delivery System and reporting techniques

Not Printing on SAS Output while creating XML based Excel file

Accepted Solution Solved
Reply
Contributor
Posts: 32
Accepted Solution

Not Printing on SAS Output while creating XML based Excel file

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;


Accepted Solutions
Solution
‎09-25-2015 06:23 AM
SAS Super FREQ
Posts: 706

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

[ Edited ]

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;

 

 

 

View solution in original post


All Replies
Solution
‎09-25-2015 06:23 AM
SAS Super FREQ
Posts: 706

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

[ Edited ]

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;

 

 

 

Contributor
Posts: 32

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

Bruno_SAS,

Thank you for your help!

Regards,
Asim
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 373 views
  • 0 likes
  • 2 in conversation