topic Re: MMDDYY10 FORMAT TO DATETIME20 in SAS Programming

MMDDYY10 FORMAT TO DATETIME20

BU2B — Fri, 18 Dec 2015 15:40:41 GMT

Hey all,

I need to convert a date format from MMDDYY10. to DATETIME20. I've tried just about every suggestion I could Google and here and nothing is working. Here's my latest stab...

DATA ETRM_CREP_VA1_SWING;

SET ETRM_CREP_VA1_SWING;

OPERATION_DT = INPUT(OPERATION_DT, MMDDYY10.)*86400;

RUN;

Re: MMDDYY10 FORMAT TO DATETIME20

ballardw — Fri, 18 Dec 2015 15:51:19 GMT

You'll need a bit more the new value should be built with the DHMS function to get the correct offset. If your current variable operation_dt is character then :

DATETIMEVariable = DHMS(input(operation_dt,mmddyy10.),0,0,0);

where the 0 are the hour, minute and second you want to assign, you could use any valid hour, minute and second value

If the Operation_DT variable is a SAS date value then you could use

Operation_DT = DHMS(Operation_DT ,0,0,0);

then assign a datetime format:

Format Operation_DT datetime20.;

I would strongly suggest not creating character variables to hold datetime values as if you ever need pieces, such as month, day, year, or want to compare with other values you end up with lots of headaches.

Re: MMDDYY10 FORMAT TO DATETIME20

BU2B — Fri, 18 Dec 2015 15:58:03 GMT

That worked, thanks so much!