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
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.
<appSettings>
<add key="EnableDataGridHideHold" value="true" />
</appSettings>
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.
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:
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
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
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
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.
<appSettings>
<add key="EnableDataGridHideHold" value="true" />
</appSettings>
@jebjur - Works for me in EG 8.3! Great to see this functionality back!
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.
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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.