BookmarkSubscribeRSS Feed
xliu1
Quartz | Level 8

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.pngxliu1_2-1635438083139.png

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

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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Discussion stats
  • 0 replies
  • 653 views
  • 0 likes
  • 1 in conversation