topic Re: Converting Character date with time in to numeric with leangth of 8 in SAS Enterprise Guide

Converting Character date with time in to numeric with leangth of 8

ambadi007 — Thu, 13 Jun 2019 06:26:54 GMT

Team,

Trying to convert the dates like below to a numeric with the length of 8 , but its not converting right.

value-2019-07-25T 15:35

Re: Converting Character date with time in to numeric with leangth of 8

PeterClemmensen — Thu, 13 Jun 2019 06:29:20 GMT

Do you want to convert it to a date or datetime value?

Re: Converting Character date with time in to numeric with leangth of 8

ambadi007 — Thu, 13 Jun 2019 06:32:28 GMT

the same format I need , but the type should be numeric

Re: Converting Character date with time in to numeric with leangth of 8

PeterClemmensen — Thu, 13 Jun 2019 06:52:46 GMT

you can convert it to a numeric datetime value like this. Then format to your liking

data test;
    chardt="2019-07-25T 15:35";
    dt=input(chardt, B8601DT.);
run;

Re: Converting Character date with time in to numeric with leangth of 8

Kurt_Bremser — Thu, 13 Jun 2019 06:55:00 GMT

Since your datetime looks very much like a ISO-standard, I suspect that the blank is not really there, so this will work:

data test;
dt_char = '2019-07-25T15:35';
dt_num = input(dt_char,e8601dt16.);
format dt_num e8601dt16.;
run;

By testing (Maxim 4) I found out that the e8601 informat is tolerant about such blanks anyway:

data test;
dt_char = '2019-07-25T 15:35';
dt_num = input(dt_char,e8601dt20.);
format dt_num e8601dt16.;
run;

Re: Converting Character date with time in to numeric with leangth of 8

ambadi007 — Thu, 13 Jun 2019 07:35:00 GMT

Its coming correctly but now the value showing like

2019-07-25T 15:35:00

but I need it like

2019-07-25T 15:35

how to remove the extra zeros

Re: Converting Character date with time in to numeric with leangth of 8

Kurt_Bremser — Thu, 13 Jun 2019 08:52:48 GMT

Then you haven't run my code.

data test;
dt_char = '2019-07-25T 15:35';
dt_num = input(dt_char,e8601dt20.);
format dt_num e8601dt16.;
run;

proc print data=test noobs;
run;

Result:

     dt_char         dt_num

2019-07-25T 15:35    2019-07-25T15:35

As you can see, no blanks and no trailing zeroes with the numeric variable.

Re: Converting Character date with time in to numeric with leangth of 8

ambadi007 — Thu, 13 Jun 2019 09:34:02 GMT

I have ran the code with

e8601dt20 format

since I am getting the error like width specified for E8601DT is invalid .. so If iam using e8601dt20 it is coming with extra zero

Re: Converting Character date with time in to numeric with leangth of 8

Kurt_Bremser — Thu, 13 Jun 2019 11:04:06 GMT

@ambadi007 wrote:

I have ran the code with
e8601dt20 format
since I am getting the error like width specified for E8601DT is invalid .. so If iam using e8601dt20 it is coming with extra zero

Note that my code specifically uses a width of 16 for the display format, and it works and does not display the seconds. If you have further problems, please post your code and log.

According to the documentation of the E8601 display format (Maxim 1!), the range for the width is 16 to 26.