topic Re: Date isue in SAS Programming

Date isue

KalaBhairava — Sat, 14 Apr 2018 08:31:32 GMT

HI All,

I have dates like 2017-10-05T13:00 in $22 format i want to convert it in to CDISC is860 format how i can...?

Re: Date isue

PaigeMiller — Sat, 14 Apr 2018 12:56:24 GMT

You probably have to read it in using one of the ANYDTDTM formats to make it a numeric.

http://documentation.sas.com/?docsetId=leforinforref&docsetTarget=p1hsn1ji141r4zn0z3xm2dthop6a.htm&docsetVersion=9.4&locale=en

Then, all you have to do is apply the desired format ISO 8601 format

http://documentation.sas.com/?docsetId=leforinforref&docsetTarget=p1a0qt18rxydrkn1b0rtdfh2t8zs.htm&docsetVersion=9.4&locale=en

Re: Date isue

Jagadishkatam — Sat, 14 Apr 2018 14:06:24 GMT

Isn't the date 2017-10-05T13:00 in CDISC IS8601 format. This is the format. You want to convert this into a numeric format. Please confirm in which format you want to convert this date. So we could suggest.

Re: Date isue

Kurt_Bremser — Sat, 14 Apr 2018 16:06:38 GMT

Use the E8601 informat

Re: Date isue

KalaBhairava — Sat, 14 Apr 2018 19:05:13 GMT

Yes I want to convert it into numeric ,presently it in $20. format I want to present it in E8601DT19.

Re: Date isue

Jagadishkatam — Sun, 15 Apr 2018 03:45:05 GMT

   data _null_; 
     length x $22 ; 
     x='2017-10-05T13:00'; 
     value=input(x,e8601dt19.); 
     put value=datetime19.;
run;