SAS 9.4 Very slow or not responding

Reply
Occasional Contributor
Posts: 8

SAS 9.4 Very slow or not responding

Hi guys,

 

since last month my SAS 9.4 is extremely slow, the initialization is taking a whole life, when a ask to open a table (even a table with two rows and two columns) doesn't take less than 3min, the WRDS remote access is slow too.

 

Does anybody know if something happened lately or any reason for this change on my SAS performance?

Super User
Posts: 23,323

Re: SAS 9.4 Very slow or not responding

WRDS is running on Wharton's servers, so you likely need to talk to them about speed issues. They do have support.

 

What type of SAS installation do you have? Are you using SAS UE running locally, or SAS Studio and using your schools SAS server? Or some other type of installation?

Occasional Contributor
Posts: 8

Re: SAS 9.4 Very slow or not responding

I don't believe is a problem with WRDS because the remote tasks are performing very fast. The problem is when I thy to login, the SAS is taking a long time to answer my request to login.

 

It's a SAS 9.4v with a University License installed in my laptop.

Super User
Posts: 3,861

Re: SAS 9.4 Very slow or not responding

Is this a local SAS installation (on your PC) or are you connecting to a remote SAS server? If it is local then check Windows Task Manager. What does it show in terms of CPU usage and memory usage? Also check free space on your hard drive - do you have plenty of free space?

Occasional Contributor
Posts: 8

Re: SAS 9.4 Very slow or not responding

It's a local SAS installation.

When SAS was trying to login at my WRDS account it was using 0% of my CPU ans 37MB of my memory.

My laptop has 414GB free memory and a Intel(R) Core(TM) i5-4210U 1.70Ghz CPU.

Super User
Posts: 23,323

Re: SAS 9.4 Very slow or not responding

When SAS was trying to login at my WRDS account it was using 0% of my CPU ans 37MB of my memory.

 

That still sounds like the SAS server at WRDS taking time to load, not SAS 9.4

Or are you referring to when you start up the application before you try to log in to WRDS? That would then be part of your local installation issue. If that's the case I would check what updates have been applied in the past month and if you have the latest version of SAS (9.4 TS1M5) which your University should have access to free of cost. 

Occasional Contributor
Posts: 8

Re: SAS 9.4 Very slow or not responding

But it's not just when I try to login at WRDS. It also happens when I try to open tables, no matter the table size, the initialization is taking forever too.

 

My SAS is a SAS 9.4 TS Level 1M4.

Super User
Posts: 23,323

Re: SAS 9.4 Very slow or not responding

Are those tables on your server or the WRDS server? Did you download the data from WRDS and are trying to work with it locally?

What's the library reference for them? 

Super User
Posts: 23,323

Re: SAS 9.4 Very slow or not responding

FYI - anything with WRDS is going over your internet connection lines. If you've been doing a lot of work with these data sets, and they can be big, in terms of downloading them you may have exceeded your usage limits and are having your speeds throttled by your ISP. 

Any other slowdowns with internet streaming devices or issues?

Occasional Contributor
Posts: 8

Re: SAS 9.4 Very slow or not responding

The tables are on my laptop. Even tables with 2 rows are taking more than 5min to open.
PROC Star
Posts: 2,319

Re: SAS 9.4 Very slow or not responding

Does your local SAS session have an autoexec file?

Does this file contain references to a remote server (libraries not on the C: drive , signon)?

Does your local config file reference remote locations for some files (like macro libraries?

What happens when you start your local SAS session with no network connection?

Occasional Contributor
Posts: 8

Re: SAS 9.4 Very slow or not responding

Does your local SAS session have an autoexec file?

A: I don't know where to look at for it.

 

Does this file contain references to a remote server (libraries not on the C: drive , signon)?

A: No, my libraries are at my C: drive.

 

Does your local config file reference remote locations for some files (like macro libraries?

No

 

What happens when you start your local SAS session with no network connection?

It's much faster without internet. Why is that happening?

PROC Star
Posts: 2,319

Re: SAS 9.4 Very slow or not responding

Your local SAS session references some remote resources on a very slow link.

You have to find out what is referenced.

You could run proc options  and look for remote paths.

 

 

Occasional Contributor
Posts: 8

Re: SAS 9.4 Very slow or not responding

Thank you!

How can I do that? I have never used proc options before.

PROC Star
Posts: 2,319

Re: SAS 9.4 Very slow or not responding

It's a complex syntax, brace yourself.

 proc options; run;

Smiley Wink

 

Then check the log.

 

Ask a Question
Discussion stats
  • 16 replies
  • 779 views
  • 0 likes
  • 5 in conversation