Date: Fri, 5 Nov 1999 16:00:32 +0100 peter.crawford@DB.COM "SAS(r) Discussion" Peter Crawford Re: A Time check poll To: ABELSOR@westat.com text/plain; charset=us-ascii

a slant on time ( ok, SAS time ! ) What is time 35:60 or 34:120 ? =noon tomorrow ! Test it with a simple statement like this ..... %put %sysfunc( inputn( 34:120, time), datetime); in the log 02JAN60:12:00:00

hour values greater than 23 and minute values greater than 60 are "equally respected" and carry over into the next hour or day!

Datum: 05.11.99 15:40 An: SAS-L@listserv.uga.edu

Antwort an: ABELSOR@westat.com

Betreff: Re: A Time check poll Nachrichtentext:

Well, I stand corrected. However, the SAS function HMS does not (according to TFM) accept an hour greater than 23. A test contradicts this, though.

1 data; 2 time24 = hms(24,0,0); 3 format time24 hhmm5.; 4 put time24=; 5 run;

TIME24=24:00 NOTE: The data set WORK.DATA1 has 1 observations and 1 variables. NOTE: The DATA statement used 0.28 seconds.

So, I conclude that any solution to this problem will have to take 2400 as a valid value.

Bob Abelson Westat

____________________Reply Separator____________________ Subject: Re: A Time check poll Author: "CUMMING; GORDON (PB)" <GC6872@MSG.PACBELL.COM> Date: 11/04/1999 1:43 PM

I was brought up under the belief that time went as follows 23:59:59.99, 24:00:00.00, 00:00:00.01 and with rounding 23:59, 24:00, 00:00 depending on the resolution of your clock. Most clock displays ignore the 24:00 as it comes by so fast and why add extra work for a perfect clock. If you need it why not use an analog timepiece. So for all purposes 23:59 < 24:00 < 00:00 in other words 24:00 does not equal 00:00 mathematically.

_gordon

> After talking with many of the people I work with about this, I thought > I would come to the newgroup with many different views. Given a > character variable (mytime) that is 4 chars long containing time values > (hhmm) how would you check for valid clock time (24 hour clock). One > obvious answer is to strip out the hours and minutes and check each for > valid values (if 0 > hour > 24 or if 0 > mins > 59 then ERROR CONDITION) > but I would like to take a pole on the different methods used. Some > here have used methods that allow an hour of 25...and I never had an > hour of 25 on my clock. Remember this is clock time not elapsed time. > > Regards, > Vicki aka California Doll > The great doing of little things makes the great life. > - Eugenia Price

Back to: Top of message | Previous page | Main SAS-L page