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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

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