https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Enterprise-guide/m-p/358978#M23633 <P>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.</P> <P>&nbsp;</P> <P>As with all database operations, you need to take care that you're not rewriting tables that you shouldn't. &nbsp;SAS DI Studio supports the discipline of data management whereas SAS Enterprise Guide is more of a general-use application. &nbsp;But if your goal is to add new tables to Oracle, that's simple. &nbsp;</P> <P>&nbsp;</P> <P>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.</P> Tue, 16 May 2017 17:24:06 GMT ChrisHemedinger 2017-05-16T17:24:06Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Enterprise-guide/m-p/358969#M23632 <P>Is it possible to write back data from sas to oracle with sas EG.or it is must to use SAS DI studio.</P> Tue, 16 May 2017 10:44:49 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Enterprise-guide/m-p/358969#M23632 mariajohnqwerty 2017-05-16T10:44:49Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Enterprise-guide/m-p/358978#M23633 <P>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.</P> <P>&nbsp;</P> <P>As with all database operations, you need to take care that you're not rewriting tables that you shouldn't. &nbsp;SAS DI Studio supports the discipline of data management whereas SAS Enterprise Guide is more of a general-use application. &nbsp;But if your goal is to add new tables to Oracle, that's simple. &nbsp;</P> <P>&nbsp;</P> <P>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.</P> Tue, 16 May 2017 17:24:06 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Enterprise-guide/m-p/358978#M23633 ChrisHemedinger 2017-05-16T17:24:06Z