converting character variable to a time variable

[hein68]

Hello.  I'm stuck and would appreciate your help.

I have a character variable that has times that look like this:

12:00:00 AM

12:01:00 AM

12:02:00 AM etc.

I want to convert them to a time value that assigns 0:00:00 for 12:00:00 AM through 23:59:00 for 11:59 PM.  What do I need to do?

I use SAS Enterprise Guide 7.1 or SAS 9.4.

Thanks!

[ballardw · Accepted solution]

---

@hein68 wrote:

Hello.  I'm stuck and would appreciate your help.

I have a character variable that has times that look like this:

12:00:00 AM

12:01:00 AM

12:02:00 AM etc.

I want to convert them to a time value that assigns 0:00:00 for 12:00:00 AM through 23:59:00 for 11:59 PM.  What do I need to do?

I use SAS Enterprise Guide 7.1 or SAS 9.4.

Thanks!

---

The example below should help. You would use a data step with a set statement to reference your existing data and the input function should reference your character time variable. The datalines is to create values to display the code working. The format is so the value displays as time and not just the number of seconds represented.

data example;
   input char_text $ 1-11 ;
   timevar= input (char_text,time11.);
   format timevar timeampm11.;
datalines;
12:00:00 AM
12:01:00 AM
12:00:00 PM
12:01:00 PM
;
run;

[hein68]

Yes, this worked. Thanks so much!

[TomKari]

To do it with the tasks in EG, create a query, create a new advanced expression, and use the functions combination that @ballardw shows you.

Tom

[hein68]

Thanks so much!