Date:         Mon, 9 Jul 2007 12:44:24 -0400
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>" <nospam@HOWLES.COM>
Subject:      Re: Weird behavior with computed time values

On Sun, 8 Jul 2007 23:05:54 -0400, Horne, Jim - James S
<Jim.S.Horne@LOWES.COM> wrote:
[SNIP]
>
>I have the following data that I can not figure out why what happens is
>happening.
>           ad_
>offtarget target adj_time
>
>  -5:22   31:00   25:37
>    -16   31:00   14:48
>  -4:49   31:00   26:10
>  -4:56   31:00   26:03
>  -4:33   31:00   26:26
>  -5:11   31:00   25:48
>  -5:55   31:00   25:04
>  -9:34   31:30   21:55
>    -12   31:30   19:20
>
>Offtarget is computed by "offtime = adj_time - adj_target".  The values
>are usually correct but sometimes they are not - and the format appears
>to change.  All variables here are formatted as TIME5.
>
>Can someone tell me why I am getting the odd values for offtarget
>intermittently?

You have "adj_target" in your formula but "ad_target" (no "j") in the data,
but I'll assume that's just a typo.

A time5. format cannot accommodate a 2-digit hour segment, a 2-digit minute
segment, a colon, and a minus sign; that's 6 characters. So it rounds away
the minutes.

Try time6. instead.

>
>Thanks in advance,
>
>Jim Horne
>ITE-Large Systems & Messaging
>Lowe's Companies, Inc.
>336-658-4959
>jim.horne@lowes.com