Transferring data analytical results between SAS and Microsoft Excel can be difficult, especially when SAS is not installed on a Windows platform. This paper discusses using new XML support in Base SAS 9.1 to move data between SAS and Microsoft Excel (version 2002 and later). You will learn step-by-step techniques to quickly and easily create multi-sheet Excel workbooks containing your SAS output. You’ll also learn about converting your own multi-sheet Excel workbooks to SAS tables. The technique described here can be used regardless of the platform on which SAS software is installed, including a mainframe! The use of SAS server technology is also discussed.
Paper:
conference:
Paper Type:
Paper
