DATA Step, Macro, Functions and more

sas view table really slow

Reply
Frequent Contributor
Posts: 102

sas view table really slow

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?

PROC Star
Posts: 1,760

Re: sas view table really slow

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?

 

Frequent Contributor
Posts: 102

Re: sas view table really slow

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

PROC Star
Posts: 1,760

Re: sas view table really slow


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?

Frequent Contributor
Posts: 102

Re: sas view table really slow

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

a.png

Respected Advisor
Posts: 4,173

Re: sas view table really slow

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.

Frequent Contributor
Posts: 102

Re: sas view table really slow

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.

Valued Guide
Posts: 505

Re: sas view table really slow

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?
Super User
Posts: 19,877

Re: sas view table really slow

What version of SAS amd what version of Windows?

Frequent Contributor
Posts: 102

Re: sas view table really slow

Hi reeza, sas is 9.4ts1mo and my windows is 7 pro. Thanks so much!
Super User
Posts: 19,877

Re: sas view table really slow

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

Frequent Contributor
Posts: 102

Re: sas view table really slow

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

Super User
Posts: 19,877

Re: sas view table really slow

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

Frequent Contributor
Posts: 102

Re: sas view table really slow

Thx so much. Will do!
Ask a Question
Discussion stats
  • 13 replies
  • 255 views
  • 0 likes
  • 5 in conversation