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.
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.
Ready to level-up your skills? Choose your own adventure.