06-17-2013 01:45 AM
I have SAS on windows with EG. But I don't have Oracle software. The database is a Oracle dump file. How could I access the database and convert that to SAS format for each of the table contained in the dump file? Thank you!
06-17-2013 06:40 AM
There are to my knowldge no SAS tool that support Oracle dump files.
You need to convert it to a SAS readable format, including different flat files or RDBMS.
There are some third party converter tools out there, but I have no experience in using them.
Even if you don't have Oracle locally on you computer, by restoring the dump file to a remote Oracle DB, you can access it using SAS/ACCESS to Oracle or ODBC.
06-18-2013 04:28 AM
Your options would be:
06-17-2013 07:42 AM
Try (if possible) to install ORACLE Express (http://www.oracle.com/technetwork/products/express-edition/overview/index.html) on your PC and load the ORACLE dump file into it, then
Either -Export the individual tables as text files
OR, if you have SAS/ACCESS to ORACLE, use the ORACLE libname engine to access the tables.
Just a thought,