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
Esteemed Advisor
Posts: 6,698

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
Esteemed Advisor
Posts: 6,698

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.

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

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