topic Re: variable with time13.3 format to numeric format conversion in ODS and Base Reporting

variable with time13.3 format to numeric format conversion

rkumar23 — Thu, 30 Oct 2014 08:01:40 GMT

I may have lost my mind at the moment so any quick idea would help certainly....

So I have variable which is in the TIME13.3 format whereas I have another variable which is in numeric format ....Now I need to put a WHERE clause however before that need to convert TIME13.3 format variable to the numeric format I tried PUT function however that doesn't seems to work...quick thought please?

Re: variable with time13.3 format to numeric format conversion

RaviKommuri — Thu, 30 Oct 2014 08:49:57 GMT

May be you can use a similar code like the code I have given below.

MYTIME = INPUT(PUT(TIME1,BEST12.),$40.);

Re: variable with time13.3 format to numeric format conversion

Kurt_Bremser — Thu, 30 Oct 2014 10:13:07 GMT

TIME13.3 is a numeric format, so your variable is already numeric (seconds of the day) and can be "converted" by simply changing its format.

I suspect that yoout other variable has a specific sequence of digits; could you give an example?

Re: variable with time13.3 format to numeric format conversion

rkumar23 — Fri, 31 Oct 2014 06:57:52 GMT

Thanks Kurt you was correct i put the TIMEPART(VAR2) and it resolved the problem...thanks for pointing in right direction..