https://communities.sas.com/t5/SAS-Programming/How-to-select-the-last-observation-from-a-dataset-to-perform-a/m-p/700795#M214509 <PRE><CODE class=" language-sas">proc sort data = Have; by SSN Visit_Date; run; data Want; set Have; by SSN; if last.SSN; run;</CODE></PRE> Sun, 22 Nov 2020 22:12:45 GMT SASKiwi 2020-11-22T22:12:45Z https://communities.sas.com/t5/SAS-Programming/How-to-select-the-last-observation-from-a-dataset-to-perform-a/m-p/700792#M214506 <P>Hello!</P><P>&nbsp;</P><P>I am currently working on performing a match-merge across four data sets. Each observation should include a unique SSN; however one dataset records four observations per one SSN. How would I go about including only the last recorded observation for each unique SSN to my final match-merged dataset?</P><P>&nbsp;</P><P>The observations for the data set in question would be structured similarly to:</P><P>111-11-1111 ...</P><P>111-11-1111 ...</P><P>111-11-1111 ...</P><P>111-11-1111 ...</P><P>222-22-2222 ...</P><P>222-22-2222 ...</P><P>222-22-2222 ...</P><P>222-22-2222 ...</P><P>...</P> Sun, 22 Nov 2020 21:54:27 GMT https://communities.sas.com/t5/SAS-Programming/How-to-select-the-last-observation-from-a-dataset-to-perform-a/m-p/700792#M214506 steeleye 2020-11-22T21:54:27Z https://communities.sas.com/t5/SAS-Programming/How-to-select-the-last-observation-from-a-dataset-to-perform-a/m-p/700793#M214507 <P>Do you have a recorded date in your data to sort on as well as SSN? If not how would you identify the last recorded SSN?</P> Sun, 22 Nov 2020 21:59:08 GMT https://communities.sas.com/t5/SAS-Programming/How-to-select-the-last-observation-from-a-dataset-to-perform-a/m-p/700793#M214507 SASKiwi 2020-11-22T21:59:08Z https://communities.sas.com/t5/SAS-Programming/How-to-select-the-last-observation-from-a-dataset-to-perform-a/m-p/700794#M214508 <P>Yes, there is a corresponding visit date for each observation. We are being asked to select the observation with the most recent visit date per SSN.</P> Sun, 22 Nov 2020 22:01:36 GMT https://communities.sas.com/t5/SAS-Programming/How-to-select-the-last-observation-from-a-dataset-to-perform-a/m-p/700794#M214508 steeleye 2020-11-22T22:01:36Z https://communities.sas.com/t5/SAS-Programming/How-to-select-the-last-observation-from-a-dataset-to-perform-a/m-p/700795#M214509 <PRE><CODE class=" language-sas">proc sort data = Have; by SSN Visit_Date; run; data Want; set Have; by SSN; if last.SSN; run;</CODE></PRE> Sun, 22 Nov 2020 22:12:45 GMT https://communities.sas.com/t5/SAS-Programming/How-to-select-the-last-observation-from-a-dataset-to-perform-a/m-p/700795#M214509 SASKiwi 2020-11-22T22:12:45Z https://communities.sas.com/t5/SAS-Programming/How-to-select-the-last-observation-from-a-dataset-to-perform-a/m-p/700855#M214541 <P>Can you show us your code so far?</P> Mon, 23 Nov 2020 08:36:39 GMT https://communities.sas.com/t5/SAS-Programming/How-to-select-the-last-observation-from-a-dataset-to-perform-a/m-p/700855#M214541 PeterClemmensen 2020-11-23T08:36:39Z https://communities.sas.com/t5/SAS-Programming/How-to-select-the-last-observation-from-a-dataset-to-perform-a/m-p/700952#M214588 Thank you so much, this worked perfectly! Mon, 23 Nov 2020 16:12:04 GMT https://communities.sas.com/t5/SAS-Programming/How-to-select-the-last-observation-from-a-dataset-to-perform-a/m-p/700952#M214588 steeleye 2020-11-23T16:12:04Z https://communities.sas.com/t5/SAS-Programming/How-to-select-the-last-observation-from-a-dataset-to-perform-a/m-p/700957#M214590 <P>No I'm sorry, this code is for a class so I cannot provide my code verbatim.</P> Thu, 10 Dec 2020 16:30:32 GMT https://communities.sas.com/t5/SAS-Programming/How-to-select-the-last-observation-from-a-dataset-to-perform-a/m-p/700957#M214590 steeleye 2020-12-10T16:30:32Z