BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
asimraja
Fluorite | Level 6

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;

1 ACCEPTED SOLUTION

Accepted Solutions
BrunoMueller
SAS Super FREQ

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

2 REPLIES 2
BrunoMueller
SAS Super FREQ

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
Fluorite | Level 6
Bruno_SAS,

Thank you for your help!

Regards,
Asim

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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