Chris, I believe your suggestion is to select prompt value from Cell when SAS Add in opens a pop up asking for prompt value. Or pass the complete list as a data source (text/xml) to Store procedure. In both the cases SP will be triggered with only one set of prompt values. But my requirement is to run this process for multiple set of prompts. See if we can get this way: Lets assume I have a EG process which filters observations and create report based on prompt value. Prompts: Sex (=M/F) Age (>= Value) When user runs this process, SAS will ask for prompt. Lets say user enters (M, 14). SAS will create report for these values. If user has another set of parameters (say F, 12) for an another report then user will have to re-run this process with new prompt values. Think if he has many such sets. Each time he'll have to manually trigger the process with new prompt values. I was just trying to automate this manual effort. PS: User does adhoc reporting, so scheduling is not an option + User doesn't know much programming!! ... View more

Thanks SASKiwi, but the problem is how to run the entire process for each set of parameters i.e each row of excel. If i have to code then I can put the entire process in a SAS Macro function and then call that with each set of input parameters. But unlike SAS DI, SAS EG doesn't have a loop task that can be embed in process to loop the entire process. My team is not mature in coding and  that's why I'm looking for a point & click solution here!! ... View more