Calcite | Level 5

## Sas time input

Hi, trying to input a time formated
Hhmmsstt
What time input would i use
1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Sas time input

What do the T's represent?
Why don't you just ignore them?

``````data test;
string='13010240';
time=input(string,hhmmss6.);
put time= time=time12.3;
run;``````
```619  data test;
620    string='13010240';
621    time=input(string,hhmmss6.);
622    put time= time=time12.3;
623  run;

time=46862 time=13:01:02.000
```

If they mean 100's of a second then read them separately.

``````634  data test;
635    string='13010240';
636    time=input(string,hhmmss6.)+input(substr(string,7),2.2);
637    put time= time=time12.3;
638  run;

time=46862.4 time=13:01:02.400
``````

2 REPLIES 2
Super User

## Re: Sas time input

What do the T's represent?
Why don't you just ignore them?

``````data test;
string='13010240';
time=input(string,hhmmss6.);
put time= time=time12.3;
run;``````
```619  data test;
620    string='13010240';
621    time=input(string,hhmmss6.);
622    put time= time=time12.3;
623  run;

time=46862 time=13:01:02.000
```

If they mean 100's of a second then read them separately.

``````634  data test;
635    string='13010240';
636    time=input(string,hhmmss6.)+input(substr(string,7),2.2);
637    put time= time=time12.3;
638  run;

time=46862.4 time=13:01:02.400
``````

Calcite | Level 5

## Re: Sas time input

Thanks I ended up using B8601TM
Discussion stats
• 2 replies
• 141 views
• 0 likes
• 2 in conversation