topic Re: Help me find a better code in SAS Programming

How to read/format time values

anucharbe — Thu, 03 Mar 2016 20:57:10 GMT

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 — Thu, 03 Mar 2016 20:47:07 GMT

What does the data look like originally?

ChrisHemedinger — Thu, 03 Mar 2016 20:50:00 GMT

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 — Fri, 04 Mar 2016 01:40:07 GMT

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