Reading date time in SAS

[kvpseshu]

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]

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]

I have tried finding possible informats but not successful

[ballardw · Accepted solution]

Did you try the anydtdtm. informat?

data junk;

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

y=input(x, anydtdtm.);

format y datetime.;

run;