I forgot to include a few important details about the type of prompt that I'm using which may complicate using the advanced filter option part of the Query Builder. I'm using a prompt type that allows for multiple values to be entered. Then I'm currently using that prompt in a basic filter where the operator is set to "In a list". As far as I can tell, the basic filter doesn't allow for specifying a SAS function, such as upcase. So, is there a way to use the advanced filter that you're suggesting with a prompt type that allows for multiple values and accomplish the same filter operation as the "In a list" operator in conjunction with the upcase function?
... View more