topic Re: Select observations that do NOT meet a criteria in SAS Programming

Select observations that do NOT meet a criteria

apple — Tue, 11 Feb 2014 08:13:51 GMT

HH_NO	X
01	9
01	3
02	9
03	1
03	2

I have a similar dataset but with more rows. I want to select all the HH_NO that do NOT have any X=9, like HH_NO=03

How do I do so?

Thank you

Re: Select observations that do NOT meet a criteria

LinusH — Tue, 11 Feb 2014 09:17:01 GMT

Many ways to this. SQL with a subquery (inner join or where) are two.

Re: Select observations that do NOT meet a criteria

kuridisanjeev — Tue, 11 Feb 2014 09:22:02 GMT

As Linush said,there are many ways to do this,

Here is one of the way,

Data test;

input a b ;

cards;

01 9

01 3

02 9

03 1

03 2

run;

Proc Sql;

select Distinct a into :value separated by ' ' from test

where b eq 9;

quit;

Data final;

set test;

if a not in (&value);

run;

Proc print;

run;

Re: Select observations that do NOT meet a criteria

kuridisanjeev — Tue, 11 Feb 2014 09:26:45 GMT

One more way,

Data test;

input a b ;

cards;

01 9

01 3

02 9

03 1

03 2

run;

Proc Sql;

select A,b from test

where a not in (Select distinct a from test where b eq 9);

quit;

Thanks,

Sanjeev.K