topic Re: changing numerical variable into datetime in New SAS User

changing numerical variable into datetime

sonrana — Wed, 16 Feb 2022 07:39:09 GMT

I want to convert 1562018 numeric to datetime, please help.

PeterClemmensen — Wed, 16 Feb 2022 08:09:50 GMT

What datetime value would 1562018 be ? 15/06/2018 00:00:00?

Amir — Wed, 16 Feb 2022 08:12:35 GMT

Are you simply looking for something like the following? If not then please edit your question to provide more context.

data want;
   dt = put(1562018,datetime20.);
run;

Kind regards,

Amir.

Kurt_Bremser — Wed, 16 Feb 2022 09:17:57 GMT

See Maxim 42. Quality of question has an immense influence on the quality of answers.

Could it be that you have a Julian date, 156th day of 2018?