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 🙂
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
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
Can we have use a parameter to define which column to be used in the VA report.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.