Let user choose table columns in viewer

[LukeL]

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 🙂

[Konu-Tec · Accepted solution]

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

[Sam_SAS]

Yes, a calculated item is the way to go.

[LukeL]

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... 🙂

[Konu-Tec]

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 : )

[dyeung]

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