Date time informat that works when the date time lengths are different

knveraraju91 — Mon, 23 Apr 2018 13:30:12 GMT

Dear,

For the following variable 'a', I need to use two informats to get the output I need. Is there any other format that can both OBS.

output needed;

01SEP17:15:10:00

04SEP17:00:00:00

Thank you.

data one;
input a $16.;
datalines;
2017-09-01T15:10
2017-09-04
;
data two;
set one;
b=input(a, anydtdtm.);
c=input(a,?? is8601dt.);
format b c datetime16.;
run;

Re: Date time informat that works when the date time lengths are different

RW9 — Mon, 23 Apr 2018 13:38:54 GMT

Well, a simple conditional:

data one;
  input a $16.;
datalines;
2017-09-01T15:10
2017-09-04
;
run;

data two;
  set one;
  b=ifn(lengthn(a)=10,input(catx('T',a,"00:00"),e8601dt.),input(a,e8601dt.));
  format b datetime.;
run;

Its more or less the same thing however.

topic Date time informat that works when the date time lengths are different in SAS Programming

Date time informat that works when the date time lengths are different

Re: Date time informat that works when the date time lengths are different