Help using Base SAS procedures

How to limit obs in Pass-thru sql?

Reply
Frequent Contributor
Posts: 122

How to limit obs in Pass-thru sql?

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;

Super User
Posts: 3,252

How to limit obs in Pass-thru sql?

This is already answered in your earlier post:

http://communities.sas.com/message/116291#116291

Ask a Question
Discussion stats
  • 1 reply
  • 166 views
  • 0 likes
  • 2 in conversation