topic Re: Queries in SAS DI Studio in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Queries-in-SAS-DI-Studio/m-p/93722#M988 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Thu, 26 Sep 2013 02:13:10 GMT Patrick 2013-09-26T02:13:10Z Queries in SAS DI Studio https://communities.sas.com/t5/SAS-Data-Management/Queries-in-SAS-DI-Studio/m-p/93721#M987 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> 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?</P><P></P><P>Thanks in advance,</P><P></P><P></P><P>Regards,</P><P>Sheeba Swaminathan</P></BODY></HTML> Wed, 25 Sep 2013 20:35:22 GMT https://communities.sas.com/t5/SAS-Data-Management/Queries-in-SAS-DI-Studio/m-p/93721#M987 Sheeba 2013-09-25T20:35:22Z Re: Queries in SAS DI Studio https://communities.sas.com/t5/SAS-Data-Management/Queries-in-SAS-DI-Studio/m-p/93722#M988 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Thu, 26 Sep 2013 02:13:10 GMT https://communities.sas.com/t5/SAS-Data-Management/Queries-in-SAS-DI-Studio/m-p/93722#M988 Patrick 2013-09-26T02:13:10Z Re: Queries in SAS DI Studio https://communities.sas.com/t5/SAS-Data-Management/Queries-in-SAS-DI-Studio/m-p/93723#M989 <HTML><HEAD></HEAD><BODY><P>You could also use the Look-up transformation right off, that will pick only one record from the look-up table.</P><P>Is there any logic you wish to apply when choosing the B record?</P></BODY></HTML> Thu, 26 Sep 2013 10:05:27 GMT https://communities.sas.com/t5/SAS-Data-Management/Queries-in-SAS-DI-Studio/m-p/93723#M989 LinusH 2013-09-26T10:05:27Z Re: Queries in SAS DI Studio https://communities.sas.com/t5/SAS-Data-Management/Queries-in-SAS-DI-Studio/m-p/93724#M990 <HTML><HEAD></HEAD><BODY><P>tnx a lot Patrick.</P><P></P><P>Distinct keyword helped me out.</P></BODY></HTML> Thu, 26 Sep 2013 17:57:46 GMT https://communities.sas.com/t5/SAS-Data-Management/Queries-in-SAS-DI-Studio/m-p/93724#M990 Sheeba 2013-09-26T17:57:46Z Re: Queries in SAS DI Studio https://communities.sas.com/t5/SAS-Data-Management/Queries-in-SAS-DI-Studio/m-p/93725#M991 <HTML><HEAD></HEAD><BODY><P>tnx a lot Linush.</P><P></P><P>Any record from Table B would be a fit for join....</P></BODY></HTML> Thu, 26 Sep 2013 17:59:45 GMT https://communities.sas.com/t5/SAS-Data-Management/Queries-in-SAS-DI-Studio/m-p/93725#M991 Sheeba 2013-09-26T17:59:45Z