As of the stable 2024.04 SAS Viya release, you can specify whether the values for the column selector control in a custom step come from an input table or from another column selector control.
Here is the new option:
Select any image to see a larger version.
Mobile users: To view the images, select the "Full" version at the bottom of the page.
In this example custom step, the first column selector has its selections tied to an input table.
The second column selector is tied to the first column selector which means its available values for selection will come from the values selected in the first column selector.
Note: The Link to column selector option lists the column selector controls in the step that are linked to input tables. This list does not include column selectors that are linked to another column selector control. In other words, the second column selector will not show as possible link to another column selector.
I also used a new style feature available for custom step controls to indent the second column selector to make it more visually obvious that is related to the first column selector.
When I preview the custom step, I can select certain columns for the first column selector control.
Once I have selected those four columns for the first column selector control, I can only select from those for the second column selector control.
This is an enhancement to the column selector control that you can take advantage of in your custom step design. For more information on the Column Selector control in a custom step, refer to the following:
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning and boost your career prospects.