topic Re: Invalid Numeric data on timepart in SAS Programming

Invalid Numeric data on timepart

EarlyCode — Tue, 10 May 2016 17:53:22 GMT

I have a report that has a time value in excel formatted to MM: SS. (01:32; 00:56, etc)

When imported, they import as a text string. I need to convert it into a value that can be used in calculations. I've tried a couple of different methods to convert the text string. (Including changing the string to HH:MM: SS format) But every method I've tried to use to convert it returns null value and the Invalid numeric data, Time='00:26' error.

Can someone help me with the correct method to convert a time text string to a value that can be used for calculations?

Re: Invalid Numeric data on timepart

PGStats — Tue, 10 May 2016 18:05:45 GMT

myTime = input(myTimeString, time.);

Re: Invalid Numeric data on timepart

EarlyCode — Tue, 10 May 2016 18:17:16 GMT

Returns numerical values, that aren't in time format. If a second Format myTime Time.; is run it will show it in a time format, but the seconds become minutes. So 00:08 becomes 480 which SAS reads as 0:08:00 instead of 0:00:08.

A work around I've just come up with is
min = input(substr(myTimeString,1,2),2.);
sec = input(substr(myTimeString,4,2),2.);
myTime = (min*60) + sec;
FORMAT myTime Time.;

Which does convert 00:08 to 0:00:08. But seems like a lot of extra steps that I'm not sure if it's needed.

Re: Invalid Numeric data on timepart

PGStats — Tue, 10 May 2016 18:32:29 GMT

myTime = input(myTimeString, time.);

format myTime time5,;

Re: Invalid Numeric data on timepart

Astounding — Tue, 10 May 2016 18:45:49 GMT

If you don't mind a message about conversion on the log, you could shorten your equations to:

myTime = 60* input(myTimeString, 2.) + scan(myTimeString, 2, ':');

Re: Invalid Numeric data on timepart

EarlyCode — Tue, 10 May 2016 19:17:29 GMT

Still converts seconds to minutes.

Re: Invalid Numeric data on timepart

EarlyCode — Tue, 10 May 2016 19:18:05 GMT

This works with fewer steps. Thank you,