Date:         Tue, 9 Mar 2004 23:12:24 +0200
Reply-To:     Arto Raiskio <arto-nospam@RAISKIO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arto Raiskio <arto-nospam@RAISKIO.COM>
Subject:      Re: how to use sql coalesce with time
Content-Type: text/plain;

Richard A. DeVenezia wrote
> Here is an updated program.  First time I've ever done a merge inside a do
> until loop, but it seems to be ok.

great stuff.
here's another twist, what if the data a contains another record, say an
hour later, reset the clock and compare data b

ie.
data a;input record1 $10. xcode $ timestamp time.;datalines;
123456770 A 07:27:00
123456780 A 07:10:00
123456790 A 08:11:00
123456780 A 08:15:00  /* 2nd time, over 1 hr later */
run;