topic Re: Let user choose table columns in viewer in SAS Visual Analytics

Let user choose table columns in viewer

LukeL — Thu, 16 Jul 2020 13:58:18 GMT

Hi all,

I'm new with SAS VA 7.5/8.x, and would like to ask if there is now a way to let a user choose which columns must appear in a table object, in the viewer port. Is this feasible in some way, or the only way is to give the user the editor ability?

Thanks 🙂

Re: Let user choose table columns in viewer

Konu-Tec — Fri, 19 Mar 2021 16:59:58 GMT

I believe you need Parameters, Calculated Items, and some Controls to populate values of Parameters

[Calculated Item 1]

IF ('parameter 1'p = 'Column name 1')

RETURN 'COLUMNNAME1'n

ELSE

IF ('parameter 1'p = 'Column name 2')

RETURN 'COLUMNNAME2'n

ELSE.

.
.

IF ('parameter 1'p = 'Column name N')

RETURN 'COLUMNNAMEN'n

[Calculated Item 2]

IF ('parameter 2'p = 'Column name 1')

RETURN 'COLUMNNAME1'n

ELSE

IF ('parameter 2'p = 'Column name 2')

RETURN 'COLUMNNAME2'n

ELSE.

.
.

IF ('parameter 2'p = 'Column name N')

RETURN 'COLUMNNAMEN'n

Fill each one of Controls with a Table of size 1xnames_of_columns_to_choose_from (in other words a variable made out of all column names)

Hope it helps

Konrad

Re: Let user choose table columns in viewer

Sam_SAS — Tue, 21 Jul 2020 20:15:54 GMT

Yes, a calculated item is the way to go.

Re: Let user choose table columns in viewer

LukeL — Thu, 23 Jul 2020 07:38:54 GMT

Thanks Konu, nice one. It work really good. Pity for the output table names no representing what the data are, but I think it's a drawback we could live with... 🙂

Re: Let user choose table columns in viewer

Konu-Tec — Thu, 23 Jul 2020 07:46:37 GMT

It is really cool it worked for you
To be honest I have recently bump up on that solution by an accident. So I was happy to share the idea to make also a note for myself here : )

Re: Let user choose table columns in viewer

dyeung — Wed, 12 Apr 2023 02:39:33 GMT

Can we have use a parameter to define which column to be used in the VA report.