Desktop productivity for business analysts and programmers

SAS Enterprise guide

Occasional Contributor
Posts: 6

SAS Enterprise guide

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

Community Manager
Posts: 3,463

Re: SAS Enterprise guide

[ Edited ]
Posted in reply to mariajohnqwerty

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.

Ask a Question
Discussion stats
  • 1 reply
  • 1 like
  • 2 in conversation