use proc sql to pull a table created on sql developer

pinkyc — Wed, 07 Jan 2015 17:26:53 GMT

I'm extremely new to SQL Developer and pulling data using SAS from Oracle. If under connection aa_aaa, I created a table named pat_details and my username is pinkny how do I basically "import" the table in SAS?

The way another person's reference code does it is by libname REC oracle=user orapwd=password path="PATH" schema=SCHEMA;

Where PATH here would be the connection.

Then:

proc sql

create table NAME as

select distinct * from LIBREF.TABLENAME

(in my case REC.pat_details)

I tried doing this, but I'm not sure what schema the created table would fall under? Is it by default the same as my username?

Re: use proc sql to pull a table created on sql developer

pinkyc — Wed, 07 Jan 2015 19:24:32 GMT

I think I figured it out so for reference:

libname REC oracle user=pinkny orapwd=1234 path="aa_aaa" schema=pinkny

proc sql

create table NAME as

select distinct * from REC.pat_details

topic use proc sql to pull a table created on sql developer in SAS Procedures

use proc sql to pull a table created on sql developer

Re: use proc sql to pull a table created on sql developer