topic Write Date from SAS to Oracle in SAS Programming

Write Date from SAS to Oracle

DavidPhillips2 — Tue, 17 Mar 2020 20:29:14 GMT

For some reason when I try to write this SAS table to and Oracle table of time date the date in the oracle table shows 1960. I know I'm missing something simple.

proc sql;
create table test1
(academic_period_time date);
quit;

proc sql;
insert into test1(academic_period_time)
values('05MAY2023'D,);
quit;

Re: Write Date from SAS to Oracle

ChrisNZ — Tue, 17 Mar 2020 20:33:36 GMT

Oracle stores datetimes, not dates.

SAS should translate for you, but seems not to here.

Try

insert into test1(academic_period_time) values('05MAY2023:0:0'dt);

Re: Write Date from SAS to Oracle

Tom — Tue, 17 Mar 2020 20:34:01 GMT

Yes. You are missing the fact that Oracle does not actual have a DATE data type. It only has DATETIME. Any reasonable number of days will look like some time early in the morning of January first 1960.

I would work better to just use SAS code to add data, but if you want to use the SQL INSERT statement then give it a datetime value.

values('05MAY2023:00:00'DT)