BookmarkSubscribeRSS Feed
pinkyc
Calcite | Level 5

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?

1 REPLY 1
pinkyc
Calcite | Level 5

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 927 views
  • 0 likes
  • 1 in conversation