How to limit obs in Pass-thru sql?

[renjithr]

Could you please let me know how to limit obs in a pass-thru sql.I am pulling the data from oracle database.

Below is my code:

proc sql   ;

connect to oracle as ora

(user = &user. password = &pw path = OraPath);

create table zsz as

select * from connection to ora

(

select *

from  (

select

name

from employee

);

disconnect from ora;

quit;

[SASKiwi]

This is already answered in your earlier post:

http://communities.sas.com/message/116291#116291