https://communities.sas.com/t5/SAS-Programming/Update-Old-id-with-new/m-p/608828#M177224 <P>New_id&nbsp; &nbsp; &nbsp;Old_id<BR />1<BR />2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<BR />3</P><P>New_id&nbsp; &nbsp; &nbsp; Old_id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Updated_Id<BR />1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<BR />2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<BR />3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P><P>&nbsp;</P><P>Need help in updating the new_id when there is an old id exists. In the above case New_Id "2"&nbsp; has old_id "1". So the updated_id is "2" for the new_ids "1" and "2".&nbsp;</P><P>&nbsp;</P> Mon, 02 Dec 2019 19:34:33 GMT SASPhile 2019-12-02T19:34:33Z https://communities.sas.com/t5/SAS-Programming/Update-Old-id-with-new/m-p/608828#M177224 <P>New_id&nbsp; &nbsp; &nbsp;Old_id<BR />1<BR />2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1<BR />3</P><P>New_id&nbsp; &nbsp; &nbsp; Old_id&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Updated_Id<BR />1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<BR />2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2<BR />3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P><P>&nbsp;</P><P>Need help in updating the new_id when there is an old id exists. In the above case New_Id "2"&nbsp; has old_id "1". So the updated_id is "2" for the new_ids "1" and "2".&nbsp;</P><P>&nbsp;</P> Mon, 02 Dec 2019 19:34:33 GMT https://communities.sas.com/t5/SAS-Programming/Update-Old-id-with-new/m-p/608828#M177224 SASPhile 2019-12-02T19:34:33Z https://communities.sas.com/t5/SAS-Programming/Update-Old-id-with-new/m-p/608836#M177232 You should explain how 'updated_id' is derived, especially since there isn't any visible connection between a new_id of 1 and an updated_id of 2. Mon, 02 Dec 2019 20:14:40 GMT https://communities.sas.com/t5/SAS-Programming/Update-Old-id-with-new/m-p/608836#M177232 tomrvincent 2019-12-02T20:14:40Z https://communities.sas.com/t5/SAS-Programming/Update-Old-id-with-new/m-p/608839#M177234 Usually you'd have dates attached to those as well to help define the order. Mon, 02 Dec 2019 20:29:12 GMT https://communities.sas.com/t5/SAS-Programming/Update-Old-id-with-new/m-p/608839#M177234 Reeza 2019-12-02T20:29:12Z