As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


WHERE, Oh, WHERE Art Thou? A Cautionary Tale for Using WHERE Statements and WHERE= Options

From sasCommunity
Jump to: navigation, search

WHERE, Oh, WHERE Art Thou? A Cautionary Tale for Using WHERE Statements and WHERE= Options
presented by Britney Gilbert, Juniper Tree Consulting


This paper discusses common pitfalls when using WHERE.


Using WHERE statements in your SAS® programming can make processing data more efficient. However, the programmer needs to have a full understanding and be aware of how SAS processes multiple WHERE statements or combinations of WHERE statements and WHERE= dataset options in DATA steps and PROCEDURES. This presentation explores examples of the combinations of WHERE statements and WHERE= dataset options in both DATA steps and PROCEDURES and the resulting logs and output.




Presented at the SAS Users of Oregon Conference 2014 in Portland, OR.

Find more SOSUG presentations, as well as other tips, tricks, and tools created by or recommended by SOSUG members here.