convert character date/time string to SAS format datetime

[jenim514]

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!

[Reeza]

Did you try INPUT with the ANYDTDTM. informat?

[Shmuel]

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.

[SuryaKiran · Accepted solution]

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;