Export into existing Excel sheet

[ks2012]

Dear All,

I want to export the data from SAS dataset to existing excel file, it is possible or not.
I am tring to do that since last 3/4 days with the help of goggle search also but not able to do that. Request you to please assit Or can i replace the data from csv file to particular excel sheet through unix.

Thanks in advance.

[Janus]

It is possible to export data to an existing workbook as a new sheet.

This should do the trick, though I would test it on a workbook you don't mind losing first.

[] denote where you need to fill in info.

libname xls [file path to excel workbook];
data xls.[new sheet name];
set [data];
run;
libname xls clear;