Scott,
I want to perform the lookup for each observation in the dataset;for each pass of the data.
So, for example, if I had a dataset with 50 customers, I will perform a PROC SQL query based on one or more of the columns for each of the 50 observation dataset.
In PL\SQL, I could achieve this with code resembling the following.
Cursor C_Main is
Select CustomerID, ProductID, PurchaseDate
from SomeTable;
For C1_Rec in C_Main -- This loops through each record in the returned dataset
Loop
1. Perform Lookup information from other dataset(s).
2. Assign variables, etc based upon business logic
3. Update another table with variables values assigned in step 2.
End loop;
I'll work on the SAS equivalent this week and post my example.
Thanks for your help.
Troy