topic Re: convert char to datetime in New SAS User

convert char to datetime

Arun_shSAS — Sun, 08 Sep 2019 17:11:31 GMT

Hi Guys,

I have "2018-10-01 00:00:00:00" as char value and I want to convert it into sas datetime value through proc sql .. please help me out.

Thanks,

Arun

novinosrin — Sun, 08 Sep 2019 17:20:58 GMT

Will this help?

proc sql;
select *,input(char,ymddttm19.) as sas_datetime format=datetime20.
from your_input;
quit;

This assumes you have a char datetime variable in your input dataset

Jagadishkatam — Sun, 08 Sep 2019 20:12:48 GMT

please try the anydtdtm format

data have;
x='2018-10-01 00:00:00:00';
y=input(x,anydtdtm.);
format y datetime20.;
run;

Arun_shSAS — Mon, 09 Sep 2019 07:54:32 GMT

proc sql;
select *,input(my_time,anydtdtm.) as sas_datetime format=datetime20.
from temp;
quit;