proc export update existing excel data using sas

[radha009]

My excel last month data contains range of data in 8 sheets and graphs included based on the data in the excel. in current month once i create the new data, i want to update only the range of data in the last month excel so that the graphs will not need to be recreated every month.

please see the attachment for the existing data excel sheet

[SuryaKiran]

Why Data from SAS and Graph created from excel. Along with data create the graph too in SAS and send it.

[art297]

You can download and run the following macro: http://www.sascommunity.org/wiki/Excelling_to_Another_Level_with_SAS

It can be used to either modify the data in the existing worksheets and/or use the existing workbook as a template and import the desired range of data.

Art, CEO, AnalystFinder.com