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
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.
Currently, I use the i7 3770 with 32G ram.
Sometime it use up to 30G Ram.
By the way, what is IO means?
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.