09-25-2013 04:35 PM
I am planning to use a join transformation in SAS DI Studio to join two tables A and B. The relationship between A and B is one to Many. For each row in A , I would like to take only one record from B. Is there any function which allows to perform this?
Thanks in advance,
09-25-2013 10:13 PM
How would you select this record from "B"? Could you use a DISTINCT or Group By in a sub-select prior to joining with A so that the relationship becomes 1:1?
09-26-2013 06:05 AM
You could also use the Look-up transformation right off, that will pick only one record from the look-up table.
Is there any logic you wish to apply when choosing the B record?