EG 6.1 proc sql to oracle row limit

metallon — Tue, 31 Mar 2015 14:05:30 GMT

Hi SAS Experts,

I observe that whatever query I use there is only a maximum of 10 observations ever in my result.

Why is that?

proc sql;

connect to oracle as nrkpdb (user=xx password=yy path=xy);

create table positiv as

( select * from connection to nrkpdb

( SELECT * from T_AMT )

); disconnect from nrkpdb;

quit;

Re: EG 6.1 proc sql to oracle row limit

Kurt_Bremser — Tue, 31 Mar 2015 14:47:52 GMT

Maybe you have the OBS= system option set.