topic How to limit obs in Pass-thru sql in EG? in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-limit-obs-in-Pass-thru-sql-in-EG/m-p/56603#M5903 <HTML><HEAD></HEAD><BODY><P>I am pulling data from Oracle database.</P></BODY></HTML> Thu, 16 Feb 2012 22:51:45 GMT renjithr 2012-02-16T22:51:45Z How to limit obs in Pass-thru sql in EG? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-limit-obs-in-Pass-thru-sql-in-EG/m-p/56601#M5901 <HTML><HEAD></HEAD><BODY><P>Could you please let me know how to limit the number of observations/rows in a pass-thru SQL?</P><P>I have tried INOBS and OUTOBS ,but looks like it does not work in pass through</P></BODY></HTML> Thu, 16 Feb 2012 21:47:21 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-limit-obs-in-Pass-thru-sql-in-EG/m-p/56601#M5901 renjithr 2012-02-16T21:47:21Z How to limit obs in Pass-thru sql in EG? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-limit-obs-in-Pass-thru-sql-in-EG/m-p/56602#M5902 <HTML><HEAD></HEAD><BODY><P>If you are using pass-thru SQL, then you have to use whatever is required in the destinatuin database (and it may not exist).</P></BODY></HTML> Thu, 16 Feb 2012 22:43:15 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-limit-obs-in-Pass-thru-sql-in-EG/m-p/56602#M5902 Doc_Duke 2012-02-16T22:43:15Z How to limit obs in Pass-thru sql in EG? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-limit-obs-in-Pass-thru-sql-in-EG/m-p/56603#M5903 <HTML><HEAD></HEAD><BODY><P>I am pulling data from Oracle database.</P></BODY></HTML> Thu, 16 Feb 2012 22:51:45 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-limit-obs-in-Pass-thru-sql-in-EG/m-p/56603#M5903 renjithr 2012-02-16T22:51:45Z How to limit obs in Pass-thru sql in EG? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-limit-obs-in-Pass-thru-sql-in-EG/m-p/56604#M5904 <HTML><HEAD></HEAD><BODY><P>Use the rownum variable or rank() function, see here:</P><P><A class="jive-link-external-small" href="http://bytes.com/topic/oracle/answers/631642-top-10-rows">http://bytes.com/topic/oracle/answers/631642-top-10-rows</A></P></BODY></HTML> Fri, 17 Feb 2012 00:26:28 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-limit-obs-in-Pass-thru-sql-in-EG/m-p/56604#M5904 Reeza 2012-02-17T00:26:28Z How to limit obs in Pass-thru sql in EG? https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-limit-obs-in-Pass-thru-sql-in-EG/m-p/56605#M5905 <HTML><HEAD></HEAD><BODY><P>Also this is useful:</P><P></P><P><A href="http://support.sas.com/kb/15/624.html">http://support.sas.com/kb/15/624.html</A></P><P></P><P>select * </P><P>from table</P><P>where rownum &lt;= 10</P><P></P><P>will get you the first 10 reows.</P></BODY></HTML> Fri, 17 Feb 2012 00:29:53 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-to-limit-obs-in-Pass-thru-sql-in-EG/m-p/56605#M5905 SASKiwi 2012-02-17T00:29:53Z