topic Re: how to add "limit 1" to SQL query in SAS Programming

topic Re: how to add "limit 1" to SQL query in SAS Programming https://communities.sas.com/t5/SAS-Programming/how-to-add-quot-limit-1-quot-to-SQL-query/m-p/128166#M260367 <HTML><HEAD></HEAD><BODY><P>oops, I found it</P><P></P><P><A href="http://stackoverflow.com/questions/11746815/limiting-results-in-proc-sql" title="http://stackoverflow.com/questions/11746815/limiting-results-in-proc-sql">sas - Limiting results in PROC SQL - Stack Overflow</A></P><P></P><P>proc sql outobs=1;</P></BODY></HTML> Thu, 02 May 2013 17:39:59 GMT carterson2 2013-05-02T17:39:59Z how to add "limit 1" to SQL query https://communities.sas.com/t5/SAS-Programming/how-to-add-quot-limit-1-quot-to-SQL-query/m-p/128165#M260366 <HTML><HEAD></HEAD><BODY><P>proc sql;</P><P>  select * from blah</P><P>  limit 1;</P><P></P><P>Q: How can I limit the amount of output? Typically I add "limit 1", but that doesn't seem to work.</P><P></P><P>Thanks for reading!</P><P>jp</P></BODY></HTML> Thu, 02 May 2013 17:37:07 GMT https://communities.sas.com/t5/SAS-Programming/how-to-add-quot-limit-1-quot-to-SQL-query/m-p/128165#M260366 carterson2 2013-05-02T17:37:07Z Re: how to add "limit 1" to SQL query https://communities.sas.com/t5/SAS-Programming/how-to-add-quot-limit-1-quot-to-SQL-query/m-p/128166#M260367 <HTML><HEAD></HEAD><BODY><P>oops, I found it</P><P></P><P><A href="http://stackoverflow.com/questions/11746815/limiting-results-in-proc-sql" title="http://stackoverflow.com/questions/11746815/limiting-results-in-proc-sql">sas - Limiting results in PROC SQL - Stack Overflow</A></P><P></P><P>proc sql outobs=1;</P></BODY></HTML> Thu, 02 May 2013 17:39:59 GMT https://communities.sas.com/t5/SAS-Programming/how-to-add-quot-limit-1-quot-to-SQL-query/m-p/128166#M260367 carterson2 2013-05-02T17:39:59Z