BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
bnawrocki
Quartz | Level 8

My co-worker and I have similar Windows 7 PCs running SAS locally - we have similar amounts of free disk space and memory and CPUs.

 

However, when she runs a SAS program, it takes her computer 3 or 4 times longer to run it than when I run the same program. The SAS code accesses SAS datasets that reside on our network.

 

I've looked at Windows Task Manager, and her computer doesn't seem to be maxing out on CPU or Memory when she is running the SAS code. I know how to read the SAS log to show "CPU"  time and "Real" time used by each SAS code step. Her CPU time is similar, but Real time is much, much higher.

 

Any ideas how to troubleshoot this issue? 

1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

Some obvious things to check.

How busy is the machine doing other things? They could be taking CPU cycles, using memory, moving the disk head away from where SAS needs to read and/or write.

Are you using remote or local disks?  If remote how fast is the connection to the disk.  If local how optimized is the disk?  perhaps the data being read is fragmented on one disk and contiguous on the other.  Similarly for writing is there contiguous space to write the data or does the disk head need to jump around.

How similar are the machines really? Are the CPUs specs really the same? Are the disks really the same? Is the memory speed really the same?

View solution in original post

1 REPLY 1
Tom
Super User Tom
Super User

Some obvious things to check.

How busy is the machine doing other things? They could be taking CPU cycles, using memory, moving the disk head away from where SAS needs to read and/or write.

Are you using remote or local disks?  If remote how fast is the connection to the disk.  If local how optimized is the disk?  perhaps the data being read is fragmented on one disk and contiguous on the other.  Similarly for writing is there contiguous space to write the data or does the disk head need to jump around.

How similar are the machines really? Are the CPUs specs really the same? Are the disks really the same? Is the memory speed really the same?

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 797 views
  • 0 likes
  • 2 in conversation