I have a report that contains data for many companies, and I would like to add filter on the company. So I added drop-down list to my report with company values and assigned CompanyParameter to this list.
Now, I would like to show only exact values, I mean do something like this:
if company = 'CompanyParameter'p then show only records for CompanyParameter
Unfortunately when building the filter, I can't find 'equality' operator, I can use for example "Contains":
if company Contains 'CompanParameter'p then show only records for CompanyParameter
And here comes the main issue. Let's assume that I have two companies: ABC and ABCD. Because I have 'contains' operator, then when I select ABCD company the records for ABC will be also presented (because 'ABCD' contains 'ABC').
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.