https://communities.sas.com/t5/SAS-Programming/Keep-the-2-most-recent-observations/m-p/796629#M255652 <P>I want to keep data for the 2 most recent observations (variable name: test) for something, but I'm unsure how to do it.</P> <P>&nbsp;</P> <P>This is how i would keep the most recent observation, I am just not sure how to get the next one in there too. Especially since have some people with 20 observations and some with only 1.</P> <P>&nbsp;</P> <P>proc sort data=have;</P> <P>by ssn descending test;</P> <P>run;</P> Wed, 16 Feb 2022 16:50:18 GMT A_Halps 2022-02-16T16:50:18Z https://communities.sas.com/t5/SAS-Programming/Keep-the-2-most-recent-observations/m-p/796629#M255652 <P>I want to keep data for the 2 most recent observations (variable name: test) for something, but I'm unsure how to do it.</P> <P>&nbsp;</P> <P>This is how i would keep the most recent observation, I am just not sure how to get the next one in there too. Especially since have some people with 20 observations and some with only 1.</P> <P>&nbsp;</P> <P>proc sort data=have;</P> <P>by ssn descending test;</P> <P>run;</P> Wed, 16 Feb 2022 16:50:18 GMT https://communities.sas.com/t5/SAS-Programming/Keep-the-2-most-recent-observations/m-p/796629#M255652 A_Halps 2022-02-16T16:50:18Z https://communities.sas.com/t5/SAS-Programming/Keep-the-2-most-recent-observations/m-p/796636#M255658 Add an enumeration counter and filter based on that.<BR /><A href="https://stats.oarc.ucla.edu/sas/faq/how-can-i-create-an-enumeration-variable-by-groups/" target="_blank">https://stats.oarc.ucla.edu/sas/faq/how-can-i-create-an-enumeration-variable-by-groups/</A><BR /><BR />data want;<BR />set have;<BR />by ssn descending test;<BR />if first.ssn then count=0;<BR />count+1;<BR />if count&lt;=2;<BR />run; Wed, 16 Feb 2022 17:07:31 GMT https://communities.sas.com/t5/SAS-Programming/Keep-the-2-most-recent-observations/m-p/796636#M255658 Reeza 2022-02-16T17:07:31Z