topic Re: add an empty column into a list table in SAS Visual Analytics

add an empty column into a list table

PaulTHR — Mon, 29 Mar 2021 13:47:50 GMT

Visual Analytics

Can anyone tell me how to add an empty column into a list table and give it a header 'Comments'.

Idea is when they export the table to excel it includes an empty column headed 'Comments' for the user to use on the spreadsheet version.

Thanks

ballardw — Mon, 29 Mar 2021 15:29:05 GMT

How are you creating the LIST table?

In Proc report add the column entry "comment" to the columns statment.

Define Comment as computed.

In the compute block assign a value like ' ';

SASKiwi — Mon, 29 Mar 2021 19:04:02 GMT

You can do this by adding a Calculated Item to the List Table data source.

PaulTHR — Tue, 30 Mar 2021 07:02:55 GMT

I am not using PROG this is Visual Analytics. Thanks

PaulTHR — Tue, 30 Mar 2021 07:04:00 GMT

Thanks - what do you put in the created item fields to make this happen? Thanks

Kurt_Bremser — Tue, 30 Mar 2021 09:56:30 GMT

I moved this to the Visual Analytics community.