topic Re: how to format time from excel in SAS Programming

how to format time from excel

thanhnguyenhtl — Sat, 23 Oct 2021 04:39:23 GMT

Hi everyone,

I prepare file for trading hours with beginning and close time of date.

Start	End
09:00:00	17:00:00
08:30:00	14:52:00
09:00:00	13:00:00

I import this file into SAS and merge it with trading hours. Then I code and got error:

where (localtime >= start and localtime <= end);

ERROR: WHERE clause operator requires compatible variables.

Could you please advise how to make this code work? I tried to format time for START and END but the format time8. is not work.

Thank you,

Re: how to format time from excel

ChrisNZ — Sat, 23 Oct 2021 05:29:19 GMT

This indicates that all variables are not the same type.

I'd expect all 3 to be numeric. Please check that they are. Use proc contents for example.

Re: how to format time from excel

ballardw — Sat, 23 Oct 2021 05:37:10 GMT

And where does Localtime come from?

Run Proc Contents or look at your variable properties in the SAS data set with your preferred method. One of those variables is not like the other in terms of variable type.

The FORMAT of a variable has nothing to do with the result of comparisons. There are many formats that could display any given value but unless you force the format to be used such as with Put(somevar,Aformatname.) the underlying values of the variable are used for comparison not the appearance of the format.

Re: how to format time from excel

ChrisNZ — Fri, 29 Oct 2021 21:56:26 GMT

Did you find the error?