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
2. Where are you defining this advanced filter (object, data source filter, other)?
3. What are you trying to accmoplish with this filter?
4. Would you be able to provide a small sample of your data?
Special offer for SAS Communities members
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.