Help using Base SAS procedures

Remove duplicate values that match on multiple key variables but one

Reply
Occasional Contributor
Posts: 18

Remove duplicate values that match on multiple key variables but one

Hi! 

 

I have 2 cases in which I have 0 values in my dataset - 

 

Case 1 - 

Member       Diagnosis           Date       Location        Cost

1                      dx1            8/3/2016          ER           5000

1                      dx1            8/3/2016          ER           3652

1                      dx1            8/3/2016          ER              0

 

Case 2 -

Member       Diagnosis           Date       Location        Cost

2                     dx2            8/3/2016       Inpatient        7000

2                     dx3            8/3/2016          ER                 0

 

In Case 1, I want to delete the 0 observation since it is a duplicate of the one before it, except for the cost.

In Case 2, I don't want to delete the 0 value since it is unique.

 

This is what I want my output to look like - 

Member       Diagnosis           Date       Location        Cost

1                      dx1            8/3/2016          ER           5000

1                      dx1            8/3/2016          ER           3652

2                     dx2            8/3/2016       Inpatient        7000

2                     dx3            8/3/2016          ER                 0

 

What is the best way ot go about doing this? Thank you!

Super User
Posts: 5,441

Re: Remove duplicate values that match on multiple key variables but one

Posted in reply to batulelec
Try proc sort with the NODUPKEY option.
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 146 views
  • 0 likes
  • 2 in conversation