The steps I take to create a Join between tables: In SAS Studio Visual Programmer Perspective Add a Query to the Process Flow Double click the Query Node to open it Click the Add '+' Dropdown in the Tables tab of the Query, and select 'Table' From Choose Table dialog, expand SASHELP and select CLASS table Click the Add '+' Dropdown in the Tables tab and select SASHELP.CLASSFIT Click the Add '+' Dropdown in the Tables tab, and select 'Join' In the "New Join" window, select CLASS.CLASS as the left table, and CLASSFIT.CLASSFIT as the right table Leave the 'Join type' as Inner Join Click the 'Save' button Click on columns tab of query Drag table CLASS.CLASS to "Add columns to include in the query (required)" Expand CLASSFIT.CLASSFIT and drag column 'predict' to the box of selected columns
... View more