Math Forum / Math Software / SAS / August 2007

John,

Here's what I do:

1) Click in or on the Explorer pane to highlight the the Explorer
window.
2) In the Menu, select Tools -> Options -> Explorer
3) Select the Members Tab
4) Double click on the TABLE icon
5) Double click on the &Open action
6) Set the Action command to:  VIEWTABLE %8b.'%s'.DATA COLHEADING =
NAME
7) Click on the Set Default button

Hope that helps,

Brian

John,

You can make column names display automatically when you view a SAS
table in the Display Manager environment.

The SAS table viewer, VIEWTABLE, supports invocation command arguments.
Use COLHEADING=NAMES to display column names as column headings:

VT SASHELP.CLASS COLHEADING=NAMES

If you would like the SAS Explorer to use the COLHEADING argument, you
can customize the SAS Explorer action command that runs VIEWTABLE:

1. Make the SAS Explorer active and select Tools->Options->Explorer
2. On the Explorer Options window, select Members->Table->Edit
3. Edit the "Open" action command:  VIEWTABLE %8b.'%s'.DATA
COLHEADING=NAMES
4. Save changes and close the Explorer Options window.

-Randy
-----Original Message-----
From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
On Behalf Of John Uebersax
Sent: Wednesday, August 22, 2007 9:47 AM
To: sas-l@uga.edu
Subject: Display Manager -- show Column Names (not Labels) by default?

It seems that, by default, when the SAS display manager views a SAS
dataset it shows Column Labels instead of Column Names.  Is there a way
to get Column Names to appear by default.  (It gets old continually
navigating through the command menu (alt-View/Column
Names) to change this!)

Alternatively (though this isn't as good a solution), is there a way to
set a shortcut key for this?

Thanks in advance.
--
John Uebersax

For Version 8.2

*   Click on the Explorer Window to activate it
*   Select Tools/Options/Explorer
*   Double-Click "Table" under Type
*   Double-Click "&Open" under Action
*   Under "Action command" the following text should appear "VIEWTABLE
%8b.'%s'.DATA"
*   Add the following text to the end "COLHEADING=NAMES" so that the
entry now appears as "VIEWTABLE %8b.'%s'.DATA COLHEADING=NAMES"
*   Click OK until you are back into your SAS session

For Version 9.1.3
*   Click on the Explorer Window to activate it
*   Select Tools/Options/Explorer
*   Click on the "Members" tab
*   Double-Click "Table" under Type
*   Double-Click "&Open" under Action
*   Under "Action command" the following text should appear "VIEWTABLE
%8b.'%s'.DATA"
*   Add the following text to the end "COLHEADING=NAMES" so that the
entry now appears as "VIEWTABLE %8b.'%s'.DATA COLHEADING=NAMES"
*   Click OK until you are back into your SAS session

If you want to revert to column labels as the default simply delete
the "COLHEADING=NAMES" text that you added above.

Regards,

Tony