LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2004, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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;

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