Desktop productivity for business analysts and programmers

how to see full column name in eg 7 12

Accepted Solution Solved
Reply
Contributor ak2
Contributor
Posts: 27
Accepted Solution

how to see full column name in eg 7 12

 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? 

 


Accepted Solutions
Solution
‎01-05-2017 08:04 AM
SAS Employee
Posts: 68

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

[ Edited ]

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

View solution in original post


All Replies
Solution
‎01-05-2017 08:04 AM
SAS Employee
Posts: 68

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

[ Edited ]

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

Contributor ak2
Contributor
Posts: 27

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

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.

Frequent Contributor
Posts: 102

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

[ Edited ]

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!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 437 views
  • 0 likes
  • 3 in conversation