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 (April 2002, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 8 Apr 2002 10:38:40 -0700
Reply-To:     Sheila Whitelaw <sw75@BOXFROG.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sheila Whitelaw <sw75@BOXFROG.COM>
Subject:      Re: Merge by range
Content-Type: text/plain; charset=ISO-8859-1

Thank you very much for all the help. I have never used SQL before in SAS, it is very helpful. I have one more question. Consider the following example,

Input dataset 1: OBS ID Date1 Date2 Var1 1 65 03/01/2001 04/04/2001 M 2 65 04/01/2001 04/15/2001 B

Input dataset 2: OBS ID Date3 Var2 1 65 03/04/2001 7 2 65 04/01/2001 8

Result: OBS ID Var1 Var2 1 65 M 7 2 65 B 8

In dataset 2, the second record has a date that within the date range in both record 1 and record 2 of dataset 1. I need to match it to the record that has the latest date (in this case, record 2). Does anyone how to do it?

Thanks again.

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