Replace the same excel output by using same template with new data in proc datasets

[rinsabraham]

how to replace the same excel template output with new data but the columns has been increased in the new datasets.

refer the below code:

libname _ibxls 'c:\path\libname.xlsx';

proc datasets lib=_ibxls;

delete data;

run;

proc datasets lib=_ibxls;

delete 'data'$n ;

run;

proc append base=_ibxls.data data=abc;

run;

libname _ibxls clear;

my excel sheet had 2 columns and I have delete the data present in the sheet that has to be replaced with the new data.in my new dataset have  5 column .how do we  achieve the same templates for theses addition columns using above mentioned code.

Request you to please help me.

[RW9 · Accepted solution]

I don't think it is possible.  If your using a range in an Excel file, then the data output needs to match that range.  If you have to fit into your Excel template something which does not fit into that template...

All I can suggest is you update your Excel template's range to be big enough to handle any now or future additional areas, or find some other way to process the data as it comes in.  One way is to dump SAS data out to an Excel file, and then have your template file run some VBA code to pull that data into itself.