Prev: repeated measures proc mixed
Next: 10% off "Power User's Guide to SAS Programming" until April 30
From: Ram on 2 Apr 2010 11:19
Hi,

Has anyone come across a sas program which can read an oracle dmp file
into a sas dataset? Data base administrators prefer providing a dmp
file rather than providing an unload file. Pointing to any SUGI paper
or any other documentation is appreciated.

~Ram
From: Patrick on 2 Apr 2010 22:38
Hi Ram

As I didn't know the answer I did a quick research in the Oracle docu.
This is what I've found (http://download.oracle.com/docs/cd/B19306_01/
server.102/b14215/exp_imp.htm#sthref2124):

"An export file is an Oracle binary-format dump file..." "Export
dump files can only be read by the Oracle Import utility."


As an export dump file is in a Oracle proprietary binary format and
used for data exchange Oracle to Oracle I strongly assume that such a
file can't be read by SAS. Even if one would achieve to write some
"hack" with SAS code this wouldn't be the way to go.

I would suggest that you should ask for a unload file - OR: Use SAS
\Access to Oracle and read the Oracle tables directly with SAS.

HTH
Patrick
 | 
Pages: 1
Prev: repeated measures proc mixed
Next: 10% off "Power User's Guide to SAS Programming" until April 30