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.
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.
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.
You may want to play with the options listed here,
also ask SAS Tech support for help.
what would be the settings for sas version 9?
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.