BookmarkSubscribeRSS Feed
🔒 This topic is locked. We are no longer accepting replies to this topic. Need further help? Please sign in and ask a new question.
SAS_Tipster
Moderator

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;

Note that the first WHERE statement can also use the ALSO modifier even if there is no prior WHERE statement:

proc print data = sashelp.class;
 title 'Teenage Boys';
 where also Sex = 'M';
 where also Age > 12;
run;

Thanks to Don Henderson for sharing this tip on sasCommunity.org.

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!

Visit a random SAS tip This SAS Tips board is not open for replies or comments, but we welcome your feedback and questions. Have a question or comment about this tip? Start a new topic in one of our discussion boards, and reference this tip topic.
Discussion stats
  • 0 replies
  • 5141 views
  • 7 likes
  • 1 in conversation