DATA Step, Macro, Functions and more

difference between where end and also

Reply
Contributor
Posts: 21

difference between where end and also

can any one help me 

 

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

 

 

Super User
Posts: 4,033

Re: difference between where end and also

[ Edited ]
Posted in reply to SRINIVAS_N

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.

 

Super User
Super User
Posts: 9,866

Re: difference between where end and also

Posted in reply to SRINIVAS_N

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.

Ask a Question
Discussion stats
  • 2 replies
  • 94 views
  • 0 likes
  • 3 in conversation