Selecting a Table Using a Prompt

paulrockliffe — Thu, 29 Jun 2017 15:11:33 GMT

I'm using a Prompt with a Code Node to let a user select a table to run the code on. I'd like the user to be able to select from a list of all of the tables in the Project, with the Prompt automatically picking up the values to offer to the user. My code is splitting a table up into a number of smaller tables and will be used across a wide range of projects.

Is this possible?

I was thinking that there may be a table within SASHELP that contains that information, but I can't find it. Alternative methods gratefully received.

As a follow-on question, if the above is possible I would like to be able to set a second prompt that lets you select one of the columns from the selected table. I think I can do this using cascading prompts, but again any pointers gratefully received.

Thanks!

Re: Selecting a Table Using a Prompt

tomrvincent — Mon, 14 Oct 2019 15:58:15 GMT

Load all the tablenames into a metadata table before kicking off the project.

topic Re: Selecting a Table Using a Prompt in SAS Enterprise Guide

Selecting a Table Using a Prompt

Re: Selecting a Table Using a Prompt