In honor of the 2012 Olympics, this week’s SAS tip is from award-winning UK author Phil Mason and his book In the Know...SAS Tips and Techniques from Around the Globe, Second Edition. SAS user Ron Fehd proclaimed Phil Mason "one of the SAS user community's famous creative tinkerers--the SAS user version of mild-mannered Clark Kent." However, it's no secret that Phil Mason is a master of SAS tips.
The following excerpt is from SAS Press author Phil Mason and his book "In the Know...SAS Tips and Techniques from Around the Globe, Second Edition" Copyright © 2006, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED. (please note that results may vary depending on your version of SAS software)
Useful secret options
To discover some secret SAS options, you can run PROC OPTIONS with the INTERNAL parameter, which lists the internal, undocumented, unsupported options. This code produces a listing consisting of four sections:
proc options internal; run;
- internal portable options
- portable options
- internal host options
- host options
Running this code in SAS 9.1.2 reveals some interesting options such as:
The log is buffered. Switching to UNBUFLOG can be useful for viewing the log in a file while SAS is running.
Weighting factor for index costing, which can be adjusted to alter the way indexes are used.
Number of index file buffers, which can be altered to assist performance.
Threaded kernel code generator.
There are many other options, and it is worth looking through the list to see if anything might be of interest to you.
Visit Phil Mason's author page for bonus content including user reviews and a free chapter from his book.