Remove duplicate values that match on multiple key variables but one

[batulelec]

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!

[LinusH]

Try proc sort with the NODUPKEY option.