Column not Accepted when Creating Oracle Table from SAS Dataset

[DavidPhillips2]

When I try to write a SAS dataset from SAS to Oracle I receive the error message:

ERROR: Error attempting to CREATE a DBMS table. ERROR: ORACLE execute error: ORA-00907: missing right parenthesis..

This might be due to the column names that I am trying to import.  Oddly there is no ‘(‘ in the column names. 

The list of column names is attached.

[kiranv_]

try options validvarname = any;

[DavidPhillips2]

Do use at the top of the script, like?

options validvarname = any;

libname ods oracle user=xxx password="xxxx"  path=ods1 schema=xxxx dbserver_max_bytes=1;

[kiranv_]

ya. try that

[DavidPhillips2]

Same error.  I think Oracle is more restrictive than SAS, looking into the restriction is tricky.

[kiranv_ · Accepted solution]

try this one last time PRESERVE_COL_NAMES = Yes

[DavidPhillips2]

The below worked:

proc sql;
create table ods.OPDS_IPEDS_MULTI_INST (PRESERVE_COL_NAMES = Yes) as
select * from yearsCombined;
quit;

Thanks for your help with this.  I having a hard time researching this one.