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?