Converting $27 to datetime format

[JackoNewbie]

Hi,

I have a large dataset where the dates are in format '$27' and displayed like '

2018-09-01 14:21:51:333 GMT

'. I need to convert this to datetime13 or datetime18. What would be the best way to do this?

Thanks in advance for any help given!

[novinosrin · Accepted solution]

data want;
have='2018-09-01 14:21:51:333 GMT';
want=input(have,  ymddttm19.);
format want datetime20.;
run;

[JackoNewbie]

This worked 😄

Thanks!

[andreas_lds]

---

@JackoNewbie wrote:

Hi,

I have a large dataset where the dates are in format '$27' and displayed like '

2018-09-01 14:21:51:333 GMT

'. I need to convert this to datetime13 or datetime18. What would be the best way to do this?

Thanks in advance for any help given!

---

If you can, fix the creation of that datasets, so that a proper datetime-variable is created. There is hardly any good reason for storing datetimes as strings at all.

[Tom]

Do you really have datatime values with different time zones than GMT? 

If so do you need the values adjusted so that they are synchronized to a single time zone?