Help using Base SAS procedures

use proc sql to pull a table created on sql developer

Reply
Contributor
Posts: 28

use proc sql to pull a table created on sql developer

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?

Contributor
Posts: 28

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

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

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