Date: Tue, 7 Dec 2004 13:01:30 -0600
Reply-To: "Dunn, Toby" <Toby.Dunn@TEA.STATE.TX.US>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Dunn, Toby" <Toby.Dunn@TEA.STATE.TX.US>
Subject: Re: Simple data querying problem
Content-Type: text/plain; charset="us-ascii"
Here is one metho dusing SQL, but there are many and even this SQL
solution isn't as elegant as one that say SIG or Howard would cook up.
create table c (drop = btime) as
select a.time as atime , b.time as btime
from a as a ,
b as b
where ((btime - 1) <= atime <= (btime + 1));
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Tuesday, December 07, 2004 12:44 PM
Subject: Simple data querying problem
Sorry about the last post - it seemed to want to send itself. in the
meanwhile - I thought of a better way to explain the problem...
I am trying to identify observations in dataset A that occured within 1
hour of any observation in dataset B, and place these observations in a
new dataset. Note that time is in hh.hh format such that 13.50 = 1:30
Thanks, I really appreciate any help that the list can provide. Zach