BookmarkSubscribeRSS Feed
sameer112217
Quartz | Level 8

Hello Everyone,

 

Suppose I am a SAS stored process developed and I am creating cascade three prompts in Stored Process.

 

1) Continent

2) Country

3) City

 

I want user to select continent first, then country and then last the city. What should I define for city prompt?

 

1) A dependency on the country prompt

2) A dependency on the Continent prompt

3) A dependency on the continent and country prompt

4)A dependency on the continent,country and city prompt

 

My analysis says dependency should be only for continent prompt since the dependency is for one filter which is for the prompt that is main one. Need suggestions and answer. The answer in the picture may be wrong. Not sure.

 

Please refer the attachment.

1 REPLY 1
RahulG
Barite | Level 11

CITY prompt would be dependent on COUNTRY prompt.  COUNTRY prompt would be dependent on CONTINET prompt.

And thats how it is cascading prompt.

 

The list of city would be populated based on country. 

 

Suppose for sometime I think city prompt is dependent on continent prompt, then in that case all the cities of the continent would be fetched instead it should fetch cities of the chosen country only. That's why city prompt should be dependent on COUNTRY prompt.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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