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.