Date:         Tue, 26 Nov 2002 12:48:01 -0500
Reply-To:     "Braten, Michael (Exchange)" <mbraten@BEAR.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Braten, Michael (Exchange)" <mbraten@BEAR.COM>
Subject:      Re: extract records
Comments: To: Max F <max8ca@YAHOO.COM>
Content-Type: text/plain

If you used  PROC SQL, then please send the entire code of the query.  It
will help in the solution of your problem.
> -----Original Message-----
> From: Max F [SMTP:max8ca@YAHOO.COM]
> Sent: Tuesday, November 26, 2002 12:30 PM
> To:   SAS-L@LISTSERV.UGA.EDU
> Subject:      extract records
>
> Hi there,
>
> I need to extract records from two data sets. Data set
> One has a single date record for a given ID and Data
> set Two has multiple date records for a given ID. I
> need to pull out record from Data set Two whose date
> is within minus 4 days and plus 7 days of a date in
> Data set One.
>
> I tried using
>
>       where date2 between (date1 - 4) and (date1 +7)
>
> in a data step but it did not do it. It returned dates
> in Data set One that are more than 4 days before
> date2.
>
>
> TIA
>
>
> Max
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com


 ****************************************************************
Bear Stearns is not responsible for any recommendation, solicitation,
offer or agreement or any information about any transaction, customer
account or account activity contained in this communication.
***********************************************************************