topic Identify the records which meet a criteria in SAS Programming

Identify the records which meet a criteria

apple — Thu, 05 Dec 2013 02:16:21 GMT

HouseNo	PersonNo	Age
1	1	12
1	2	21
2	1	55
2	2	35
2	3	40

I have a dataset like the above. I would like to identify all the HouseNo which have PersonNo who are over Age 50. How do I do so?

Thanks

Re: Identify the records which meet a criteria

Jagadishkatam — Thu, 05 Dec 2013 02:33:32 GMT

Please try

data have;

input houseno personno age;

if age > 50;

cards;

1 1 12

1 2 21

2 1 55

2 2 35

2 3 40

;

proc print;

run;

Thanks,

Jagadish

Re: Identify the records which meet a criteria

art297 — Thu, 05 Dec 2013 04:29:42 GMT

Jagadish's code will select the correct HouseNos, but will select them multiple times if there are more than one PersonNo who is older than 50. I'd suggest the following approach:

proc sql;

select distinct HouseNo

from have

where Age gt 50

;

quit;

Re: Identify the records which meet a criteria

apple — Mon, 09 Dec 2013 01:16:16 GMT

proc sql;

select distinct HouseNo

from have

where Age gt 50

;

quit;

This code works. But if I have a even more complicated dataset like the below:

House No	Person No	Age	Item Code
1	1	12	01
1	1	12	02
1	2	21	03
1	2	21	04
2	1	15	01
2	2	45	05
2	3	50	06

And I want the distinct House No and the Person No who meets the Age criteria and his Age, how do I modify the code?

Remember for each distinct House No & Person No, he can have multiple records due to the different Item Code.

Thank you

Re: Identify the records which meet a criteria

apple — Mon, 09 Dec 2013 05:11:53 GMT

Hi All

Another question is that if I want to find all HouseNo that DO NOT have any member with Age>50, how do I do so?

Thank you