How do I join a subset data using SAS Data Studio

[xliu1]

I am using "SAS Data Studio - Prepare Data" module to upload several tables.

These are the transforms I did to meet the query conditions

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

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.