DATA Step, Macro, Functions and more

convert character date/time string to SAS format datetime

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 121
Accepted Solution

convert character date/time string to SAS format datetime

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!

 

 

 

 


Accepted Solutions
Solution
2 weeks ago
Frequent Contributor
Posts: 123

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

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;
Thanks,
Suryakiran

View solution in original post


All Replies
Super User
Posts: 17,819

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

Did you try INPUT with the ANYDTDTM. informat?

Trusted Advisor
Posts: 1,374

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

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.

Solution
2 weeks ago
Frequent Contributor
Posts: 123

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

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;
Thanks,
Suryakiran
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 124 views
  • 1 like
  • 4 in conversation