SAS Prompts Programmatically

[DipeshGupta]

I have a question.

Is it possible to create SAS Prompts Programmatically..??

I am using a Stored Process Program and to wants to pass the values in the static list prompts through codes. Is it possible..??

If yes, How..??

[Kurt_Bremser]

Prompts are defined in metadata. Although it may be possible to create metadata objects programmatically, I would strongly advise against it. One skewed program run and your metadata repository is trashed. Since the repository constitutes one big SPOF, it should be treated with utmost care.

What you can do is to define dynamic prompts that take their data from datasets. You can even create cascading prompts, where the results of a first prompt can be used as a where condition on the following prompt(s).

[DipeshGupta]

First, I was using dynamic Prompts only but there I am facing a problem as Dynamic Prompts can only access data from SAS Folders but in my Stored Process Model, I have a library named Model which will be created on the path given by the user so that differeent users or even same user but different sessions can be run without any confusion because the Library name will be same(MODEL) but the data will be stored at different path.

Now the problem occurs with SAS Folders as I can create Library named MODEL at different locations for different users but how can I do this with the SAS Folders. How can I create different SAS Folders for different users or link it with the Library created by different users at different path.

How can I use Dynamic Prompts in such a case..??

[Kurt_Bremser]

If the prompt engine from SAS can't handle your issues, consider building the prompts yourself with HTML forms & Javascript. That's how I do such things.

You will have to sharpen your skills in web page creation, of course.

HTML 5

HTML 4

Javascript

(These are the documents I go to when I have to do web programming)

[DipeshGupta]

Okay but is there any other solution to my problem that goes through SAS and not through Self Created WebPages..??

Beacuse we are focussing to achieve everything through SAS.

[Kurt_Bremser]

When you get screws instead of nails, it's time to look for a screwdriver in addition to the hammer.

Maxim 14: Use the right tool.

Trying to use SAS as the do-all Swiss Army Knife won't do it in the long run, IMO. Given the seeming complexity of your project, you should consider getting help from SAS or a SAS consultant.