Desktop productivity for business analysts and programmers

EG 6.1 proc sql to oracle row limit

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 133
Accepted Solution

EG 6.1 proc sql to oracle row limit

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


Accepted Solutions
Solution
‎03-31-2015 10:47 AM
Super User
Posts: 7,447

Re: EG 6.1 proc sql to oracle row limit

Maybe you have the OBS= system option set.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎03-31-2015 10:47 AM
Super User
Posts: 7,447

Re: EG 6.1 proc sql to oracle row limit

Maybe you have the OBS= system option set.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 228 views
  • 0 likes
  • 2 in conversation