Date conversion

AZIQ1 — Tue, 12 Jul 2016 22:54:29 GMT

Hi,

I have a dataset with date as text (2016-01-07 01:48:11.000) I want to change it to DATETIME17. format? any help?

Thanks

Re: Date conversion

ballardw — Tue, 12 Jul 2016 23:11:30 GMT

In a datastep you would want to create a new variable;

data want;

set have;

dt = input(textdate,anydtdtm32.);

format dt datetime17.;

run;

where textdate is the name of your current variable