HI
Can anyone help me on working with dependency on filters in section prompt
i have city and location filters placed in section prompt
where if i select city , location has to be mapped .with the respective city .
anyone can help on creating the dependency of filters both placing on section prompt.
regards
Hello Soman,
Create Character Parameter.
assign the parameter to Dropdownlist1 (city).
for fDropdown list 2 (location) you have to put conditional filter (Which is on Right Handed side Pane FILTERS).
IF ( 'City'n Contains 'City..'p )
RETURN ( 'location'n = 'location'n )
ELSE ( 'location'n Missing )
Or
IF ( 'City'n Contains 'City..'p )
RETURN ( 'location'n NotMissing )
ELSE ( 'location'n Missing ).
Let me know......
Thanks & Regards,
Teja Surapaneni
Hello Soman,
Create Character Parameter.
assign the parameter to Dropdownlist1 (city).
for fDropdown list 2 (location) you have to put conditional filter (Which is on Right Handed side Pane FILTERS).
IF ( 'City'n Contains 'City..'p )
RETURN ( 'location'n = 'location'n )
ELSE ( 'location'n Missing )
Or
IF ( 'City'n Contains 'City..'p )
RETURN ( 'location'n NotMissing )
ELSE ( 'location'n Missing ).
Let me know......
Thanks & Regards,
Teja Surapaneni
HI Teja ,
Thank your for the solution , its working out ...
regards
Soman
SomanDavuluri, I'm glad you found some useful info! If Teja's reply was the exact solution to your problem, can you "Accept it as a solution"? Or if it was particularly helpful, feel free to "Like" it. This will help other community members who may run into the same issue know what worked.
Thanks!
Anna
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.