DATA Step, Macro, Functions and more

See default variable names rather than labels in SAS dataset

Accepted Solution Solved
Reply
Contributor
Posts: 36
Accepted Solution

See default variable names rather than labels in SAS dataset

[ Edited ]

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.

 

 


Accepted Solutions
Solution
‎09-21-2016 10:57 AM
Super User
Posts: 11,343

Re: See default variable names rather than labels in SAS dataset

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


All Replies
Regular Learner
Posts: 1

Re: See default variable names rather than labels in SAS dataset

[ Edited ]

Hi,


there is an option to do that since SAS 9.2.

options nolabel;


Hope this helps you.

Contributor
Posts: 36

Re: See default variable names rather than labels in SAS dataset

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. -##
Super User
Posts: 19,861

Re: See default variable names rather than labels in SAS dataset

Turn it on/off as needed? Not ideal...

 

http://support.sas.com/kb/14/973.html

Super User
Posts: 11,343

Re: See default variable names rather than labels in SAS dataset

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.

Contributor
Posts: 36

Re: See default variable names rather than labels in SAS dataset

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. -##
Solution
‎09-21-2016 10:57 AM
Super User
Posts: 11,343

Re: See default variable names rather than labels in SAS dataset

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?

Contributor
Posts: 36

Re: See default variable names rather than labels in SAS dataset

Got it. Thanks for your time
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 420 views
  • 1 like
  • 4 in conversation