BookmarkSubscribeRSS Feed
SRINIVAS_N
Calcite | Level 5

can any one help me 

 

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

 

 

2 REPLIES 2
SASKiwi
PROC Star

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.

 

RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 698 views
  • 0 likes
  • 3 in conversation