SAS EG: Need help understanding how Dynamic Prompt List of SP works

[meatballs12345]

Hi everyone!

I'm new to Stored Process and after all the research and everything I think I'm now into the correct path of asking the right questions. So, my development now is to update the prompt of an existing Stored Process and make it reflect the correct list from a certain data source. Now, here are my questions, please correct me if my terms are wrong. Thank you so much!

• Am I right to call the encircled part of the picture below as the "Prompt List"? If not, what is it called and how do I make this dynamic that it updates itself right after I hit the RUN button so it can reflect whatever changes made to its data source?

• The goal is to add new category to that list but it's gonna be from a different table. Further checking the code inside the Stored Process, I assumed that the block of code inside the SP is the source of it, but I realized lately that it's not because after I ran multiple times, the code below won't update that prompt list. Note that my change is from UNION onwards. Am I barking at the wrong tree? Or is there a specific configuration that populates that list? Here's the list INSIDE the SP:

proc sql;
create table work.fi_list as
select distinct case 
                          when bnk in (0, 5) then 'Universal and Commercial Bank'
                          when bnk in (1, 2, 3, 7) then 'Thrift Bank'
                          when bnk in (4, 8) then 'Rural and Cooperative Bank'
                          when bnk = 57 then 'Trust Corporation'
                          else 'Non-Bank Financial Institution'
          from LIB1.DTSRC1
union
select distinct case 
                          when bnk = 31 then 'Pawnshop'
                          when bnk = 60 then 'Money Service Businesses'
                          else 'Non-Bank Financial Institution'
             from LIB2.DTSRC2;
quit;

• Is there any other way to trace how a certain SAS table is populated aside from using the "search" option on SAS EG, SAS DI and SAS MC? Unfortunately, I don't have access to their server/unix box. Also I don't think this project have an repository of all their codes so I'm really running out of options of tracing the other possible creator of that data source.

• Do I really need to use the SASSRV user in order for me to fully test the Stored Processes?

[AhmedAl_Attar · Accepted solution]

Hi,

Have a look at this presentation Using Dynamic Lists in SAS Stored Processes for Genetic Toxicity 

Here are additional links to How to use the Prompt Framework

• Getting Started with SAS® Prompts  
• Be Prompt! Do it Now! Creating and Using Prompts in SAS Enterprise Guide   

Note: while the two links above are related to SAS Enterprise Guide, the Interface almost identical for the SAS Stored Process.

Hope this helps,

Ahmed