topic Re: two Where conditions in SAS Programming

two Where conditions

Ronein — Wed, 12 Sep 2018 04:40:13 GMT

Hello

May anyone explain why in the following query we get 5 rows.

The condition is :

where Gender="M";
where age>25;

Does it mean that the query is taking Males AND age>25?

In the result I see also Female.

Thanks

Yuli

Data Raw_tbl;
input name $ Gender $ age  ;
cards;
Anna F 23
Ben M 25
Bob M 21
Brian M 27
Edward M 26
Emma F 32
Joe M 34
Sam F 32
Tom M 24
;
run;


data  tbl2;
set Raw_tbl;
where Gender="M";
where age>25;
run;

Re: two Where conditions

SASKiwi — Wed, 12 Sep 2018 04:48:09 GMT

In your example the second WHERE overwrites the first one. If you want both to be used (the equivalent of using an AND between them) do this:

data  tbl2;
set Raw_tbl;
where Gender="M";
where also age>25;
run;

Re: two Where conditions

Reeza — Wed, 12 Sep 2018 04:51:00 GMT

Always check your log.

If you do want both, add an SAME AND after the second WHERE, but before age.

Where same and age>25;

@Ronein wrote:

Hello

May anyone explain why in the following query we get 5 rows.

The condition is :

where Gender="M";
where age>25;

Does it mean that the query is taking Males AND age>25?

In the result I see also Female.

Thanks

Yuli
Data Raw_tbl;
input name $ Gender $ age  ;
cards;
Anna F 23
Ben M 25
Bob M 21
Brian M 27
Edward M 26
Emma F 32
Joe M 34
Sam F 32
Tom M 24
;
run;


data  tbl2;
set Raw_tbl;
where Gender="M";
where age>25;
run;

Re: two Where conditions

Kurt_Bremser — Wed, 12 Sep 2018 05:45:14 GMT

A clear case for Maxim 2.

Re: two Where conditions

Ronein — Wed, 12 Sep 2018 05:50:07 GMT

As I see there are 2 equivalent way:

where also age>25;

where same age>25;

Is there a difference between "SAME" and "ALSO"?

Re: two Where conditions

RW9 — Wed, 12 Sep 2018 07:58:20 GMT

Use logical operands in your where clause:

where <condition> and/or <condition> and/or <condition>...;

I have never heard of, nor seen where also or where same being used.