convert into is8601dt format

[paddyb]

trying to convert sdtm date into is8601dt format in adam,not working,what I am missing?

TR02SDTM=input(EXSTDTC,is8601dt.);

[Kurt_Bremser]

Use the e8601dt informat.

[paddyb]

not working:(

[Kurt_Bremser]

Post the log, please. An some example data (see my footnotes for this).

[paddyb]

data exb1_;
24
25 set exb;
26 by usubjid;
27 if first.usubjid then do;
28 TR02SDT=input(EXSTDTC,e8601da.);
29
30 TR02SDTM=input(EXSTDTC,e8601dt.);
31 end;
32 if last.usubjid then do;
33 tr02edt=input(exendtc,e8601da.);
34 end;
35 format tr02sdtm e8601dt.;
36 format TR02SDT tr02edt e8601da.;
37 run;

NOTE: Invalid argument to function INPUT at line 30 column 13.

[Kurt_Bremser]

Use the

e8601dt16.

informat.

[novinosrin]

I dont think there is an is8601dt informat to convert to a date numeric variable before you apply is8601dt  format 

You prolly need E8601DTw.d informat . Correct me if i am wrong

[ChrisHemedinger]

I'm a little confused by your log and the format of the original values.  Doesn't something like this work?

data d;
 exstdtc = "2003-03-26T09:00";
 tr02sdtm = input (exstdtc,is8601dt.);
 format tr02sdtm is8601dt.;
run;

[SuryaKiran]

unexpected leading or trailing blanks maybe causing the missing values. use COMPRESS() and check.

data test;
var1='		2003-03-26T09:00';
var2='2003-03-26T09:00';
need1=input(var1,is8601dt.);
need2=input(var2,is8601dt.);
run;

 

[paddyb]

Thanks everyone.Problem was with blank space.

used tr02sdtm=input(strip(exstdtc),e8601dt.); and it worked