topic Problem managing date in SAS in SAS Data Science

Problem managing date in SAS

garag — Tue, 13 Dec 2011 14:52:06 GMT

Hi,

I've the following problem managing date in SAS.

Here you are my code

proc sql;

create table mycalendar as

select distinct (datref - mynumber) as mydatrf format = datetime20.

from Library1.mydataset

;

quit;

Library1 points to a table on Oracle database where the field datref is a date and mynumber is numeric field.

My goal is to have the result of the query as "datetime20." SAS format but if I use the proc above it fails, because for example it the datref is 29/11/2011 and mynumber is -1 I get

29NOV2011:00:00:01 instead of 30NOV2011:00:00:00.

Any idea?

Many thanks

Problem managing date in SAS

art297 — Tue, 13 Dec 2011 15:17:09 GMT

Try it with:

proc sql;

create table mycalendar as

select distinct (datref - mynumber*24*60*60) as mydatrf format = datetime20.

from Library1.mydataset

;

quit;

Problem managing date in SAS

garag — Tue, 13 Dec 2011 15:37:58 GMT

Thanks it works.