https://communities.sas.com/t5/SAS-Viya/How-do-I-join-a-subset-data-using-SAS-Data-Studio/m-p/777032#M1152 <P>I am using "SAS Data Studio - Prepare Data" module to upload several tables.</P> <P>These are the transforms I did to meet the query conditions</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="xliu1_1-1635438056534.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/65139i9A87EC30FFCC2EDD/image-size/medium?v=v2&amp;px=400" role="button" title="xliu1_1-1635438056534.png" alt="xliu1_1-1635438056534.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="xliu1_2-1635438083139.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/65140i90B0FE016B8EBB98/image-size/medium?v=v2&amp;px=400" role="button" title="xliu1_2-1635438083139.png" alt="xliu1_2-1635438083139.png" /></span></P> <P>But&nbsp;I am not sure how to join a subset of table to meet the following conditions highlighted in yellow. SID_TERMID table needs to be filtered before it is joined with SID_DEGREES_AWARDED_ALL_VW</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="xliu1_0-1635437929588.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/65138iA24FE914436B6301/image-size/medium?v=v2&amp;px=400" role="button" title="xliu1_0-1635437929588.png" alt="xliu1_0-1635437929588.png" /></span></P> <P>I checked on documentation (<A href="https://documentation.sas.com/doc/en/dprepcdc/v_002/datastudioadv/p1rjhz79auas6bn1bd0zbqxu6dys.htm)" target="_blank">https://documentation.sas.com/doc/en/dprepcdc/v_002/datastudioadv/p1rjhz79auas6bn1bd0zbqxu6dys.htm)</A></P> <P>but did not find any specifics regarding this. Any help is appreciated. Thanks.</P> Thu, 28 Oct 2021 16:25:39 GMT xliu1 2021-10-28T16:25:39Z https://communities.sas.com/t5/SAS-Viya/How-do-I-join-a-subset-data-using-SAS-Data-Studio/m-p/777032#M1152 <P>I am using "SAS Data Studio - Prepare Data" module to upload several tables.</P> <P>These are the transforms I did to meet the query conditions</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="xliu1_1-1635438056534.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/65139i9A87EC30FFCC2EDD/image-size/medium?v=v2&amp;px=400" role="button" title="xliu1_1-1635438056534.png" alt="xliu1_1-1635438056534.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="xliu1_2-1635438083139.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/65140i90B0FE016B8EBB98/image-size/medium?v=v2&amp;px=400" role="button" title="xliu1_2-1635438083139.png" alt="xliu1_2-1635438083139.png" /></span></P> <P>But&nbsp;I am not sure how to join a subset of table to meet the following conditions highlighted in yellow. SID_TERMID table needs to be filtered before it is joined with SID_DEGREES_AWARDED_ALL_VW</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="xliu1_0-1635437929588.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/65138iA24FE914436B6301/image-size/medium?v=v2&amp;px=400" role="button" title="xliu1_0-1635437929588.png" alt="xliu1_0-1635437929588.png" /></span></P> <P>I checked on documentation (<A href="https://documentation.sas.com/doc/en/dprepcdc/v_002/datastudioadv/p1rjhz79auas6bn1bd0zbqxu6dys.htm)" target="_blank">https://documentation.sas.com/doc/en/dprepcdc/v_002/datastudioadv/p1rjhz79auas6bn1bd0zbqxu6dys.htm)</A></P> <P>but did not find any specifics regarding this. Any help is appreciated. Thanks.</P> Thu, 28 Oct 2021 16:25:39 GMT https://communities.sas.com/t5/SAS-Viya/How-do-I-join-a-subset-data-using-SAS-Data-Studio/m-p/777032#M1152 xliu1 2021-10-28T16:25:39Z