https://communities.sas.com/t5/SAS-Programming/select-the-first-row-by-id/m-p/719467#M222760 <P>Hello</P> <P>I want to select the first row by id like that</P> <P>id r</P> <P>1 6</P> <P>1&nbsp; 7</P> <P>2 89</P> <P>2&nbsp; 98</P> <P>&nbsp;</P> <P>want&nbsp;</P> <P>id r</P> <P>1 6</P> <P>2 89</P> Mon, 15 Feb 2021 20:06:56 GMT sasphd 2021-02-15T20:06:56Z https://communities.sas.com/t5/SAS-Programming/select-the-first-row-by-id/m-p/719467#M222760 <P>Hello</P> <P>I want to select the first row by id like that</P> <P>id r</P> <P>1 6</P> <P>1&nbsp; 7</P> <P>2 89</P> <P>2&nbsp; 98</P> <P>&nbsp;</P> <P>want&nbsp;</P> <P>id r</P> <P>1 6</P> <P>2 89</P> Mon, 15 Feb 2021 20:06:56 GMT https://communities.sas.com/t5/SAS-Programming/select-the-first-row-by-id/m-p/719467#M222760 sasphd 2021-02-15T20:06:56Z https://communities.sas.com/t5/SAS-Programming/select-the-first-row-by-id/m-p/719470#M222761 <P>You want to look at <A title="FIRST&lt;dot&gt; LAST&lt;dot&gt; Processing" href="https://go.documentation.sas.com/?cdcId=pgmsascdc&amp;cdcVersion=9.4_3.5&amp;docsetId=lrcon&amp;docsetTarget=n01a08zkzy5igbn173zjz82zsi1s.htm&amp;locale=en" target="_self">FIRST. and LAST. processing</A></P> Mon, 15 Feb 2021 20:16:01 GMT https://communities.sas.com/t5/SAS-Programming/select-the-first-row-by-id/m-p/719470#M222761 AMSAS 2021-02-15T20:16:01Z https://communities.sas.com/t5/SAS-Programming/select-the-first-row-by-id/m-p/719502#M222778 <PRE><CODE class=" language-sas">proc sort data=have; &nbsp; by id; run; data want; &nbsp; set have; by id; &nbsp; if first.id; run; </CODE></PRE> Mon, 15 Feb 2021 23:39:13 GMT https://communities.sas.com/t5/SAS-Programming/select-the-first-row-by-id/m-p/719502#M222778 japelin 2021-02-15T23:39:13Z