Append the data in the excel

[shru]

Hi,

I need to append the data in the excel every month on a column wise using Libname excel method.    

For example:i need to append the data everymonth

How can i do this..it would be helpfull if you suggest me on the same

thanks

shruthi

[Peter_C]

1 libname pointing into the rangename in excel (the data to be extended))

libname exl 'your_workbook' ;

2

proc append base = exl.rangenam1 data= dataset_of_newrows ;

run ;

(but I have no sas/access to pc files to test this)