topic Re: Intel Xeon E5 or i7 7700 in SAS Programming

Intel Xeon E5 or i7 7700

hhchenfx — Tue, 20 Feb 2018 15:23:04 GMT

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

Re: Intel Xeon E5 or i7 7700

LinusH — Tue, 20 Feb 2018 15:32:23 GMT

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.

Re: Intel Xeon E5 or i7 7700

hhchenfx — Tue, 20 Feb 2018 20:46:17 GMT

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

Sometime it use up to 30G Ram.

By the way, what is IO means?

Re: Intel Xeon E5 or i7 7700

LinusH — Wed, 21 Feb 2018 07:20:32 GMT

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.

Re: Intel Xeon E5 or i7 7700

ChrisNZ — Wed, 21 Feb 2018 20:29:21 GMT

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.