BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
LukeL
Obsidian | Level 7

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 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
Konu-Tec
Obsidian | Level 7

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

View solution in original post

5 REPLIES 5
Konu-Tec
Obsidian | Level 7

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
SAS Employee
Yes, a calculated item is the way to go.
LukeL
Obsidian | Level 7
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
Obsidian | Level 7
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
SAS Employee

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

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 5 replies
  • 1357 views
  • 5 likes
  • 4 in conversation