Date:         Tue, 8 Jul 2008 07:52:37 -0400
Reply-To:     Jan Sunde <jan.sunde@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jan Sunde <jan.sunde@GMAIL.COM>
Subject:      Re: Update info in data set based on other data set

Sorry about my delay in answering. I want to thank you all for the solutions
proposed on this list. Contrary to my previous statement, they DID work!
The culprit was the DATE variable in my data set that hadn't been set
properly in the previous step and thus came up empty. No wonder the query
came up empty.....Typical example of PEBKAC
(Problem Exists Between Keyboard And Chair)

Btw, the sub-query solutions were *far* less efficient than using the
concatenated variable CATS(id||date) for lookup (proposed by Ian),
especially with a data set of close to 700k observations! I chose to go with
that solution, elegant and definitely something I will adapt to other use.

Thanks to all of you, especially Mary and Ian who seem to have been the most
eager contributors :)

Jan
(eager to learn more SAS programming)