INPUT Statement

[BU2B]

Hey all,

I have a variable that's CHAR with length16 (2014-07-01 00:15).  I want to convert this to a DATETIME, so I tried the INPUT statement.

date = input(date1,datetime.);

Any help would be appreciated, thanks!

[Jagadishkatam · Accepted solution]

please try the informat anydtdtm20.

data have;

date1='2014-07-01 00:15';

date = input(date1,anydtdtm20.);

format date datetime20.;

run;

Thanks,

Jag

[RW9]

There are various ways of doing it, mdy function etc.  Its more about selecting the appropriate formats for the data.  Below I show some which will get you the result (note you can combine the steps, have them here just as a descriptive).  Anyways, probably easiest is the anydtdtm informat.

data want;

  attrib a format=$16. b format=date9. c format=tod5. d format=datetime. e format=datetime.;

  a="2014-07-01 00:15";

  b=input(substr(a,1,10),yymmdd10.);

  c=input(substr(a,12,5),time5.);

  d=input(put(b,date9.)||":00"||put(c,tod5.),datetime.);

  e=input(a,anydtdtm.);

run;

[BU2B]

Thanks guys!  Both very helpful answers.

Steve