Desktop productivity for business analysts and programmers

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

Reply
Frequent Contributor
Posts: 122

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

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

Trusted Advisor
Posts: 2,114

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

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

Frequent Contributor
Posts: 122

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

I am pulling data from Oracle database.

Super User
Posts: 19,064

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

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

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

Super User
Posts: 3,233

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

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.

Ask a Question
Discussion stats
  • 4 replies
  • 333 views
  • 0 likes
  • 4 in conversation