Date format changing while processing SAS file to oracle Sql

[Patrick]

It's imho a flaw that the SAS/Access to Oracle engine doesn't recognize all the OOTB SAS Date and DateTime formats but if you use Date. and Datetime. then things will just work implicitely without any extra options.

I've just run below code which loads a SAS Date and DateTime value into Oracle (creating a new table in Oracle) and things just work.

data work.SAS_table;
  format SAS_Date_var date9. SAS_DateTime_var datetime21.;
  SAS_Date_var=today();
  SAS_DateTime_var=datetime();
run;

proc append data=work.SAS_table base=ora.Oracle_Table;
run;quit;

That's how the Oracle table then looks like from the SAS side:

And here from the Oracle side via SQL Developer

[Patrick]

Assign a format of DATE9. to the SAS variable. I believe if that's done then the SAS/Access to Oracle engine gets it and converts your SAS date value correctly to a Oracle DATE value.