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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.