topic Remove duplicate values that match on multiple key variables but one in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Remove-duplicate-values-that-match-on-multiple-key-variables-but/m-p/289518#M59661 <P>Hi!&nbsp;</P><P>&nbsp;</P><P>I have 2 cases in which I have 0 values in my dataset -&nbsp;</P><P>&nbsp;</P><P>Case 1 -&nbsp;</P><P>Member &nbsp; &nbsp; &nbsp; Diagnosis &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date &nbsp; &nbsp; &nbsp; Location &nbsp; &nbsp; &nbsp; &nbsp;Cost</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/3/2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5000</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/3/2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3652</P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/3/2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</SPAN></P><P>&nbsp;</P><P>Case 2 -</P><P>Member &nbsp; &nbsp; &nbsp; Diagnosis &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date &nbsp; &nbsp; &nbsp; Location &nbsp; &nbsp; &nbsp; &nbsp;Cost</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/3/2016 &nbsp; &nbsp; &nbsp; Inpatient&nbsp; &nbsp; &nbsp; &nbsp; 7000</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8/3/2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;0</P><P>&nbsp;</P><P>In Case 1, I want to delete the 0 observation since it is a duplicate of the one before it, except for the cost.</P><P>In Case 2, I don't want to delete the 0 value since it is unique.</P><P>&nbsp;</P><P>This is what I want my output to look like -&nbsp;</P><P>Member &nbsp; &nbsp; &nbsp; Diagnosis &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date &nbsp; &nbsp; &nbsp; Location &nbsp; &nbsp; &nbsp; &nbsp;Cost</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/3/2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5000</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/3/2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3652</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/3/2016 &nbsp; &nbsp; &nbsp; Inpatient&nbsp; &nbsp; &nbsp; &nbsp; 7000</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8/3/2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;0</P><P>&nbsp;</P><P>What is the best way ot go about doing this? Thank you!</P> Thu, 04 Aug 2016 13:16:31 GMT batulelec 2016-08-04T13:16:31Z Remove duplicate values that match on multiple key variables but one https://communities.sas.com/t5/SAS-Procedures/Remove-duplicate-values-that-match-on-multiple-key-variables-but/m-p/289518#M59661 <P>Hi!&nbsp;</P><P>&nbsp;</P><P>I have 2 cases in which I have 0 values in my dataset -&nbsp;</P><P>&nbsp;</P><P>Case 1 -&nbsp;</P><P>Member &nbsp; &nbsp; &nbsp; Diagnosis &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date &nbsp; &nbsp; &nbsp; Location &nbsp; &nbsp; &nbsp; &nbsp;Cost</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/3/2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5000</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/3/2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3652</P><P><SPAN>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/3/2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</SPAN></P><P>&nbsp;</P><P>Case 2 -</P><P>Member &nbsp; &nbsp; &nbsp; Diagnosis &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date &nbsp; &nbsp; &nbsp; Location &nbsp; &nbsp; &nbsp; &nbsp;Cost</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/3/2016 &nbsp; &nbsp; &nbsp; Inpatient&nbsp; &nbsp; &nbsp; &nbsp; 7000</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8/3/2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;0</P><P>&nbsp;</P><P>In Case 1, I want to delete the 0 observation since it is a duplicate of the one before it, except for the cost.</P><P>In Case 2, I don't want to delete the 0 value since it is unique.</P><P>&nbsp;</P><P>This is what I want my output to look like -&nbsp;</P><P>Member &nbsp; &nbsp; &nbsp; Diagnosis &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Date &nbsp; &nbsp; &nbsp; Location &nbsp; &nbsp; &nbsp; &nbsp;Cost</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/3/2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5000</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/3/2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3652</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8/3/2016 &nbsp; &nbsp; &nbsp; Inpatient&nbsp; &nbsp; &nbsp; &nbsp; 7000</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dx3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8/3/2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ER &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;0</P><P>&nbsp;</P><P>What is the best way ot go about doing this? Thank you!</P> Thu, 04 Aug 2016 13:16:31 GMT https://communities.sas.com/t5/SAS-Procedures/Remove-duplicate-values-that-match-on-multiple-key-variables-but/m-p/289518#M59661 batulelec 2016-08-04T13:16:31Z Re: Remove duplicate values that match on multiple key variables but one https://communities.sas.com/t5/SAS-Procedures/Remove-duplicate-values-that-match-on-multiple-key-variables-but/m-p/289994#M59705 Try proc sort with the NODUPKEY option. Sat, 06 Aug 2016 21:27:30 GMT https://communities.sas.com/t5/SAS-Procedures/Remove-duplicate-values-that-match-on-multiple-key-variables-but/m-p/289994#M59705 LinusH 2016-08-06T21:27:30Z