topic Re: Extracting all records for only two unique variable values in SAS Programming

Extracting all records for only two unique variable values

devsas — Thu, 20 Jun 2019 16:56:25 GMT

Good afternoon everyone! I have a dataset where there are multiple records for each member id along with claim numbers and other fields. I want to extract just a sample for two members with all their corresponding multiple records.

Data have;
input mem_id  $ claim_id $ amount dos :mmddyy10.;
format dos mmddyy10.;
datalines;
A 1 100 01/01/2017
A 1 200 01/01/2017
A 2 150 01/02/2017
B 3 50 01/01/2018
B 4 70 01/02/2018
C 5 10 01/01/2019
C 5 15 01/01/2019
;

Data want;
input mem_id  $ claim_id $ amount dos :mmddyy10.;
format dos mmddyy10.;
datalines;
A 1 100 01/01/2017
A 1 200 01/01/2017
A 2 150 01/02/2017
B 3 50 01/01/2018
B 4 70 01/02/2018
;

Thanks!

Re: Extracting all records for only two unique variable values

Kurt_Bremser — Thu, 20 Jun 2019 17:01:00 GMT

How about

proc sort
  data=have (keep=mem_id)
  out=members (obs=2)
  nodupkey
;
by mem_id;
run;

proc sort data=have;
by mem_id dos;
run;

data want;
merge
  have
  members (in=m)
;
by mem_id;
if m;
run;

(untested, composed on my tablet)

PS I fixed your have and want datastep codes.

Re: Extracting all records for only two unique variable values

anushreebiotech — Thu, 20 Jun 2019 17:57:06 GMT

Hi,

data want;
set have;
where mem_id in ('A', 'B');
run;

Regards,

Anushree

Re: Extracting all records for only two unique variable values

devsas — Thu, 20 Jun 2019 18:40:09 GMT

Thanks , but for this I need to open each dataset every time and find two unique members. Infact i used the same method, but knew it was not very efficient.