Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Empty rows/columns in crosstabs

Reply
Occasional Contributor
Posts: 15

Empty rows/columns in crosstabs

Hi all,

 

New to the forums and VA so apologies if this is the incorrect place. I'm currently learning the ropes of crosstabs in VA (Version 7.3) to see whether it's an appropriate product for our company. Whenever I create a crosstab and assign variables to the rows and columns, I notice that there's an extra column on the right-hand side of the table, which serves no purpose other than to occupy unnecessary space. Is there any straightforward way of removing it?

 

I've tried resizing the table in 'precision' mode, which only appears to hide the column on the canvas in the Designer. The empty column is still there when the report is viewed in the Viewer. Resizing the table also appears to change the dimensions of the entire table, when I'm only interested in hiding this final column. It is more effective in hiding the superfluous empty rows at the bottom of the table, but ideally I'm after a 'resize to contents' option such that the width and height of the table will be determined by the number of rows and columns populated by the data.

 

All responses appreciated!

SAS Super FREQ
Posts: 586

Re: Empty rows/columns in crosstabs

Unfortunately, you cannot remove the empty columns, which are there to serve as a 'drop area' for additional data items while in design mode. We have had requests to remove the empty columns in viewer mode, since they are not needed there. I would suggest that you use the SASWare Ballot to enter this request as well. This will enable other users to vote on the idea.

https://communities.sas.com/t5/SASware-Ballot-Ideas/idb-p/sas_ideas

 

Occasional Contributor
Posts: 15

Re: Empty rows/columns in crosstabs

Posted in reply to Madelyn_SAS

Thanks for the response Madelyn. Seems like a strange oversight, but if there have been previous requests then I imagine it's unlikely that mine would make any difference.

 

Since my employer intends to produce mostly crosstabs I will inform them that VA may not be the most appropriate product available. Thanks again.

Occasional Contributor
Posts: 7

Re: Empty rows/columns in crosstabs

Hello All,

 

You can not remove extra space in crosstab as well as List table. I am facing same problem in sas visual analytics.

 

I hope may be it will be available in future version 8.1

Regular Learner
Posts: 1

Re: Empty rows/columns in crosstabs

Posted in reply to Jayendra_Vainsh

This is so frustrating. My end users think I'm lying when I tell them we cant remove that extra column. It's really embarrassing.

Super User
Posts: 4,023

Re: Empty rows/columns in crosstabs

Posted in reply to Ray_Temple

Show them this post which contains the answer from @Madelyn_SAS a SAS employee.

Contributor
Posts: 40

Re: Empty rows/columns in crosstabs

[ Edited ]
Posted in reply to Jayendra_Vainsh

8.1? It would be a hotfix for every version sold to a customer...here we have a fresh install of VA 7.3 with a lot of problems.....It is embarrassing 

Occasional Contributor
Posts: 13

Re: Empty rows/columns in crosstabs

Hello,

 

I would like to know if this situation continues in the new 8.2 version or if it has been modified in order that we can exclude empty columns and rows of tables and crosstabs.

 

Thank you.

Occasional Contributor
Posts: 13

Re: Empty rows/columns in crosstabs

Posted in reply to alineagostini

I am waiting to try 8.2 version but I think I found a partial answer to my question in the documentation: 

 

http://go.documentation.sas.com/?docsetId=vawn&docsetTarget=n1nd2mj97fpzkrn16lznyx2pw7b5.htm&docsetV...

 

"By default, the columns in list tables are automatically sized based on the space available".

 

It refers only to columns but it could be a good improvement.

Could anyone kindly provide a feedback on how it works in the new version?

 

Thank you!

 

Occasional Contributor
Posts: 13

Re: Empty rows/columns in crosstabs

Posted in reply to alineagostini

Well, while I can't get the 8.2 version available at my job, I got a personal trial version to solve my doubts and here it is:

 

I created a simple table, added some sample data and resized the table. As a result, the columns were automatically adjusted to the new size of the table (image 1). I know that is simple but I find it is a good improvement compared to 7.3 version.

 

 For the rows, I can adjust the size as well but a scroll bar will always be created if the table is smaller than your data which cannot be considered a problem once data may change according to filters, etc. (image 2).

 

Congrats to all the SAS team for this and also other improvements in the new version!

 

test_82_1.PNGtest_82_2.PNG

 

Ask a Question
Discussion stats
  • 9 replies
  • 1509 views
  • 3 likes
  • 7 in conversation