Desktop productivity for business analysts and programmers

SAS Enterprise guide

Reply
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: 2,889

Re: SAS Enterprise guide

[ Edited ]

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
  • 108 views
  • 1 like
  • 2 in conversation