Any way to make prompt values from an external file?

[AdnanH]

Hi,

I am using the prompt manager to let the user select a given date. I then take the user input to access files according to the selected date. But the the files are being generated continuously. Instead of going into prompt manager and adding a value manually each time, is there a way to update the prompt values from for an example a sas table?

[andreas_lds]

This is not possible in one step. You need to register the dataset with the dates in metadata and change the prompt to access a dynamic list. Unfortunately you can't update that dataset automatically each time a user starts the project(flow), you have to move the update to another program and the user must execute that manually. Or you add the update to the process providing the external files (if possible).

[Kurt_Bremser]

The prompt manager allows to use dynamic lists for a prompt.

Under "Methods for populating prompt", select "User selects values form a dynamic list". Under Data source, select a dataset (this dataset needs to be registered in metadata).

[AdnanH]

Thank for the info. I am quite new to SAS. How do i register the dataset in the metadata?

[Kurt_Bremser]

---

@AdnanH wrote:

Thank for the info. I am quite new to SAS. How do i register the dataset in the metadata?

---

Do this with the SAS Management Console, or with Enterprise Guide as described here: https://communities.sas.com/t5/SAS-Enterprise-Guide/Registering-Table-with-metadata/td-p/99703