The XLSX libname engine in SAS allows you to read and write Microsoft Excel files in the same way that you can work with other data sets and databases. This article describes the basic (and some limitations) of the XLSX engine.
(Otherwise known as Truncate – Load – Analyze – Repeat!) After you’ve prepared data for analysis and then analyzed it, how do you complete this process again? And again? And again? Most analytical applications are created to truncate the prior data, load new data for analysis, analyze it and repeat
This SAS tip is from Robert Virgile and his book “SAS Macro Language Magic: Discovering Advanced Techniques”. We hope you find this tip useful. You can also read an excerpt from Virgile’s book. When CALL SYMPUT creates a new macro variable, it places that variable in “the closest non-empty symbol
