DATA Step, Macro, Functions and more

How to make one prompt required IF data is entered into a different prompt?

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 82
Accepted Solution

How to make one prompt required IF data is entered into a different prompt?

I have built a stored process that in which I built prompts in Management Console for  'Name',  'Address', 'City' and 'State'  columns.

 

If the user enters a value in either the prompt for 'Name' or 'Address',  they want the 'City' & 'State' prompt fields to be required to be populated.

 

From what I have read, the cascading prompt associates a list of values to choose from for a given prompt.  I do not see any options in SMC that I could set to make the 'Name' & 'Address' prompts require a value to be entered into the 'City' & 'State' prompts if the user enters values in either or both the 'Name' & 'Address' prompts..

 

I would appreciate any direction on how to accomplish this task.

 

Thanks is advance!!


Accepted Solutions
Solution
‎03-03-2016 04:20 PM
Contributor
Posts: 66

Re: How to make one prompt required IF data is entered into a different prompt?

Posted in reply to ncsthbell

Hi ncsthbell,

The type of prompt you are looking for is called a "Selection Group" prompt. It is the IF/THEN equivalent for prompting.I've not done this in SMC, only EG. But here are the steps. Essentially within the prompt manager click on New > New Group. Change the type to Selection group. Add your displayed initial text and name of prompt. Click the Selection-Dependent Groups tab. 

Click New Group. Enter text and value. Click OK. Then click New Group and add the next text and value.

 

At this point you have 2 dependent groups within your main group. Think of these 2 dependent groups as your branches. Then add your City and State prompts to one of those branches. 

 

Hopefully this should point you in the right direction.

Michelle Buchecker

Director of Technical Training Services

ThotWave Technologies

Michelle

View solution in original post


All Replies
Solution
‎03-03-2016 04:20 PM
Contributor
Posts: 66

Re: How to make one prompt required IF data is entered into a different prompt?

Posted in reply to ncsthbell

Hi ncsthbell,

The type of prompt you are looking for is called a "Selection Group" prompt. It is the IF/THEN equivalent for prompting.I've not done this in SMC, only EG. But here are the steps. Essentially within the prompt manager click on New > New Group. Change the type to Selection group. Add your displayed initial text and name of prompt. Click the Selection-Dependent Groups tab. 

Click New Group. Enter text and value. Click OK. Then click New Group and add the next text and value.

 

At this point you have 2 dependent groups within your main group. Think of these 2 dependent groups as your branches. Then add your City and State prompts to one of those branches. 

 

Hopefully this should point you in the right direction.

Michelle Buchecker

Director of Technical Training Services

ThotWave Technologies

Michelle
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 169 views
  • 0 likes
  • 2 in conversation