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
If you are using pass-thru SQL, then you have to use whatever is required in the destinatuin database (and it may not exist).
I am pulling data from Oracle database.
Use the rownum variable or rank() function, see here:
Also this is useful:
where rownum <= 10
will get you the first 10 reows.