Re: Queries in SAS DI Studio

Sheeba · Posted 09-25-2013 04:35 PM

Hi,

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,

Regards,

Sheeba Swaminathan

Patrick · Posted 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?

Sheeba · Posted 09-26-2013 01:57 PM

tnx a lot Patrick.

Distinct keyword helped me out.

LinusH · Posted 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?

Data never sleeps

Sheeba · Posted 09-26-2013 01:59 PM

tnx a lot Linush.

Any record from Table B would be a fit for join....