How to limit obs in Pass-thru sql?

renjithr — Fri, 17 Feb 2012 01:55:43 GMT

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 — Fri, 17 Feb 2012 02:57:37 GMT

This is already answered in your earlier post:

topic How to limit obs in Pass-thru sql? in SAS Procedures