topic Re: Finding last observation in SAS Programming https://communities.sas.com/t5/SAS-Programming/Finding-last-observation/m-p/293123#M60928 <P>Is the ID and v1 combination unique?</P> <P>If so, use SQL with group by ID having max(v1) = v1.</P> Mon, 22 Aug 2016 12:50:48 GMT LinusH 2016-08-22T12:50:48Z Finding last observation https://communities.sas.com/t5/SAS-Programming/Finding-last-observation/m-p/293120#M60926 <TABLE><TBODY><TR><TD>Have:</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>ID&nbsp;</TD><TD>v1</TD><TD>v2</TD><TD>v3</TD></TR><TR><TD>1</TD><TD>-3</TD><TD>a</TD><TD>a</TD></TR><TR><TD>1</TD><TD>-2</TD><TD>b</TD><TD>b</TD></TR><TR><TD>1</TD><TD>-1</TD><TD>c</TD><TD>b</TD></TR><TR><TD>1</TD><TD>1</TD><TD>d</TD><TD>b</TD></TR><TR><TD>2</TD><TD>-20</TD><TD>a</TD><TD>a</TD></TR><TR><TD>2</TD><TD>-6</TD><TD>b</TD><TD>b</TD></TR><TR><TD>2</TD><TD>-3</TD><TD>c</TD><TD>b</TD></TR><TR><TD>2</TD><TD>-2</TD><TD>d</TD><TD>b</TD></TR><TR><TD>3</TD><TD>1</TD><TD>a</TD><TD>a</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>want:</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>ID&nbsp;</TD><TD>v1</TD><TD>v2</TD><TD>v3</TD></TR><TR><TD>1</TD><TD>1</TD><TD>d</TD><TD>b</TD></TR><TR><TD>2</TD><TD>-2</TD><TD>d</TD><TD>b</TD></TR><TR><TD>3</TD><TD>1</TD><TD>a</TD><TD>a</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I am trying to find one unique observation per id. &nbsp; v1 ranges from 1 to -20. I am trying &nbsp;to output&nbsp;&nbsp;the highest and unique value possible for v1.&nbsp;</P> Mon, 22 Aug 2016 12:47:00 GMT https://communities.sas.com/t5/SAS-Programming/Finding-last-observation/m-p/293120#M60926 ari 2016-08-22T12:47:00Z Re: Finding last observation https://communities.sas.com/t5/SAS-Programming/Finding-last-observation/m-p/293122#M60927 <P>Very easy.</P> <PRE><CODE class=" language-sas">proc sort data=have; by id v1; run; data want; set have; by id; if last.id; run;</CODE></PRE> Mon, 22 Aug 2016 12:50:48 GMT https://communities.sas.com/t5/SAS-Programming/Finding-last-observation/m-p/293122#M60927 Kurt_Bremser 2016-08-22T12:50:48Z Re: Finding last observation https://communities.sas.com/t5/SAS-Programming/Finding-last-observation/m-p/293123#M60928 <P>Is the ID and v1 combination unique?</P> <P>If so, use SQL with group by ID having max(v1) = v1.</P> Mon, 22 Aug 2016 12:50:48 GMT https://communities.sas.com/t5/SAS-Programming/Finding-last-observation/m-p/293123#M60928 LinusH 2016-08-22T12:50:48Z