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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.