topic Re: How to Create Stored Process from Scratch in Developers

How to Create Stored Process from Scratch

jl1005 — Thu, 04 May 2017 04:02:16 GMT

Hi,

I think I'd need a stored process to accomplish what I'd like. I'm using a prompt to select a list of names from a data set, but the data set has 1,400 rows, so it's tedious to scroll through and find each name. So I'd like to create a cascading prompt where the user can enter the first 2-3 letters of a persons name, then have another dynamic list which will list the results of the search.

If I'm understanding this correctly, the filtering would be done through a stored process. But I'm just running a local sas installation, with programs only being run on the local server with no metadata server setup, which is the reason I don't think I can create stored processes.

So is there a better way to accomplish this, or would I need to setup a metadata server in order to do this?

Thank you

Re: How to Create Stored Process from Scratch

jl1005 — Thu, 04 May 2017 16:19:48 GMT

Unfortunately, I checked, and do not have the license for a metadata server, so I'm unable to create the cascading prompt. Does anyone have any suggestions on how to go about selecting names in a better manner, or am stuck having to scroll through the entire list to select each name?

Re: How to Create Stored Process from Scratch

FredrikE — Wed, 17 May 2017 08:32:13 GMT

I don't fully understand why you need a stored process, are you using SAS EG?

If so you can use a dynamic prompt. By default you can search for values using that prompt 🙂

Sorry 'bout the swedish, hope you get it.

//Fredrik