BookmarkSubscribeRSS Feed
sushviper3
Calcite | Level 5

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)

1 REPLY 1
TSBruce
SAS Employee

A couple of questions on this:

1.  What error do you get with your expression?

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?

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 802 views
  • 0 likes
  • 2 in conversation