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
data x;
x='09:00:00't;
format x hhmm5.;
run;
What does the data look like originally?
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
data x;
x='09:00:00't;
format x hhmm5.;
run;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.