https://communities.sas.com/t5/SAS-Programming/trying-to-return-the-first-record/m-p/720768#M223300 <P>Hi&nbsp;</P><P>I'm trying to return the first record but I'm having an error&nbsp;</P><P>&nbsp;</P><P><SPAN>PROC SQL;<BR />SELECT region,<BR />(COUNT(number_id))&nbsp;&nbsp;<BR />FROM COVID_DATA_JOIN<BR />WHERE rownum = 1<BR />GROUP BY region<BR />;QUIT;</SPAN></P> Sun, 21 Feb 2021 19:02:28 GMT One_eye 2021-02-21T19:02:28Z https://communities.sas.com/t5/SAS-Programming/trying-to-return-the-first-record/m-p/720768#M223300 <P>Hi&nbsp;</P><P>I'm trying to return the first record but I'm having an error&nbsp;</P><P>&nbsp;</P><P><SPAN>PROC SQL;<BR />SELECT region,<BR />(COUNT(number_id))&nbsp;&nbsp;<BR />FROM COVID_DATA_JOIN<BR />WHERE rownum = 1<BR />GROUP BY region<BR />;QUIT;</SPAN></P> Sun, 21 Feb 2021 19:02:28 GMT https://communities.sas.com/t5/SAS-Programming/trying-to-return-the-first-record/m-p/720768#M223300 One_eye 2021-02-21T19:02:28Z https://communities.sas.com/t5/SAS-Programming/trying-to-return-the-first-record/m-p/720772#M223301 <P>When you have ERRORs or WARNINGs where the remedy is not obvious to you, always (as in&nbsp;<STRONG>ALWAYS</STRONG>) post the <EM>complete</EM>&nbsp;log of the step by copy/pasting it into a code box opened with the &lt;/&gt; button.</P> Sun, 21 Feb 2021 19:48:04 GMT https://communities.sas.com/t5/SAS-Programming/trying-to-return-the-first-record/m-p/720772#M223301 Kurt_Bremser 2021-02-21T19:48:04Z https://communities.sas.com/t5/SAS-Programming/trying-to-return-the-first-record/m-p/720789#M223313 <P>This syntax is invalid in SAS unless you have a column names ROWNUM.</P> <P>Look for questions about&nbsp; &nbsp; &nbsp;TOP N&nbsp; &nbsp; for examples of what you are trying to achieve.</P> Sun, 21 Feb 2021 21:57:26 GMT https://communities.sas.com/t5/SAS-Programming/trying-to-return-the-first-record/m-p/720789#M223313 ChrisNZ 2021-02-21T21:57:26Z