topic Re: How do I hide (or select columns to view) in the data grid? in SAS Enterprise Guide

How do I hide (or select columns to view) in the data grid?

kschott — Fri, 07 Apr 2023 16:14:42 GMT

Hi EG community,

I'm using EG 8.3 (and am new to EG) and don't see how I can hide a column when viewing a data set. It seems like I should be able to right click and see a "hide" option. I can move columns just fine, but not hide. Is this an option I have to set somewhere in tools/options? I've looked through section 6 of the 8.3 user's guide and also searched it for "hide", but no luck.

Thank you for your help!

Kevin

Re: How do I hide (or select columns to view) in the data grid?

vijaypratap0195 — Fri, 21 Apr 2023 18:36:50 GMT

To hide or select columns to view in the SAS data grid, you can use the following steps:

Open the SAS data grid that contains the columns you want to hide or view.
Right-click on the column header that you want to hide or view.
In the context menu that appears, select "Column Control."
In the Column Control dialog box, you can use the checkboxes to hide or show specific columns, or you can use the "Select All" checkbox to toggle all columns.
Click "OK" to apply your changes.

Alternatively, you can also use the "Columns" option in the SAS data grid's main menu to manage the visibility of columns. Select the "Columns" option and then select "Column Control" to open the same dialog box mentioned above.

Re: How do I hide (or select columns to view) in the data grid?

kschott — Fri, 21 Apr 2023 18:56:51 GMT

Thank you @vijaypratap0195 -- yes, it seems like it should be as straightforward as a right click, but I don't have the option you describe:

Re: How do I hide (or select columns to view) in the data grid?

mtnbikerjoshua — Fri, 21 Apr 2023 19:36:57 GMT

Hi @kschott,

One way you can do this is by clicking the "Filter and Sort" button at the top of the data grid and selecting the columns you want to see. It is not as easy as a right click, but it does the job.

Best,

Joshua

Re: How do I hide (or select columns to view) in the data grid?

kschott — Mon, 24 Apr 2023 12:55:40 GMT

Thank you Joshua @mtnbikerjoshua . If only I had that option....

Am I missing enabling these setting in my "options"? I looked, no luck. But again, new to EG.

Roadie and gravel here - maybe that's my problem 😆

-Kevin

Re: How do I hide (or select columns to view) in the data grid?

PopCorn14 — Mon, 24 Apr 2023 14:11:23 GMT

Hi @kschott,
I know what you mean. It used to be so easy with SAS EG 7.X to hide a column.
You do have the option "Filter and Sort". It is not as obvious as before. On your picture, you can see the "Tasks" between QueryBuilder and Share. Just click Tasks and you should be able to view that specific option.

Re: How do I hide (or select columns to view) in the data grid?

kschott — Mon, 24 Apr 2023 14:33:02 GMT

Thanks @PopCorn14 and all for trying to help me with this seemingly super straightforward problem. Alas,

This has got to be a problem with how my account was setup, or the EG installation, or permissions, or .....?

If it turns out I really am just not seeing how to do it and it IS right there, I'm going to change my SAS communities name 😆.

-K

Re: How do I hide (or select columns to view) in the data grid?

fja — Tue, 25 Apr 2023 15:32:24 GMT

I do not like the new appearance in EG 8.x either

Re: How do I hide (or select columns to view) in the data grid?

jebjur — Tue, 25 Apr 2023 19:32:00 GMT

Kevin,

There is a configuration option you can set in the appSettings section of the SEGuide.exe.config file (found in the Eguide installation folder) called 'EnableDataGridHideHold' that if set to True, will enable the menu items Hide and Hold on the Data Grid columns for a data set. See if that might work for you.

Re: How do I hide (or select columns to view) in the data grid?

SASKiwi — Tue, 25 Apr 2023 21:34:18 GMT

@jebjur - Works for me in EG 8.3! Great to see this functionality back!

Re: How do I hide (or select columns to view) in the data grid?

PopCorn14 — Wed, 26 Apr 2023 20:18:33 GMT

Merci beaucoup @jebjur. This is GREAT news. It worked for me too now on SAS EG 8.3. However, I had to ask the SAS adminstrator to do it for me. It is SO MUCH FASTER this way.

Re: How do I hide (or select columns to view) in the data grid?

kschott — Wed, 26 Apr 2023 20:23:46 GMT

Thanks @jebjur -- I won't be in a position to test it for a while, but from the experiences of @PopCorn14 and @SASKiwi, I'm sure it will work for me!

Re: How do I hide (or select columns to view) in the data grid?

SASKiwi — Wed, 26 Apr 2023 21:10:18 GMT

@jebjur , @kschott - Now waiting for the "freeze column" feature to be added back in too!