Desktop productivity for business analysts and programmers

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

Accepted Solution Solved
Reply
Contributor
Posts: 35
Accepted Solution

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

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?


Accepted Solutions
Solution
‎01-07-2016 05:58 PM
Regular Contributor
Posts: 236

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

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.

View solution in original post


All Replies
Solution
‎01-07-2016 05:58 PM
Regular Contributor
Posts: 236

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

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.

Respected Advisor
Posts: 3,837

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

[ Edited ]

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

 

Contributor
Posts: 35

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

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

Regular Contributor
Posts: 236

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

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 452 views
  • 2 likes
  • 3 in conversation