An Idea Exchange for SAS software and services

Comments
by Super User
on ‎06-30-2017 12:48 AM

Such a feature already exists. In the view do Ctrl - F to open the Search Dialog. Then change the search type to column headings only and type in the text you want to search on. You can enter just parts of variable names and it will quickly find the next column containing that text.

by Contributor DaveShea
‎07-07-2017 03:35 AM - edited ‎07-07-2017 03:38 AM

Hi Scott and SASKiwi,

 

I have an alternative suggestion to SASKiwi's Ctrl-F idea and that is the little used, Ctrl-G key combination to bring up the [Go To Cell] dialog box. Despite the dialog box title, it allows you to quickly navigate to a particular column by choosing the column from a drop-down list. I realise that Scott prefers not to have a big list, but this is just an alternative.

 

Within the [Go To Cell] dialog box, if you click on the [Column:] drop-down control you get a list of all the variables/columns and you can choose the one you want to navigate to from the list.

 

This is very useful when you have a very large number of columns in a dataset, however, I would LOVE there to be a tick-box/radio-button to alter the order in which the columns appear in the drop-down list from the current dataset varnum order to alphabetical order.

 

The only real current downside to the facility is that in later releases of SAS Enterprise Guide the Freeze Panes facility got taken away. I sincerely hope that is re-instated so that key columns can be held in place at the left hand side whilst the user scrolls to columns far, far, away to the right.

 

On the whole, though, I agree with Scott, I think that there is room for a mini-command line in SAS Enterprise Guide Data Grid to allow for navigation. Perhaps re-combining what is now there as a Where clause command line with other commands would be a good step.

 

Cheers,

 

Downunder Dave.

Idea Statuses
Top Liked Authors