An Optimal Way to Import Excel Worksheets Into PC SAS
Source: SAS Institute
There are many ways to import data from Microsoft R Excel R into PC SAS R, 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". The paper then proposes 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).