topic Re: difference between where end and also in SAS Programming

difference between where end and also

SRINIVAS_N — Thu, 08 Mar 2018 08:23:11 GMT

can any one help me

i am little confused difference between 'where and ' & 'also'.

Re: difference between where end and also

SASKiwi — Thu, 08 Mar 2018 08:45:24 GMT

Using WHERE ALSO allows you to apply multiple WHERE statements to a SAS procedure or DATA step simultaneously. The usual behaviour of using multiple WHERE statements is that the last one overwrites any previous ones. WHERE ALSO changes that behaviour to make ALL WHERE statements be used. For example:

proc sort data = sashelp.class
               out = class;
  by age;
  where sex = 'F';
  where also age > 14;
  * Same result as single statement: where sex = 'F' and age > 14;
run;

The effect of the two WHERE statements is to select all females aged over 14.

Re: difference between where end and also

RW9 — Thu, 08 Mar 2018 09:40:04 GMT

The simplest answer here is that in 16+ of SAS programming I have never seen where also used, nor even come across it until you posted this question. Logical operators and brackets are the ones used most.