Convert character string to datetime in SAS

user_7076616 0
Viewed 731

How can I convert 2020-12-04T12:54:38.9215456+01:00 to a datetime in SAS? My solution below does not give any result.

data temp;
timestamp = '2020-12-04T12:54:38.9215456+01:00';
run;

data temp;
set temp;
date = substr(timestamp, 1, 10);
time = substr(timestamp, 12, 8);
date_and_time = cat(date, " ", time);
new_datetime = input(date_and_time, datetime24.);
format new_datetime datetime24.;
run;
sas
2 Answers

I think you need the date part in DATE9. format.

Code

data temp;
ts='2020-12-04T12:54:38.9215456+01:00';
dt=put(input(substr(ts, 1, 10), yymmdd10.), date9.);
tm=substr(ts, 12, 8);
new_ts=input(cat(dt, ' ', tm), datetime24.);
format new_ts datetime24.;
run;
user_22949780

Try the anydtdtm. informat.

data temp;
timestamp = '2020-12-04T12:54:38.9215456+01:00';
to_dt = input(timestamp, anydtdtm.);
format to_dt datetime20.;
run;

Result:
04DEC2020:12:54:38
user_104686130
Related