Prev: Scroll to a particular column in viewtable
Next: SAS Date and Tiem format
From: Scott Bass on 2 Mar 2010 21:40
On Tue, 2 Mar 2010 21:38:00 -0500, Scott Bass <sas_l_739(a)YAHOO.COM.AU> wrote:

>Hi,
>
>SAS 9.1.3, DMS, Windows XP
>
>Perhaps this is in the doc and I just can't find it. Hopefully the
>functionality is there...
>
>1) I miss the "=<varname>" command from fsview. Is there a way to
>horizontally scroll to a known column name using viewtable?
>
>2) I clicked on "Form View" in viewtable to view the table ala fsedit. I
>got a horizontal scrollbar, but no vertical scrollbar to see the rest of the
>variables in my wide dataset. Certainly there's a way to see all your
>variables when in form view?
>
>Regards,
>Scott

Re: #2...never mind, it's the little "turn page icons" in the upper right
and left corners of the screen.
From: montura on 3 Mar 2010 10:36
You can also set the HELDCOLUMNS so that column will always be visible
regardless of scrolling.

From: Randy Herbison on 3 Mar 2010 16:44
Off-the-shelf, VIEWTABLE doesn't have an equivalent command to go directly to a variable by name.

To scroll to another page of the form, you can:
1. Click on the earmarks at the top left/right of the form
2. Issue the PAGENAVIGATOR command to turn on the page navigator controls.

If you can compile SCL, you can create a custom VIEWTABLE command to go directly to a variable.

-Randy

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L(a)LISTSERV.UGA.EDU] On Behalf Of Scott Bass
Sent: Tuesday, March 02, 2010 9:41 PM
To: SAS-L(a)LISTSERV.UGA.EDU
Subject: Re: Scroll to a particular column in viewtable

On Tue, 2 Mar 2010 21:38:00 -0500, Scott Bass <sas_l_739(a)YAHOO.COM.AU> wrote:

>Hi,
>
>SAS 9.1.3, DMS, Windows XP
>
>Perhaps this is in the doc and I just can't find it. Hopefully the
>functionality is there...
>
>1) I miss the "=<varname>" command from fsview. Is there a way to
>horizontally scroll to a known column name using viewtable?
>
>2) I clicked on "Form View" in viewtable to view the table ala fsedit. I
>got a horizontal scrollbar, but no vertical scrollbar to see the rest of the
>variables in my wide dataset. Certainly there's a way to see all your
>variables when in form view?
>
>Regards,
>Scott

Re: #2...never mind, it's the little "turn page icons" in the upper right
and left corners of the screen.
From: Scott Bass on 3 Mar 2010 17:34
Thanks Randy. We don't have SAS/AF licensed, so compiling SCL is not an
option. If we had SAS/FSP licensed, I would use fsview instead, just for
the =varname command. Some of our datasets are quite wide, and it's very
time consuming finding the desired variable.

viewtable has been around "forever". It's disappointing SAS would leave out
such basic functionality (horizontal scrolling to variable name) OOTB.
 | 
Pages: 1
Prev: Scroll to a particular column in viewtable
Next: SAS Date and Tiem format