topic Re: how to subset based on 2 variables in SAS Programming

how to subset based on 2 variables

burtsm — Fri, 17 Apr 2015 01:41:02 GMT

I'd like to create a data set containing only observations that have a record where FIRST=1 within each ID group. In the example below, I'd like to keep all observations except those where ID=60, since this ID group does not have any records where FIRST=1.

HAVE:

ID FIRST

7 0

7 1

18 0

18 1

56 0

56 1

60 0

76 0

76 1

WANT:

ID FIRST

7 0

7 1

18 0

18 1

56 0

56 1

76 0

76 1

This seems like it should be very simple coding, but I'm spinning my wheels here!

Thank you,

Stephanie

Re: how to subset based on 2 variables

Reeza — Fri, 17 Apr 2015 02:07:30 GMT

Are you looking for a data step or SQL solution? What hasn't worked for you?

Re: how to subset based on 2 variables

stat_sas — Fri, 17 Apr 2015 02:20:52 GMT

proc sql;

create table want as

select * from have

group by id

having sum(first)>0

order by id, first;

quit;

Re: how to subset based on 2 variables

Jagadishkatam — Fri, 17 Apr 2015 03:17:23 GMT

Alternatively via data step

proc sort data=have;

by id descending first;

run;

data want;

set have;

by id descending first;

retain test;

if first.id then test=first;

if test>0;

drop test;

run;

Thanks,

Jag

Re: how to subset based on 2 variables

burtsm — Fri, 17 Apr 2015 23:39:23 GMT

I am much more familiar/comfortable with coding using data step.

The response by Jag below worked for me.

Re: how to subset based on 2 variables

burtsm — Fri, 17 Apr 2015 23:40:34 GMT

Thank you!