DATA Step, Macro, Functions and more

Intel Xeon E5 or i7 7700

Accepted Solution Solved
Reply
Super Contributor
Posts: 503
Accepted Solution

Intel Xeon E5 or i7 7700

Hi Everyone,

 

I am about to buy new PC. My work is mostly on:

- Proc SQL and transpose to transform the data

- analyze a timeseries record by record to see how the series perform, such as which period it go up and what period it go down longest.

 

However, the data is quite large and I have to run thought many dataset so it take long time to complete the job.

 

My question is that, with that nature of work, should I buy server with Intel Xeon E5 kind of machine (with 64G RAM)or buy PC with i7 7700 (with 32G Ram).

 

Thank you for your help.

HHCFX

 

 


Accepted Solutions
Solution
‎02-21-2018 10:45 AM
Super User
Posts: 5,829

Re: Intel Xeon E5 or i7 7700

Input / output operations, in other words, reading from /writing to disk.
If you are currently utilizing 30GB you will probable benefit from a 64GB setup.
Data never sleeps

View solution in original post


All Replies
Super User
Posts: 5,829

Re: Intel Xeon E5 or i7 7700

Hard to tell with this little info.

First step to monitor your jobs on the existing computer, and see if you are CPU, RAM och I/O bound.

 

CPU is usually the least utilized in SAS, but I'm unsure about time series calculations...

Statistics, sorts and SQL joins usually likes lot's of RAM, so you don't have to page to disk during processing.

Fast disks will always be a good investments, SSD prefererad nowadays I think.

Data never sleeps
Super Contributor
Posts: 503

Re: Intel Xeon E5 or i7 7700

Currently, I use the i7 3770 with 32G ram.

Sometime it use up to 30G Ram.

By the way, what is IO means?

PROC Star
Posts: 2,231

Re: Intel Xeon E5 or i7 7700

IO means InputOutput, in other word, disk access.

Ensure that you have really fast storage, it's much more important than CPU on most cases.

On a PC, that's Solid State Drives hooked to the PCIe bus, such as M.2 or NVMe. Not SATA.

Solution
‎02-21-2018 10:45 AM
Super User
Posts: 5,829

Re: Intel Xeon E5 or i7 7700

Input / output operations, in other words, reading from /writing to disk.
If you are currently utilizing 30GB you will probable benefit from a 64GB setup.
Data never sleeps
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 140 views
  • 1 like
  • 3 in conversation