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

Hi,

 

SAS is writing below messages for every observation which is getting processed while performing a business logic.

 

The number of observations getting processed is in millinons so below messages are also written to SASLOG that many million times.

 

INFO: Index PK_TBLROW0X selected for WHERE clause optimization.       
INFO: Use of index PK_TBLROW0X for WHERE clause optimization canceled.

Is there any way we can suppress log messages issued by SAS which start with "INFO:" ?

1 ACCEPTED SOLUTION

Accepted Solutions
Tim_SAS
Barite | Level 11

I suspect you've got MSGLEVEL=I set somewhere. Set MSGLEVEL=N (or let it default) instead.

 

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000279149.htm

View solution in original post

2 REPLIES 2
Tim_SAS
Barite | Level 11

I suspect you've got MSGLEVEL=I set somewhere. Set MSGLEVEL=N (or let it default) instead.

 

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000279149.htm

SuryaKiran
Meteorite | Level 14

Set the options as

options msglevel=N;

Thanks,
Suryakiran

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1984 views
  • 1 like
  • 3 in conversation