Time format

[proximo20]

Time is reported like this in the data that I work on:

Time

0930
0931
0932
.
.
.

I need to convert it to

09:30:00
09:31:00
09:32:00

Thanks in advance.

 

[sasbuddy]

There could be multiple ways to do it.
Considering the input variable is in character format then you can use following expressions

tm = timepart(dhms(00,substr(time,1,2),substr(time,3,2),00));
put tm =time8.;

sasbuddy

http://sites.google.com/site/sasbuddy/

 

[proximo20]

Thanks, but this is how the log file looks like:
time.
time.
time.
time.
time.
time.
time.
.
.
.
so I had the cancel the submitted statements.

 

[sasbuddy]

Request you to make sure that you use appropriate variables names.
This should work.

sasbuddy

http://sites.google.com/site/sasbuddy/