Hi,
Is there a good way that I can use a single dataset to define the response options for several stored process prompts?
Suppose I make a MyPrompts dataset like:
Prompt Value Label Prompt1 A Pretty A Prompt1 B Pretty B Prompt2 X Pretty X Label Prompt2 Y Pretty Y Label
Prompt2 Z Pretty Z Label
In SAS Management Console, I would like to define a stored process and create Prompt1 which would have options A/B (formatted as Pretty A / Pretty B) and also Prompt2 with options X/Y/Z. Similar to the way you can make a single CNTLIN dataset for PROC FORMAT which defines multiple formats.
Currently I end up making a separate dataset for each prompt, and registering each prompt-specific dataset in the metadata, which is a hassle.
I think I could do what I want in SAS Management Console when I create a dynamic prompt, if there was a way that I could say to use MyPrompts as the data source for a prompt *and* specify a criteria to subset its rows. So when I create Prompt1, I would specify the data source as MyPrompts (where(Prompt="Prompt1")).
I thought maybe I could get what I want by using Dependencies. But the dependencies only allow me to subset the source data by the value of another prompt. In this case, I would want to subset by a literal value. I suppose it might work if I defined a hidden prompt for each prompt which has the name of the prompt. But ugh.
Thanks,
--Q.
I think that you outlined the two options available to you: (1) separate view or table and (2) hidden, dependent prompt.
Vince DelGobbo
SAS R&D
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.