BookmarkSubscribeRSS Feed
Mushy
Quartz | Level 8

Hello All,

 

How do we disable the display of the column names of a table in EG?

Under Servers-->SASApp-->Libraries--->(LIBNAME) -->(TABLE NAME)

It shows all field names when I expand the Table name. I would like to disable this feature and I dont want to expand to see column names?

 

Thanks

Mushy

5 REPLIES 5
SASKiwi
PROC Star

I'm mystified - what you would want to see instead?

Mushy
Quartz | Level 8

I would like to see only tables when I expand the library. I dont want to expand table  to see the column names. In 7.1 version we could see only the table name. if we want to see its columns then we could see using the properties.

 

Thanks

Mushy

SASKiwi
PROC Star

You only see tables when you expand libraries, not columns in EG 8. You only see columns if you expand a table. If you don't want to see columns just don't expand tables.

Mushy
Quartz | Level 8

Indeed you are right... but I see we could increase the performance without having the columns loaded. so wanted to know if there are any settings/options that could be adapted in order to increase the performance or reduce the loading time 

 

Thanks

Mushy

SASKiwi
PROC Star

AFAIK, there is no such option. You can limit the default number of tables displayed in a library. The default value is 500. If you reduced this value that would improve performance. Also using the latest version of EG - 8.3 Update 5 - should give you better performance than earlier versions.  

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 5 replies
  • 938 views
  • 1 like
  • 2 in conversation