topic Re: Use column name instead of column label as header in VA list table in SAS Visual Analytics

Use column name instead of column label as header in VA list table

peter_gerngross — Wed, 14 Jul 2021 11:26:28 GMT

Hi,

I created a list table in VA. By default, the column label of the data source is displayed as the column header in the report. I need to display the "name in data source" as column header. Is there an easy way to do this without changing the label in the data source?

Thanks

Peter

Re: Use column name instead of column label as header in VA list table

Sam_SAS — Wed, 14 Jul 2021 13:14:41 GMT

Hello Peter,

I don't think there's an easy way to show the column name instead of the label. Can you tell us more about why you need to display the column name?

Thanks,

Sam

Re: Use column name instead of column label as header in VA list table

peter_gerngross — Wed, 14 Jul 2021 16:17:03 GMT

Hi Sam,

the report is designed to provide a table which can be downloaded by our users, who will use it to do further analyses. For this, the column headers must be the variable names (as opposed to variable labels).

The same data source is used for other reports which need the (more descriptive) labels. Therefore we can not simply change the labels in the data source.

Our current work-around is to add a new calculated item which is a copy of the original item.

Kind regards

Peter

Re: Use column name instead of column label as header in VA list table

Sam_SAS — Wed, 14 Jul 2021 17:14:44 GMT

I was going to suggest creating duplicates of each column and renaming those. Making calculated items is basically the same thing but a little bit more work.

If you go to this link:

https://communities.sas.com/t5/SASware-Ballot-Ideas/idb-p/sas_ideas/label-name/sas%20visual%20analytics

You can submit a feature suggestion for this (an option for list tables to display column names instead of their labels). The feature suggestions are evaluated by the project management team, so they are very useful to us.

Thanks,

Sam