topic Re: Converting $27 to datetime format in New SAS User

Converting $27 to datetime format

JackoNewbie — Sun, 13 Oct 2019 21:55:27 GMT

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!

Re: Converting $27 to datetime format

novinosrin — Sun, 13 Oct 2019 22:03:36 GMT


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

Re: Converting $27 to datetime format

andreas_lds — Mon, 14 Oct 2019 09:38:48 GMT

@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.

Re: Converting $27 to datetime format

Tom — Mon, 14 Oct 2019 13:11:34 GMT

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?

Re: Converting $27 to datetime format

JackoNewbie — Sun, 20 Oct 2019 19:08:42 GMT

This worked 😄

Thanks!