topic Re: convert character date/time string to SAS format datetime in SAS Programming

convert character date/time string to SAS format datetime

jenim514 — Thu, 27 Jul 2017 18:47:01 GMT

I have a date/time character string that looks like this:

02OCT07:2240

03APR07:1825

02OCT07:2240

I need some help converting this into a datetime sas format. I think some combination of input and scan?

Help is appreciated!

Re: convert character date/time string to SAS format datetime

Reeza — Thu, 27 Jul 2017 19:06:58 GMT

Did you try INPUT with the ANYDTDTM. informat?

Re: convert character date/time string to SAS format datetime

Shmuel — Thu, 27 Jul 2017 19:12:48 GMT

Read the input variable as a string, split it and then convert it to sas date/time variables.

See next code example:

data dtime;
      string = '02OCT07:2240';

     date = input(scan(string,1,':'), date7.);
     hh = input(substr(string,9,2),2.);
     mm = input(substr(string,11,2),2.);

     dtime = dhms(date,hh,mm,0);

    format date date9.    /* check also ddmmyy10. */
               dtime datetime15.;
run;

check the result of above code and adapt it to your needs.

Re: convert character date/time string to SAS format datetime

SuryaKiran — Thu, 27 Jul 2017 21:06:02 GMT

There are many way you can do, just apply which one fits your needs. Here another way for your queston:

DATA test;
FORMAT DATE DATETIME14.;
DATE_CHAR='02OCT07:2240';
DATE=INPUT(CATX(":",SUBSTR(DATE_CHAR,1,10),SUBSTR(DATE_CHAR,11)),DATETIME14.);
RUN;