topic Any way to make prompt values from an external file? in SAS Enterprise Guide

Any way to make prompt values from an external file?

AdnanH — Thu, 06 Sep 2018 12:46:15 GMT

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?

Re: Any way to make prompt values from an external file?

andreas_lds — Thu, 06 Sep 2018 12:55:34 GMT

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).

Re: Any way to make prompt values from an external file?

Kurt_Bremser — Thu, 06 Sep 2018 12:58:04 GMT

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).

Re: Any way to make prompt values from an external file?

AdnanH — Thu, 06 Sep 2018 13:00:34 GMT

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

Re: Any way to make prompt values from an external file?

Kurt_Bremser — Thu, 06 Sep 2018 13:16:34 GMT

@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