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;
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;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.