I know there have been a lot of posts about ways to delete duplicates, but I can't find exactly what I am looking for.    I have a data set of phone numbers and I am trying to save all of the unique phone numbers for each ID. I want one row per phone number. If a phone number appears multiple times for one record, I want to keep the record with the most recent date.    Here's an example of test data: ID    phone number      date 1     (555) 555-5555     5/6/2018 1     (555) 555-5555     6/8/2018 1     (666) 666-6666     9/10/2018 2     (777) 777-7777     4/1/2018 2     (777) 777-7777     5/20/2018 3     (888) 888-8888     6/4/2018 4     (222) 222-2222     5/6/2018 4     (222) 222-2222     6/5/2018 4     (333) 333-3333     8/4/2018 4     (222) 222-2222     10/10/2018   I would like the resulting data set to look like this:   ID     phone number      date 1      (555) 555-5555     6/8/2018 1      (666) 666-6666     9/10/2018 2      (777) 777-7777     5/20/2018 3      (888) 888-8888     6/4/2018 4      (333) 333-3333     8/4/2018 4      (222) 222-2222     10/10/2018   Where within one ID, each phone number only appears once. If the phone number appears for different dates in the original data, then the most recent date is the record that is kept.    Thanks in advance for any help you can provide!  ... View more

My data is from a survey where members of a household were entered into blocks of variables. For example, if someone meets X criteria they are entered into the variables 1-3, starting with variable 1; if someone meets Y criteria then they are entered into the variables 4-6, starting with variable 4; if someone meets Z criteria they are entered into variables 7-9, starting with variable 7. I am now tasked with creating one set of variables to hold all the information, but I am not sure how to restructure the data.    Example of current data structure:   Fname_1 Lname_1 Age_1 Gender_1 Fname_2 Lname_2 Age_2 Gender_2 Fname_3 Lname_3 Age_3 Gender_3 Fname_4 Lname_4 Age_4 Gender_4 Fname_5 Lname_5 Age_5 Gender_5 Fname_6 Lname_6 Age_6 Gender_6 Fname_7 Lname_7 Age_7 Gender_7 Fname_8 Lname_8 Age_8 Gender_8 Fname_9 Lname_9 Age_9 Gender_9 Kate Black 20 F . . . . . . . . Louis White 35 M Kitty White 36 F . . . . . . . . . . . . . . . . Lucy Red 18 F Tom Red 17 . . . . . . . . . . . . . . . . . Paul Red 76 M Sarah Red 77 F . . . . . . . . . . . . . . . . Patricia Yellow 60 F Frank Yellow 62 M . . . . Kate Yellow 11 F . . . . . . . . Jeff  Blue 15 M . . . . . . . . . . . . . . . . . . . . Lillian Blue 25 F . . . . . . . .   This leaves a lot of missing data. I want to be able to make one household roster, removing the missing data. So that it looks like this:  Fname_1 Lname_1 Age_1 Gender_1 Fname_2 Lname_2 Age_2 Gender_2 Fname_3 Lname_3 Age_3 Gender_3 Fname_4 Lname_4 Age_4 Gender_4 Fname_5 Lname_5 Age_5 Gender_5 Fname_6 Lname_6 Age_6 Gender_6 Fname_7 Lname_7 Age_7 Gender_7 Fname_8 Lname_8 Age_8 Gender_8 Fname_9 Lname_9 Age_9 Gender_9 Kate Black 20 F Louis White 35 M Kitty White 36 F . . . . . . . . . . . . . . . . . . . . . . . . Lucy Red 18 F Tom Red 17 Paul Red 76 M Sarah Red 77 F . . . . . . . . . . . . . . . . . . . . . Patricia Yellow 60 F Frank Yellow 62 M Kate Yellow 11 F . . . . . . . . . . . . . . . . . . . . . . . . Jeff  Blue 15 M Lillian Blue 25 F . . . . . . . . . . . . . . . . . . . . . . . . . . . .   My question is: how do I pull out the data that exists and put it into variables as per my example.    I am familiar with arrays and do-loops, and have tried some manipulations with these, without success.    Any guidance, advice, or suggestions are much appreciated! Thank you!   ... View more