sas va prompt filter based on not operand

[rufmau68]

Hi,

im new in sas va 

i need to define a control filter based on the not operand

e.g.:

list all product NOT selected by user 

if the user select a product list, than prompt filter is based on equal operand, but i need to use it , with the not equal operand

it's possible ?

or can i find out any workaround ?

tnks

bye

mauro

[Madelyn_SAS · Accepted solution]

This appears to be the same question as another post. This is the response I gave for that one. 

If I understand what you are asking, I was able to do this by creating a filter on the target object like this: 

This is the text version 

( 'Type'n NotIn 'Type Multi-Select'p )

Where Type is the data item in my target object, and Type Multi-Select is a multi-select parameter that is assigned to the Parameter role for a List Control.