Using SAS Folders when EG and Metadata Server are on the same PC?

[hollandnumerics]

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?

[RahulG · Accepted solution]

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.

[Patrick]

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

[hollandnumerics]

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

[RahulG]

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.