I have a Category named "Gender" with two values: "M - Male" and "F - Female". I have this Category in a List object. The List object on the current page is Linked to an Info Window. On the Info Window I want to have a Button that shows what was selected on the previous page, as follows (three optoins):
1) "M-Male"
2) "F-Female"
3) "Both"
I created a New Calcuated Item, and attempted to use the following:
if 'Gender'n = 'M - Male' and 'Gender'n = 'F - Female'
return 'Both Selected'
else 'Gender'n
However the 'logic' of the if clause is never true, so I always get 'Gender'n value returned.
Anyone have a way around this? The 'Gender'n field is retaing both the male and female values, but I don't know how to get the logic to work in the If clause.
On version 7.3 Hotfix 04
Thanks.
I don't know if you are familiar with parameters but you need to create a parameter in order to do that and olace it to button under roles.
The parameter should be on the button not the list box in the info window
Got it. So I did that, but I still have no way to assign "Both" as an option. I don't want it to display male and female, when neither box is selected in the list box ( or both boxes are selected in the list box) I want the button to display "Both Selected".
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.