So how do you interface with your SAS server? SAS Enterprise Guide, SAS Studio, SAS Windowing Enviroment (Display Manager) or some other way? 1 million records is very small for a Windows server. I regularly deal with hundreds of millions of records on a Windows server and performance is fast. How fast your SAS job runs has nothing to do with your network speed as long as you are not downloading SAS data to your PC. Server performance is mostly influenced by disk IO performance - how fast data can be read and written to disk.
... View more