topic See default variable names rather than labels in SAS dataset in SAS Programming

See default variable names rather than labels in SAS dataset

vandhan — Tue, 20 Sep 2016 09:47:37 GMT

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.

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

fusima — Tue, 20 Sep 2016 09:55:28 GMT

Hi,

there is an option to do that since SAS 9.2.

options nolabel;

Hope this helps you.

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

vandhan — Tue, 20 Sep 2016 10:02:55 GMT

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. -##

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

Reeza — Tue, 20 Sep 2016 10:07:39 GMT

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

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

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

ballardw — Tue, 20 Sep 2016 14:20:27 GMT

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.

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

vandhan — Wed, 21 Sep 2016 07:05:52 GMT

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. -##

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

ballardw — Wed, 21 Sep 2016 14:55:21 GMT

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?

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

vandhan — Wed, 21 Sep 2016 14:56:56 GMT

Got it. Thanks for your time

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

evp000 — Wed, 14 Mar 2018 16:02:52 GMT

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.