Choosing the Right Tool From Your SAS and Microsoft Excel Tool Belt
There are over a dozen ways to bring the data into SAS from Microsoft Excel or to push it out from SAS to Excel. Some are simple wizards, and others are more complex programming techniques. How does one know which tool is the best for their application? Which will cause one the least number of headaches? Which will produce the quickest, most accurate results? Which will best satisfy the end user? The paper will give an overview of import and export techniques for Excel and make recommendations for different application types.