How to limit obs in Pass-thru sql in EG?

[renjithr]

Could you please let me know how to limit the number of observations/rows in a pass-thru SQL?

I have tried INOBS and OUTOBS ,but looks like it does not work in pass through

[Doc_Duke]

If you are using pass-thru SQL, then you have to use whatever is required in the destinatuin database (and it may not exist).

[renjithr]

I am pulling data from Oracle database.

[Reeza]

Use the rownum variable or rank() function, see here:

http://bytes.com/topic/oracle/answers/631642-top-10-rows

[SASKiwi]

Also this is useful:

http://support.sas.com/kb/15/624.html

select *

from table

where rownum <= 10

will get you the first 10 reows.