There are many ways to import data from Microsoft® Excel® into PC SAS® , and the “optimal” way often depends upon the project and the programmer’s preference. However, by adhering to clear definitions of three generally desirable properties (precision, flexibility and automation), we can agree upon a definition of “optimal”. We then propose a solution that fulfills these three properties. This is most appropriate for situations where data from a large set of Excel worksheets is periodically loaded into SAS, where each Excel worksheet has the same structure from load to load (although the worksheets can have different structures from each other). This proposed solution involves an easily used macro which works on all versions of PC SAS, Windows® and Excel, and which is freely available for downloading.
conference:
Paper Type:
Paper
