When i am working on SAS viya visual analytics , i got the unexpecting IF error while creating advance filter . below is the query ( i am using LTS 2024.03 version of sas viya) IF ((('LOANPARAM'p IsSet) OR ('CCCParam'p IsSet) OR ('UCICParam'p IsSet) OR ('CustNameParam'p IsSet)) RETURN (('Loan Account No'n)Contains('LOANPARAM'p))and (('Common Client Code'n)Contains('CCCParam'p)) AND ) ((UCIC)Contains('UCICParam'p))AND (('Customer Name'n)Contains('CustNameParam'p))) ELSE (true)
... View more