topic Re: Simplified DateTime in SAS Enterprise Guide

Simplified DateTime

sdang — Tue, 19 May 2015 21:36:40 GMT

How can I make this DateTime variable (See below) to "01Jan2015:00:00:00.000"dt and still have it as Date/Time variable.

thanks

Re: Simplified DateTime

sdang — Tue, 19 May 2015 21:46:01 GMT

Just wanted to add. I still want to keep it as Date/Time variable but with the seconds., etc as 00:00:00.000.

Re: Simplified DateTime

SASKiwi — Tue, 19 May 2015 22:37:50 GMT

proc format;

picture MyDT
other = '%d%B%Y:%0H:%0M:%0s' (DATATYPE=DATETIME);

run;

data _null_;

now = datetime();

format now MyDT26.3;

put now = ;

run;

Re: Simplified DateTime

sdang — Tue, 19 May 2015 22:55:24 GMT

It is not doing it. I still have the same result, showing the trailing minutes and seconds.. I want minutes and seconds as 00:00:00.000. The result I wanted like that because I have two data sets with PlayDate and IGTCreatedDate (see image below). I want to join them together.

Above is just a sample data. I want to show the format between PlayerDayDate and IGTAccountCreated. Because of the format I cannot join them together. The reason I want to join them is to see if a guest join on 01May2015 and play on 01May2015.

Please help me.

Re: Simplified DateTime

ballardw — Tue, 19 May 2015 22:55:32 GMT

datetimevariable = dhms(datepart(datetimevariable),0,0,0);

Re: Simplified DateTime

sdang — Tue, 19 May 2015 23:01:51 GMT

Thank you, that is what I need. You solved my problem.

Re: Simplified DateTime

sdang — Tue, 19 May 2015 23:02:51 GMT

Thank you

SASKiwi