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 2007, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 13 Apr 2007 00:24:17 -0700
Reply-To:     celiacai@GMAIL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         celiacai@GMAIL.COM
Organization: http://groups.google.com
Subject:      simple problem?
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Hi all,

Can anyone help me solve this? I have two datasets A and B. In A there are variables NUMBER and DATE1. In B there are variables NUMBER and DATE2. None of the variables is unique. My target is to match NUMBER, and then find DATE2 that falls into certain period, say, -15 days and +15 days, around DATE1. I tried merge by NUMBER, but since there are multiple DATE1s and DATE2s for a NUMBER, I don't think i've got the expected result. Any suggestion?


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