Date:         Sun, 11 Dec 2005 00:54:15 -0800
Reply-To:     freiraum@GMAIL.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         freiraum@GMAIL.COM
Organization: http://groups.google.com
Subject:      Fill empty values from lookup-table
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset="iso-8859-1"

Hallo all,

I have 3 datasets.
Dataset 1:

A    | B    | C
-------------------
1    | w     |
2    | x     |
3    |       | y
4    |       | z

Dataset 2 and 3 are lookup-tables for the missing values of "B" and
"C".

Is it possible to iterate through dataset 1 in a datastep and if
variable B or C is empty, iterate through the corresponding
lookup-tables to fill in the missing value in dataset 1?

It doesnt necessarily need to be in a datastep. PROC SQL would be fine,
too.

Thanks is advance,
Jakl