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!
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;
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
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
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
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.