BookmarkSubscribeRSS Feed
BCNAV
Quartz | Level 8

Is there a way to turn off the SAS Report that automatically is populated on running ODS?

 

I have the following:

 

ods listing close;
ods html close;
goptions device=actximg;
ods excel file="\\NCRFP4\TAF\Traffic Analysis\Major New Analysis Projects\Rebate Analysis\Raw Data by Fee\Amount by Fee.xlsx";
ods excel options(start_at="1,1" sheet_name="TERM" sheet_interval="table" embedded_titles='no');
proc print data=EGTASK.REBATE_RAW_TERM noobs; run;
ods excel options(start_at="1,1" sheet_name="ENR" sheet_interval="table" embedded_titles='no');
proc print data=EGTASK.REBATE_RAW_ENR noobs; run;
ods excel options(start_at="1,1" sheet_name="OVR" sheet_interval="table" embedded_titles='no');
proc print data=EGTASK.REBATE_RAW_OVR noobs; run;
ods excel options(start_at="1,1" sheet_name="NAT" sheet_interval="table" embedded_titles='no');
proc print data=EGTASK.REBATE_RAW_NAT noobs; run;
ods excel options(start_at="1,1" sheet_name="ICOMM" sheet_interval="table" embedded_titles='no');
proc print data=EGTASK.REBATE_RAW_ICOMM noobs; run;
ods excel options(start_at="1,1" sheet_name="DAILY" sheet_interval="table" embedded_titles='no');
proc print data=EGTASK.REBATE_RAW_DAILY noobs; run;
ods excel close;

All runs fine, but I get SAS Report - Output to Excel ouput created in  my EG window. Only the Excel is needed. Is there an option to suppress the report but not the Excel write?  thanks

 

3 REPLIES 3
ballardw
Super User

ODS NORESULTS;

 

will prevent sending output to the results window.

BCNAV
Quartz | Level 8

thanks...I had tried that. It turns off both the listing report as well as the display of the Excel file on the screen (it is written fine though). I wsa hoping to keep the Excel file as a display item without the SAS Listing Report. Seems like this can't be done.

PGStats
Opal | Level 21

Try

 

ods listing select none;

.....

ods listing select all;

PG

sas-innovate-2024.png

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.

 

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
  • 3 replies
  • 1770 views
  • 0 likes
  • 3 in conversation