topic Re: explorer window - finding variables in SAS Procedures

explorer window - finding variables

deleted_user — Wed, 11 Nov 2009 11:07:20 GMT

I didn't really know which forum to put this in. This is certainly the wrong one but I can't see a better one.

If I open a sas dataset in explorer I want to be able to move to the variable I am looking for instead of scrolling through. (I have hundreds of variables.)

Re: explorer window - finding variables

sbb — Wed, 11 Nov 2009 14:05:56 GMT

Unfortunately, it appears that SAS VIEWTABLE UI has no "FIND" command equivalent and when Ctrl-F (FIND command keystroke) is entered, the WHERE filter window is displayed, instead.

Scott Barry
SBBWorks, Inc.

Re: explorer window - finding variables

Peter_C — Wed, 11 Nov 2009 14:29:07 GMT

There were a lot of conveniences in the old SAS/FSP product viewers FSView and FSEdit, including the command
=variableName
which took the display to the named variable.
Without that in ViewTable, you're unlucky.

Try the hide/Unhide option on the ViewTable Data menu
It might help you to reduce the list of columns to something manageable.

good luck
PeterC

Re: explorer window - finding variables

Flip — Wed, 11 Nov 2009 14:31:31 GMT

In UNIX the FSView window supports the Move function which displays that column. This is one of the reasons I have rearranged the order of columns in a dataset. If they are alphabetical, they are easier to find.