How do you access a data set for a dynamic prompt using SAS Folders when EG and Metadata Server are on the same PC?
I can create a prompt from a static list, but I'd prefer to use a dynamic list. However, the dynamic list asks for data in SAS Folders. I have a Metadata Server on the same PC, but how do you link to the data set via SAS Folders?
You need to register the dataset in your SAS Metadata folder using SAS Management Console or SAS Data Integration Studio.
Once dataset is registered, it should be visible when you browse SAS Folders while creating dynamic prompt.
You need to register the dataset in your SAS Metadata folder using SAS Management Console or SAS Data Integration Studio.
Once dataset is registered, it should be visible when you browse SAS Folders while creating dynamic prompt.
@RahulG has already given you the answer.
It doesn't matter whether the metadata server is on the same machine or not. If everything is installed locally: Just make sure that you connect your EG session to the metadata server and not to local.
Patrick and RahulG,
Thanks for the advice. However, I've decided to revert back to manually updating the static list in the prompt, because I'm not sure my client will be able to maintain the Metadata Server without help in the future. They will be able to follow instructions to reload the prompt's static list from a data set though, which will not require anything more than Local Server access.
Unfortunately sometimes the neat bits are not necessarily the most appropriate.
..............Phil
Registering dataset is one time activity and then later on you need to keep your dataset updated through some DI job/EG project so client need not to maintain Metadata Server.
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!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.