topic Re: Concatinate category with custom parameter SAS VA in SAS Visual Analytics

Concatinate category with custom parameter SAS VA

balraj — Sat, 02 Apr 2016 11:19:32 GMT

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

Re: Concatinate category with custom parameter SAS VA

MichelleHomes — Sat, 02 Apr 2016 12:17:30 GMT

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

Re: Concatinate category with custom parameter SAS VA

balraj — Sat, 02 Apr 2016 12:37:22 GMT

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

Re: Concatinate category with custom parameter SAS VA

MichelleHomes — Sat, 02 Apr 2016 12:52:00 GMT

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