Date: Tue, 1 Jul 2008 10:25:55 -0700
Reply-To: "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Schwarz, Barry A" <barry.a.schwarz@BOEING.COM>
Subject: Re: Update info in data set based on other data set
Content-Type: text/plain; charset="us-ascii"
Is this close to what you want?
Sort A by id and date
Sort B by id and date
Read A observation
WHILE B.id < A.id OR
(B.id = A.id AND B.date <= A.date)
Read B observation
varx = (A.date = B.date AND A.id = B.id)
From: Jan Sunde [mailto:snip]
Sent: Tuesday, July 01, 2008 6:27 AM
Subject: Update info in data set based on other data set
I have a problem as follows :
I want to create a dataset C that copies all of data set A as well as
adds an additional variable (varx) as 0/1 based on whether an
observation id in dataset A occurs in dataset B (on the same date).