https://communities.sas.com/t5/SAS-Programming/Customer-numerator-key/m-p/788240#M251968 <P>Each customer appear in 12 rows . Each customer has a unique key number that stay forever and never changed. However, the customer ID and the branch can be changed over time. I want to create 2 wanted data sets (one in long structure and second in wide structure). The target is to see the changes of customer id number for each customer key</P> Tue, 04 Jan 2022 08:45:49 GMT MitchellStarc 2022-01-04T08:45:49Z https://communities.sas.com/t5/SAS-Programming/Customer-numerator-key/m-p/788240#M251968 <P>Each customer appear in 12 rows . Each customer has a unique key number that stay forever and never changed. However, the customer ID and the branch can be changed over time. I want to create 2 wanted data sets (one in long structure and second in wide structure). The target is to see the changes of customer id number for each customer key</P> Tue, 04 Jan 2022 08:45:49 GMT https://communities.sas.com/t5/SAS-Programming/Customer-numerator-key/m-p/788240#M251968 MitchellStarc 2022-01-04T08:45:49Z https://communities.sas.com/t5/SAS-Programming/Customer-numerator-key/m-p/788252#M251979 <P>Exact same question has been answered at&nbsp;<A href="https://communities.sas.com/t5/SAS-Programming/Customer-numerator-key/td-p/788230/jump-to/first-unread-message" target="_blank">https://communities.sas.com/t5/SAS-Programming/Customer-numerator-key/td-p/788230/jump-to/first-unread-message</A></P> Tue, 04 Jan 2022 11:46:12 GMT https://communities.sas.com/t5/SAS-Programming/Customer-numerator-key/m-p/788252#M251979 PaigeMiller 2022-01-04T11:46:12Z