topic Reading date time in SAS in SAS Studio

Reading date time in SAS

kvpseshu — Fri, 15 Sep 2017 13:41:45 GMT

I am trying to read date and time into one variable which is in below format DD-MM-YYYY HH:MM

eg: 18-08-2017 20:55

informat Modified_DateTime datetime.;
input Modified_DateTime  1-17;

LinusH — Fri, 15 Sep 2017 13:45:11 GMT

So, how is it going?

Given your code snippet, your informat doesn't match your source data.

Find a more appropriate format in the SAS informat documentation.

kvpseshu — Fri, 15 Sep 2017 14:00:42 GMT

I have tried finding possible informats but not successful

ballardw — Fri, 15 Sep 2017 14:38:24 GMT

Did you try the anydtdtm. informat?

data junk;

x="18-08-2017 20:55";

y=input(x, anydtdtm.);

format y datetime.;

run;