How to read/format time values

[anucharbe]

I am working with an assignment.

Here is the code- 

data XXX;
81 infile datalines;
82 length time 8;
83 informat time time5.;
84 format time time5.;
85 input @1time @8With $5.;

I want the time as in this format- 

11:00

9:00

3:00 

I tried many different set of codes but I could not find a code which would provide the desired output.

Please help me if you could.

Thanks 

Anu

[Reeza]

What does the data look like originally?

[ChrisHemedinger]

Hi Anu,

Do you have an external file that you're reading this data from?  Can you post a portion of that?

And are you looking to represent clock times (9:00 AM or 13:00 24-hr time)?  Or something like a time span (6:45 for 6 hrs, 45min)?

What's the "WITH" variable?

Chris

[Ksharp · Accepted solution]

data x;
x='09:00:00't;
format x hhmm5.;
run;