Problem managing date in SAS

[garag]

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

[art297 · Accepted solution]

Try it with:

proc sql;

   create table mycalendar as

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

     from Library1.mydataset

;

quit;

[garag]

Thanks it works.