SAS Enterprise guide

[mariajohnqwerty]

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

[ChrisHemedinger]

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.