BookmarkSubscribeRSS Feed
mariajohnqwerty
Fluorite | Level 6

Is it possible to write back data from sas to oracle with sas EG.or it is must to use SAS DI studio.

1 REPLY 1
ChrisHemedinger
Community Manager

You can use SAS Enterprise Guide to create/update tables in Oracle, usually using PROC SQL (or the Query Builder) to output to a SAS library defined with SAS/ACCESS to Oracle.

 

As with all database operations, you need to take care that you're not rewriting tables that you shouldn't.  SAS DI Studio supports the discipline of data management whereas SAS Enterprise Guide is more of a general-use application.  But if your goal is to add new tables to Oracle, that's simple.  

 

If you have more specific questions about how to accomplish this, I suggest posting back in a new thread with your objective and as much sample data/code as you can muster.

Learn from the Experts! Check out the huge catalog of free sessions in the Ask the Expert webinar series.

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 687 views
  • 1 like
  • 2 in conversation