Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Concatinate category with custom parameter SAS VA

Accepted Solution Solved
Reply
Contributor
Posts: 71
Accepted Solution

Concatinate category with custom parameter SAS VA

Hi Community,

 

I've a Category with values(AS,NA,EU,OC,SA,EF,AF)

I would like use the "Button Bar" to pass input values with values under

label "Mine"="AS",

"All"="AS,NA,EU,OC,SA,EF,AF"

 

but I'm getting it as "Mine"="AF" and "All" ="AS,NA,EU,OC,SA,EF"

 

how can i add "AF" to "All" label refer the Image attached.

 

Kind Regards

Balraj

Attachment

Accepted Solutions
Solution
‎04-02-2016 09:16 AM
Super User
Posts: 1,202

Re: Concatinate category with custom parameter SAS VA

Hi Balraj,

 

I think to achieve what you are after you need to have 2 new data items for 2 button bar objects. Create one as a label with All that has all the categories and create another with just AF by using an expression. Then use the each data items as the underlying data for a button bar object in the report.

 

Kind Regards,

Michelle

View solution in original post


All Replies
Super User
Posts: 1,202

Re: Concatinate category with custom parameter SAS VA

Hi Balraj,

 

To understand your question correctly, you want to include the "AF" category in both labels, Mine and All? A category can only be in one group. Essentially being "AF" and all other category values, mutually exclusive.

 

Kind Regards,

Michelle

Contributor
Posts: 71

Re: Concatinate category with custom parameter SAS VA

Hi Michelle,

 

You understood it correctly. If that is the case how can I Implement it. Is there any work around for doing it.

 

Kind Regards

Balraj

Solution
‎04-02-2016 09:16 AM
Super User
Posts: 1,202

Re: Concatinate category with custom parameter SAS VA

Hi Balraj,

 

I think to achieve what you are after you need to have 2 new data items for 2 button bar objects. Create one as a label with All that has all the categories and create another with just AF by using an expression. Then use the each data items as the underlying data for a button bar object in the report.

 

Kind Regards,

Michelle

Post a Question
Discussion Stats
  • 3 replies
  • 293 views
  • 0 likes
  • 2 in conversation