Randy,

Thanks, you are correct, I see the distinction now.

Kind regards ------------ Paul Dorfman Jax, FL ------------

-------------- Original message ---------------------- From: "Randy Herbison" <RandyHerbison@westat.com> > > Paul, > > This thread has become a little confusing, because TJ's question doesn't > exactly match the subject line. He asked about data set, as opposed to > column, labels. > > I don't think there is much a VIEWTABLE end user can do about data set > labels. > > A SAS/AFer could add some SCL to make VIEWTABLE always/on demand display > data set names instead of data set labels. > > -Randy > > > > -----Original Message----- > From: Paul Dorfman [mailto:sashole@BELLSOUTH.NET] > Sent: Thursday, October 04, 2007 4:18 PM > To: SAS-L@LISTSERV.UGA.EDU; Randy Herbison > Subject: Re: Display manager: show column names instead of labels? > > > Randy, > > There is at least one tool described by Venky Chakravarthy in his > excellent paper about the viewtable window: > > http://www2.sas.com/proceedings/sugi31/255-31.pdf > > I have tested it; works like a charm, and now I have it always set to > avoid seeing silly labels. It I need to see one, I revert to them via > View->Column labels. > > Kind regards > ------------ > Paul Dorfman > Jax, FL > ------------ > > On Thu, 4 Oct 2007 14:36:56 -0400, Randy Herbison > <RandyHerbison@WESTAT.COM> > wrote: > > >I don't think there are end user tools available to make VT display the > > >table name when the table has a label. You can use a data set option > >to change or hide (most) label text, but that alone doesn't cause the > >table name to display. > > > >A SAS/AF programmer could modify VT to not display table labels. > > > >-Randy > > > >-----Original Message----- > >From: owner-sas-l@listserv.uga.edu > >[mailto:owner-sas-l@listserv.uga.edu] > >On Behalf Of T J > >Sent: Thursday, October 04, 2007 2:16 PM > >To: SAS-L@LISTSERV.UGA.EDU; Randy Herbison > >Subject: Re: Display manager: show column names instead of labels? > > > > > >On a related topic, how can I display the table name in stead of the > >label of the table/dataset? How did I get the labels in the first > >place? By default, some SAS PROCs produce output tables/datasets with > >some silly labels. > > > >For example: > > > >data a; do i = 1 to 5 ; output; end; run; > >proc freq data=a noprint ; table i /list out=out1 ; run; > > > >====> viewtable out1 > > > >In the header line, it will say: > > SAS: VIEWTABLE: Frequency counts and Percentages > > > >instead of: > > SAS: VIEWTABLE: OUT1 > > > > > > > >Thanks, > > > >-TJ > > > > > > > > > >On Thu, 4 Oct 2007 12:31:44 -0400, Randy Herbison > ><RandyHerbison@WESTAT.COM> wrote: > > > >>John, > >> > >>Drop the forward slash on the VT command: > >> > >>vt libname.table colheading=names > >> > >>You can use macro for both the SAS Explorer action command and the > >>Display Manager command. > >> > >>%macro myVT; > >>viewtable colheading=names open= > >>%mend myVT; > >> > >>DMS command: %myVT libname.table > >> > >>You can create a command style macro (and loose the %), but then you > >>would need to set the CMDMAC option. > >> > >>-Randy > >> > >>-----Original Message----- > >>From: owner-sas-l@listserv.uga.edu > >>[mailto:owner-sas-l@listserv.uga.edu] > >>On Behalf Of John Uebersax > >>Sent: Thursday, October 04, 2007 9:34 AM > >>To: sas-l@uga.edu > >>Subject: Re: Display manager: show column names instead of labels? > >> > >> > >>Still having problems getting DM to display tables with variable > >>names, > > > >>not labels, as column headings. > >> > >>Using previous suggestions, I've configured things so that if I click > >>on a dataset, it displays the dataset with variable name column > >>headings. > >> > >>But if, instead, I just type "vt <dsname>'" in the command window, it > >>displays the dataset with variable label column headings. > >> > >>Experimenting, I found that typing "vt <dsname> / colheading=name" in > >>the command window displays the dataset with variable names as > >>headings. However, the system also beeps and gives the error message: > >> > >>ERROR: Unrecognized command or argument " " > >> > >>Does anyone have any suggestions? > >> > >>Thanks in advance. > >> > >>John Uebersax > >>Brussels