I want to export around 50 datasets to one excel sheet and each dataset should be exported to a new worksheet within the same excel sheet.In the end it should be one single excel sheet with 50 worksheets.
But probs is I want this to be done using UNIX sas9. Can anyone help?
Or, you can use TAGSETS.EXCELXP to create a Spreadsheet Markup Language file, which is the type of XML file used by Excel 2002 and higher to define a workbook. After the file is created, you would have to FTP the file to a location where you could open the file with Excel. The file created by TAGSETS.EXCELXP is an ASCII text file. (the result of the doc='Help' is a list of allowed "suboptions" will be shown in the SAS Log)
ods tagsets.excelxp file='multsheet.xml'
proc print data=sashelp.class(obs=5);