BookmarkSubscribeRSS Feed
aarony
Obsidian | Level 7

i just purchased a computer with i7 and 16gb ram etc. for some reason though, when I double click on the data in the explorer tab, the view table takes ages to pop up (30 seconds ish). This is super abnormal because my personal desktop with lesser spec is a lot faster. It opens view table at an instant like most other computers that I used in my life. Did you by any chance know the solution to this?

13 REPLIES 13
ChrisNZ
Tourmaline | Level 20

What's the libname statement for the library containing the table?

Is it a SASHELP view you are opening? If so what other libraries are defined?

 

aarony
Obsidian | Level 7

hi chrisnz, i am using just work. is that what you mean?

i m not opening sashelp. i m just trying to open my data.

 

Thanks so much

ChrisNZ
Tourmaline | Level 20


Long shot but to be thorough: where is your work directory located?

Do you open a table or a view?

Are you using EG or SAS desktop?

Which explorer are you refering to? The SAS explorer?

aarony
Obsidian | Level 7

i think it is the view as i am doing the view table? it takes ages to open up work.d1.

a.png

Patrick
Opal | Level 21

Are you comparing apples with apples? Is this a comparison between the same view definition using the same data?

 

When you use a view (i.e. when you open it in a viewer) the view gets executed. If that's an intense query then it can take some time.

 

Some of the clients like SAS EG have also option settings limiting how many rows get loaded at once to the viewer if opening tables or views. You might want to investigate these settings as well as loading too many rows at once can heavily impact on viewer performance.

aarony
Obsidian | Level 7

a.png

 

 

i essentially double click on data d1 in the work file. super simple and small data. it takes 30+ seconds to actually view table.

i am not a sas expert but would really love to get your helps.

 

thank you.

rogerjdeangelis
Barite | Level 11
I rarely use viewtable, although I have vu and vuh command macros on mouse actions.
Over 20 functions on mouse actions.

Some of these date back to the late 70s(ISPF) and have worked flaelessly without need to migrate with a new version of SAS.

This functinnality has been turned off in EE and will not work in EG, UE or SAS studio

The following command macros, can either be executed on the 'old text editor' command line, on a mouse action or function key.

 avgh     proc means highlighted dataset
  avg      proc means last dataset
  cnt      cnt name*sex - last dataset number unique combinations
  cnth     cnt name*sex - hi-lited dataset
  cntv     cnt hi-lited variable last dataset
  con      contents last dataset
  conh     contents hi-lited dataset
 *debug    macro debug hi-lited
 *dmp      contents with sample data
 *dmph     contents with sample data hi-lited dataset
  evl      evaluate highlighted formula
 *frq      freq sex*age last dataset
 *frqh     freq sex*age hi-lited dataset
  frqv     freq hilited variable last dataset
  iota     column of consecutive integers
 *ls40     40 obs last dataset
 *ls40h    40 obs hi-lited dataset
  lsal     all obs last dataset
  parh     does hi-lited code have matched paraentheses (tells you what is missing)
  proch    syntax for the proc - hi-lite 'proc reg' and get syntax with example
 *prtw     prtw 'sex="M"' - last dataset subset printed
 *prtwh    prtw 'sex="M"' - hi-lited dataset subset printed
  sumh     statistics on hi-lited column of numbers
  sumv     statistics on hi-lited variable last dataset
  unv      proc univariate on variable in last dataset
  unvh     proc univariate on variable in highlighted dataset
  vu       viewtable last dataset
  vuh      viewtable hi-lited dataset
 *xlsh     view and edit hi-lited dataset in excel (may need a sleep w slow systems)
 *xplo     xplo SUBSUM put exploded chars in past buffer
 *xplop    exploded banner using Puthon  
  exl      open excel on last dataset
  exlh     opend excel on highlighted dataset

Start with a simple one and add over the years?
Reeza
Super User

What version of SAS amd what version of Windows?

aarony
Obsidian | Level 7
Hi reeza, sas is 9.4ts1mo and my windows is 7 pro. Thanks so much!
Reeza
Super User

M0 is def buggy, upgrade if possible. 

 

Also, turn off a bunch of the features here:

 

http://www.sevenforums.com/tutorials/1908-visual-effects-settings-change.html

aarony
Obsidian | Level 7
Hi reeza thx for ur email. Still no difference when I turn everything off...sigh...
Is this an unusual problem?

Reeza
Super User

Yeah. You can contact SAS Tech Support and they can work with you. 

aarony
Obsidian | Level 7
Thx so much. Will do!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 13 replies
  • 2838 views
  • 0 likes
  • 5 in conversation