06-12-2016 03:36 PM - last edited on 06-13-2016 10:52 AM by ShelleySessoms
Suppose I am a SAS stored process developed and I am creating cascade three prompts in Stored Process.
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.
06-12-2016 11:22 PM - edited 06-12-2016 11:27 PM
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.