DATA Step, Macro, Functions and more

connection issue to oracle database

Accepted Solution Solved
Reply
Contributor
Posts: 65
Accepted Solution

connection issue to oracle database

Hi ,

I have installed SAS University edition in my lap ,I also have oracle database,I am trying to get the data from oracle database by connecting to it through passthrough facility in sas,am getting the following error,am new in doing this,pls help me out,

proc sql;
63 connect to oracle (user=hr password=XX path='D:\Users\rmolla\Desktop\New folder (4)');
ERROR: The ORACLE engine cannot be found.
ERROR: A Connection to the oracle DBMS is not currently supported, or is not installed at your site.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
64 create table test1 as
65 select * from connection to oracle
66 (select * from departments);
 
 
Regards,
Rubia.

 


Accepted Solutions
Solution
‎06-22-2017 06:25 AM
Super User
Posts: 7,781

Re: connection issue to oracle database

SAS UE does not support connections to databases.

Export tables from the DB to flat files and import those via the shared folder into SAS UE.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers

View solution in original post


All Replies
Solution
‎06-22-2017 06:25 AM
Super User
Posts: 7,781

Re: connection issue to oracle database

SAS UE does not support connections to databases.

Export tables from the DB to flat files and import those via the shared folder into SAS UE.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 126 views
  • 0 likes
  • 2 in conversation