How can i move all the three datasets in to single excel sheet one after the other.For me the problem is it is creating three excel sheets separately how can i move all the three in to single excel sheet continously.Now i want sashelp.class to print in the same sheet for three times .
And is there any replace options as if we run the same for 2-3 times it should overwrite the old one.
Look at the internal help for TAGSETS.EXCELXP -- you will see it in the SAS log if you ask for the doc in a sub-option:
ods tagsets.ExcelXP file="C:\Documents and Settings\out.xls"
In the doc in the SAS log, you will find the sheet_name and sheet_interval sub-options. You should be able to use the sheet_interval sub-option to get all 3 procedure outputs in one sheet.