EG 6.1 proc sql to oracle row limit

[metallon]

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;

m

[Kurt_Bremser · Accepted solution]

Maybe you have the OBS= system option set.