topic Re: SAS dynamic prompts - data sources list in Developers

SAS dynamic prompts - data sources list

wsdabreu — Mon, 11 Jun 2018 20:31:40 GMT

Hi everyone,

I'm trying to add a new data to create a dynamic list in stored process, but when I click in Browse button, SAS don't show me the libraries, only a default SAS Folder. Is this normal? I even can't access the sas.help library...

Re: SAS browse

Reeza — Mon, 11 Jun 2018 20:31:20 GMT

I believe data driven prompts have to have the tables registered in the metadata server, so you can't use any table in the prompt types.

@wsdabreu wrote:

Hi everyone,

I'm trying to add a new data to create a dynamic list in stored process, but when I click in Browse button, SAS don't show me the libraries, only a default SAS Folder. Is this normal? I even can't access the sas.help library...

Re: SAS dynamic prompts - data sources list

SuryaKiran — Mon, 11 Jun 2018 20:35:58 GMT

For dynamic lists the data has to be registered to metadata. Why not static list, if that works for you?

User selects values from a static list>get values> Browse>servers>your server>Library>dataset

Re: SAS dynamic prompts - data sources list

wsdabreu — Tue, 12 Jun 2018 17:18:36 GMT

Thanks for your support, Unfortunatelly I need the dynamic tables. You have some article explaining how can I put the datatset in metadata server?

Re: SAS dynamic prompts - data sources list

SuryaKiran — Tue, 12 Jun 2018 18:08:57 GMT

This might help:

http://support.sas.com/documentation/cdl/en/seclibag/66930/HTML/default/viewer.htm#p1n6n3za1i6vqdn1te0skoywkiom.htm