I am using "SAS Data Studio - Prepare Data" module to upload several tables.
These are the transforms I did to meet the query conditions
![xliu1_1-1635438056534.png xliu1_1-1635438056534.png](https://communities.sas.com/t5/image/serverpage/image-id/65139i9A87EC30FFCC2EDD/image-size/medium?v=v2&px=400)
![xliu1_2-1635438083139.png xliu1_2-1635438083139.png](https://communities.sas.com/t5/image/serverpage/image-id/65140i90B0FE016B8EBB98/image-size/medium?v=v2&px=400)
But 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
![xliu1_0-1635437929588.png xliu1_0-1635437929588.png](https://communities.sas.com/t5/image/serverpage/image-id/65138iA24FE914436B6301/image-size/medium?v=v2&px=400)
I checked on documentation (https://documentation.sas.com/doc/en/dprepcdc/v_002/datastudioadv/p1rjhz79auas6bn1bd0zbqxu6dys.htm)
but did not find any specifics regarding this. Any help is appreciated. Thanks.