https://communities.sas.com/t5/SAS-Programming/select-last-observation/m-p/300657#M63529 <P>Hi all, this is probably relatively simple, but appreciate the help.</P><P>&nbsp;</P><P>data I have</P><P>&nbsp;</P><P>id &nbsp; &nbsp; &nbsp; event &nbsp; &nbsp; &nbsp; &nbsp;value</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; y</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; z</P><P>2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; q</P><P>2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; r</P><P>2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; s</P><P>2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;d &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; t</P><P>...</P><P>&nbsp;</P><P>data i want</P><P>&nbsp;</P><P>id &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;event &nbsp; &nbsp; &nbsp; value</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; z</P><P>2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; d &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; t</P> Sun, 25 Sep 2016 22:50:17 GMT madelman 2016-09-25T22:50:17Z https://communities.sas.com/t5/SAS-Programming/select-last-observation/m-p/300657#M63529 <P>Hi all, this is probably relatively simple, but appreciate the help.</P><P>&nbsp;</P><P>data I have</P><P>&nbsp;</P><P>id &nbsp; &nbsp; &nbsp; event &nbsp; &nbsp; &nbsp; &nbsp;value</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; x</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; y</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; z</P><P>2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;a &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; q</P><P>2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;b &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; r</P><P>2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; s</P><P>2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;d &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; t</P><P>...</P><P>&nbsp;</P><P>data i want</P><P>&nbsp;</P><P>id &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;event &nbsp; &nbsp; &nbsp; value</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; c &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; z</P><P>2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; d &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; t</P> Sun, 25 Sep 2016 22:50:17 GMT https://communities.sas.com/t5/SAS-Programming/select-last-observation/m-p/300657#M63529 madelman 2016-09-25T22:50:17Z https://communities.sas.com/t5/SAS-Programming/select-last-observation/m-p/300662#M63533 <P>Use BY groups and first/last in SAS.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data want; set have; by id; if last.id; run;</CODE></PRE> Sun, 25 Sep 2016 23:05:17 GMT https://communities.sas.com/t5/SAS-Programming/select-last-observation/m-p/300662#M63533 Reeza 2016-09-25T23:05:17Z