two Where conditions

[Ronein]

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;

[SASKiwi]

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;

[Reeza]

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;

---

[Ronein]

As I see there are 2 equivalent way:

where also age>25;

where same age>25;

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

[RW9]

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.

[Kurt_Bremser]

A clear case for Maxim 2.