DATA Step, Macro, Functions and more

Variable Label Displayed in Data Set

Reply
Regular Contributor
Posts: 184

Variable Label Displayed in Data Set

I am labeling variables with LABEL statement. It labels correctly but it is not shown in the data set.

What i mean - The variable label should be dispayed instead of variable name when i open data set.

Can both be displayed when someone point cursor on the variable? I am using SAS EG5.1.

Occasional Contributor
Posts: 9

Re: Variable Label Displayed in Data Set

In EG and Base SAS you can only have either the column name or the label displayed, you cannot have both. To see both, right-click on the table in the library, Properties, Columns. There you scroll right, and the labels would be shown on each column.

To change the settings to show labels instead of column names do this: Find Tools on the menu bar, then Options, look at the drop down screen.

Locate on the left Data,  Data General. Toward the middle,  Naming Options: check the box for  "Use labels for column names"

This is in SAS EG 6.1. Look for similar settings in 5.1, it should not be very different.

Regular Contributor
Posts: 184

Re: Variable Label Displayed in Data Set

Is it possible via code to show labels instead of column names? Not all variables have variable label. Only selected variables have variable labels. I want to display variable label of these selected variables.

Occasional Contributor
Posts: 9

Re: Variable Label Displayed in Data Set

You may want to play with the options listed here,

How to View DICTIONARY Tables

also ask SAS Tech support for help.

http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#p00cato8pe46ein1bjci...

Super User
Posts: 3,260

Re: Variable Label Displayed in Data Set

In EG, from the Tools menu, select options, then Data, then tick the box for "Use labels for column names". If you hover over the column heading it will tell you what the variable name is. If the variable does not have a label the variable name is shown instead.

There is no way to switch this on in code.

Ask a Question
Discussion stats
  • 4 replies
  • 3840 views
  • 0 likes
  • 3 in conversation