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-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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