topic how to see full column name in eg 7 12 in SAS Enterprise Guide

how to see full column name in eg 7 12

ak2 — Mon, 19 Sep 2016 07:45:31 GMT

Hi! In eg 7 12, the columns in the 'Output Data' tab do not display all the text in the column headers. I have some tables with very long column names (and many columns), and in order to see the name of the column I need to hover above the column name. Or I can click and drag to make the width of the column bigger sutch that I can read the name.

I tried tools->options->data->performance-> The width for character based columns should be: set to 255 bytes. Didn't help.

In the version we had before that, this was not a problem. Can anyone please help me with this?

Re: how to see full column name in eg 7 12

Damo — Thu, 05 Jan 2017 12:35:58 GMT

Hi ak2,

Not sure if you are still looking for an answer, but here is one.

1st, you talked about the Tools->options->data->performance-> The width for character based columns should be option

This is actually not relevant to the column width, as per the doc (see below).

Setting data schema options

- The longest value found within the data - sets the column width to the actual maximum column width of the longest data value when you read a data file that is used to create a SAS data set. If you do not select this option, the default column width is set to 255 bytes. This option affects how Microsoft Excel, HTML, and text files are saved to a SAS data set. This option does not affect how data is displayed in the data grid.

If you want to control the column width, you can select multiple columns in the data grid and click Edit->Columns->Width.

You have to specify a pixel value.

Unfortunately, these settings do not stick when you close and reopen the table.

Sorry to be the bearer of bad news.

Cheers,

Damo

Re: how to see full column name in eg 7 12

ak2 — Thu, 05 Jan 2017 13:03:46 GMT

Hi!

I knew about the trix you suggested, and I guess my problem lies out of our reach. I think we'll just close the case.

Thank you for replying.

Re: how to see full column name in eg 7 12

Haris — Thu, 02 Mar 2017 22:19:40 GMT

It would be nice if SAS could add an option for the user to control the default column width in the data viewer. The current default is too narrow in my opinion.

Even better, make it work like Excel: when you highlight multiple columns and double-click on the horizontal double-ended arrow in the column headers, each column snaps to the widest entry in that column! NICE!