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.
As part of the decommissioning effort for sasCommunity.org this article/tip has been migrated to communities.sas.com.
The new home for this article/tip is Where also (https://communities.sas.com/t5/SAS-Tips-from-the-Community/SAS-Tip-where-also/m-p/442603)
You can use an ALSO operator in a WHERE statement (or function). Use a series of WHERE statements instead of a single statement. The condition clauses are combined as if you wrote a single WHERE statement with the condition clauses ANDed together. For example,
proc print data = sashelp.class; Title 'Teenage Boys'; where Sex = 'M'; where also Age > 12; run;
produces the same output that the following WHERE statement would.
where Sex = 'M' and Age > 12;