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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.