An Idea Exchange for SAS software and services

by Trusted Advisor
on ‎03-05-2017 12:53 AM

What SAS platform are you using ?


In most cases you can choose display either thr LABEL (variable header) or the variable NAME.

The way to do the change may differ according to the tool (platform, procedure) you use.

by Regular Contributor
on ‎03-05-2017 12:59 AM
I'm using SAS 9.4, is it possible to show the variables as a tab just like the way the libraries are displayed?
by Trusted Advisor
on ‎03-05-2017 01:05 AM

Look for VIEW menue while displaying the table.

by Regular Contributor
‎03-05-2017 02:12 AM - edited ‎03-05-2017 02:14 AM

Please refer to my initial question and feature suggestion. The question I asked is unfortunatly not solved by the "view menu".  

The option you are mentioning simply displays the table columns details. It dose not give the functionally I suggested. 


by Super User
on ‎03-05-2017 05:37 AM

Assuming you're using Base SAS then it seems the direction has been to not develop the IDE here, instead if was focused in EG and now SAS Studio. 

EG was included with a SAS license and I suspect SAS Studio is similarilu bundled though not sure. 


FYI - if you right click a table, select properties the view has the list of variables and types but you can't copy and paste it into code. 

by Regular Contributor
‎03-05-2017 05:41 AM - edited ‎03-05-2017 05:41 AM

Thanks Reeza

I guess it makes sence that Base SAS is not intended to be an IDE, though smaller additions like the one I suggested would make working with data a lot easier.. at least for me.

I guess the option would be otherwise to move to EG, though I like the cleaner interface of Base SAS

Thanks Again Reeza

Kind regards


by Super User
on ‎03-05-2017 07:15 PM

It really seems SAS is not doing much with upgrading the Display Manager interface.  But if you ar eusing Display Manager you could take a couple of steps and get something close to what you want.

1) Open the VAR window for the dataset. There are GUI ways to do this, but you can also just use the VAR statement from the command line.

2) Right click in the VAR window and select COPY.

3) Open a new empty program windows (Enhanced or Old PGM window).

4) Paste the variable list into that window.


Now you can use your new program window to copy and paste the variable names from.

by Super User
on ‎03-06-2017 11:19 AM

I'm not quite sure I understand what you mean by "tab" as viewtable, which is the base SAS table viewer, does not have any tabs. The column heading can change from label to variable name using the view menu. If you want to change the default behavior make the SAS explorer the active window, go to the tools menu, select options, Explorer. go to the Members tab, select TABLE and then the entry for &Open. Edit the command to look something like:


VIEWTABLE %8b."%s".DATA colheading=name


I have a number of other options set but this will open tables with the colheading option on.

You will likely want to do the same for VIEWS. Search the online help for VIEWTABLE syntax to find commands that might be useful.

by SAS Employee JodyC_SAS
on ‎07-05-2017 06:56 PM

In the 3.5+ SAS Studio release, you can drag the highlighted table or variable names from the Libraries pane into the code window. More details can be found online under "Add table and variable names to your code" in the article, "Tips for Programming Efficiently in SAS Studio". 


by Community Manager
on ‎12-06-2017 03:36 PM
Status changed to: Under Consideration
Idea Statuses
Top Liked Authors