Export to Excel using SAS

Question

Suppose I have 2 SAS dataset: test1.sas & Test2.sas. Now I want to export these 2 dataset into excel, where in the excel file Sheet1 will have test1.sas data & in Sheet2 will have test2.sas data.

How to do it?

Answer 1

Start with this paper. This and this are also good references.

Using ODS, you can output your data using reporting procs (Ex. Proc PRINT and REPORT) to XML. Not only can you create multisheet output, but you can format dates, set autofilters and place headers.