topic Re: INPUT Statement in SAS Programming

INPUT Statement

BU2B — Tue, 16 Sep 2014 12:50:53 GMT

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!

Re: INPUT Statement

Jagadishkatam — Tue, 16 Sep 2014 13:07:42 GMT

please try the informat anydtdtm20.

data have;

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

date = input(date1,anydtdtm20.);

format date datetime20.;

run;

Thanks,

Jag

Re: INPUT Statement

RW9 — Tue, 16 Sep 2014 13:10:04 GMT

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;

Re: INPUT Statement

BU2B — Tue, 16 Sep 2014 13:14:50 GMT

Thanks guys! Both very helpful answers.

Steve