SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
vandhan
Fluorite | Level 6

Hi,

 

When I open any SAS dataset I see column/variable label by default. 

I would like to see by default variable/column names instead of lables of these variables.

Is there any way/option for this?

 

Please help.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

If you are looking at this in Base SAS you should have gotten to an Edit Action box that already has the Action as &Open in the first line that  cannot be edited and the second line under Action Command that likely has the default value of: VIEWTABL %8B."%S".DATA

 

If you do see those two boxes than type the instruction AFTER the word DATA.

 

If not you are somewhere else in the system. Did you click on the Action &Open in the TABLE Options dialogue box?

View solution in original post

8 REPLIES 8
fusima
Calcite | Level 5

Hi,


there is an option to do that since SAS 9.2.

options nolabel;


Hope this helps you.

vandhan
Fluorite | Level 6
Hi Fusima,
Thanks for your time for replying my question.

This nolabel option removes all labels of the dataset.
But, I need to have labels for dataset and I wanted to see variable names
by default when I open dataset.

Please help.

##- Please type your reply above this line. Simple formatting, no
attachments. -##
ballardw
Super User

In Base SAS:

Make SAS Explorer the active Window

From the menu bar select Tools>Options>Explorer

Go to the Members Tab and double click on Table

Select the &Open entry and click

Add the text: colheading=name

to the action command.

Close out of everything using the appropriate buttons.

vandhan
Fluorite | Level 6
Hi,

Thanks for you reply.

It is not going through. What should be in the "Action"??
Action : (what should i enter here)
Action Command : colheading=name



##- Please type your reply above this line. Simple formatting, no
attachments. -##
ballardw
Super User

If you are looking at this in Base SAS you should have gotten to an Edit Action box that already has the Action as &Open in the first line that  cannot be edited and the second line under Action Command that likely has the default value of: VIEWTABL %8B."%S".DATA

 

If you do see those two boxes than type the instruction AFTER the word DATA.

 

If not you are somewhere else in the system. Did you click on the Action &Open in the TABLE Options dialogue box?

vandhan
Fluorite | Level 6
Got it. Thanks for your time
evp000
Quartz | Level 8

Hello,

 

I have this option set to view column names.  If I open a data by navigating there with SAS explorer using a shortcut to the actual directory, and click on it, I see the labels in VIEWTABLE.  If I navigate to the same directory using the SAS library, I see the variable names.  Very weird.  Can it be changed so that I can see the variable names at all times?

 

Thanks.

sas-innovate-white.png

Special offer for SAS Communities members

Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 8 replies
  • 13528 views
  • 3 likes
  • 5 in conversation