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
Try it with:
proc sql;
create table mycalendar as
select distinct (datref - mynumber*24*60*60) as mydatrf format = datetime20.
from Library1.mydataset
;
quit;
Try it with:
proc sql;
create table mycalendar as
select distinct (datref - mynumber*24*60*60) as mydatrf format = datetime20.
from Library1.mydataset
;
quit;
Thanks it works.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.