Extracting patients based on number of observations

[sarahsasuser]

Hi All,

I have a data set of patient visits. We want to extract only the patients who have at least 2 visits. How do I do this?

Have:

id      visit#

a         1

a         2

a         3

a         4

b         1

c         1

c         2

c         3

d         1

The data set I want would only include ids a and c.

Thanks!

[FredrikE · Accepted solution]

Something like this?

data test;

length id visit $1;

input id visit;

datalines;

a 1

a 2

a 3

a 4

b 1

c 1

c 2

c 3

d 1

;

run;

proc sql;

create table sel as

select id

from test

group by id

having count(visit) > 1

;

quit;

data test1;

merge test (in=a) sel (in=b);

by id;

if a and b;

run;

//Fredrik

[RW9]

data want;
  set have;
  by id;
  if if first.id and last.id then delete;
run;

Removes any records where there is only one recor per id.

[FredrikE]

Sweet!

[sarahsasuser]

I like it, but we may decide we want to include people with more observations down the line. I think I'll try FredrikE's method. Thanks!

[FredrikE]

Replace my merge with:
Proc sql;
Create table new as select a.* from test as a inner join visits as b on a.id = b.id; quit;
Then you don not need to have data sorted.