Luanne, If you have control of the Oracle export process, check out these instructions from the Oracle web site on how to get the output in standard CSV format (with quotes around the header values that are giving you so much grief) http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:88212348059 This process would be easier if you have SAS/Access to Oracle or SAS/Access to ODBC licensed and installed on your PC. Then you could just attach to Oracle with a LIBNAME statement and use the Oracle tables just like SAS data sets. You can check to see what you have licensed by submitting this code and reviewing the results in your log: PROC SETININT NOALIAS;
RUN;
If you do have SAS/Access to Oracle licensed, but it's not working for you check out http://support.sas.com/techsup/technote/ts703.pdf for instructions on how to verify the installation and for sample code to access your Oracle tables with a LIBNAME statement.
... View more