topic Re: can a lookup transformation return multiple rows? in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/can-a-lookup-transformation-return-multiple-rows/m-p/117997#M1405 <HTML><HEAD></HEAD><BODY><P>For a single base value, it will return maximum one look-up value (or values if you specified more than on look-up to target mappings).</P><P>If your lookup table contains duplicates on the look-up value, it will return the first match.</P></BODY></HTML> Tue, 06 Nov 2012 15:36:24 GMT LinusH 2012-11-06T15:36:24Z can a lookup transformation return multiple rows? https://communities.sas.com/t5/SAS-Data-Management/can-a-lookup-transformation-return-multiple-rows/m-p/117996#M1404 <HTML><HEAD></HEAD><BODY><P>Can a lookup transformation in SAS DI return multiple rows?</P></BODY></HTML> Tue, 06 Nov 2012 05:58:33 GMT https://communities.sas.com/t5/SAS-Data-Management/can-a-lookup-transformation-return-multiple-rows/m-p/117996#M1404 Sandhyaa 2012-11-06T05:58:33Z Re: can a lookup transformation return multiple rows? https://communities.sas.com/t5/SAS-Data-Management/can-a-lookup-transformation-return-multiple-rows/m-p/117997#M1405 <HTML><HEAD></HEAD><BODY><P>For a single base value, it will return maximum one look-up value (or values if you specified more than on look-up to target mappings).</P><P>If your lookup table contains duplicates on the look-up value, it will return the first match.</P></BODY></HTML> Tue, 06 Nov 2012 15:36:24 GMT https://communities.sas.com/t5/SAS-Data-Management/can-a-lookup-transformation-return-multiple-rows/m-p/117997#M1405 LinusH 2012-11-06T15:36:24Z Re: can a lookup transformation return multiple rows? https://communities.sas.com/t5/SAS-Data-Management/can-a-lookup-transformation-return-multiple-rows/m-p/117998#M1406 <HTML><HEAD></HEAD><BODY><P>No. Exactly as Linus explained.</P><P>If you want this to happen then you will have to code it (user written transformation) - or you use a SQL join instead.</P></BODY></HTML> Wed, 07 Nov 2012 10:31:29 GMT https://communities.sas.com/t5/SAS-Data-Management/can-a-lookup-transformation-return-multiple-rows/m-p/117998#M1406 Patrick 2012-11-07T10:31:29Z