SAS Tip: where also (Daily tip for 2024-Jul-23)


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.

READ this complete tip   Visit a random SAS tip

Start a topic
About these Tips
A "SAS tip" is a basic unit of information exchange between SAS users. The tips on this board come from sasCommunity.org, from SAS user conferences, from SAS blogs, and from freelance contributions from SAS users like you. We hope that you're able to always learn something new here!


» How you can contribute


Tip-o-meter: 63 tips