use proc sql to pull a table created on sql developer

[pinkyc]

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?

[pinkyc]

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