topic Re: convert into is8601dt format in SAS Programming

convert into is8601dt format

paddyb — Tue, 17 Apr 2018 17:51:55 GMT

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

TR02SDTM=input(EXSTDTC,is8601dt.);

Re: convert into is8601dt format

Kurt_Bremser — Tue, 17 Apr 2018 18:02:01 GMT

Use the e8601dt informat.

Re: convert into is8601dt format

novinosrin — Tue, 17 Apr 2018 18:02:56 GMT

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

Re: convert into is8601dt format

paddyb — Tue, 17 Apr 2018 18:05:43 GMT

not working:(

Re: convert into is8601dt format

Kurt_Bremser — Tue, 17 Apr 2018 18:06:52 GMT

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

Re: convert into is8601dt format

paddyb — Tue, 17 Apr 2018 18:16:15 GMT

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.

Re: convert into is8601dt format

ChrisHemedinger — Tue, 17 Apr 2018 18:23:15 GMT

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;

Re: convert into is8601dt format

SuryaKiran — Tue, 17 Apr 2018 18:24:04 GMT

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;

Re: convert into is8601dt format

Kurt_Bremser — Tue, 17 Apr 2018 18:32:30 GMT

Use the

e8601dt16.

informat.

Re: convert into is8601dt format

paddyb — Tue, 17 Apr 2018 18:41:28 GMT

Thanks everyone.Problem was with blank space.

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