i have two section filters using text boxes defined as parameters
i have defined a filter using the parameter.
(comment contains 'parameter1'p OR comment contains 'parameter2'p)
the issue is is parameter2 is not coded it seems to select all records from the lasr table anyway because it seems it is selecting all comments that have a blank. i only want to select records based on a valid entry in the parameter text box.
You need to identify if parameter2 is missing or not and depending on this execute an expression, see below as example I use UpCase (can also Lowcase) to prevent any mismatching due to upper or lower case used in text(search)field.
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.