topic proc export update existing excel data using sas in SAS Programming

proc export update existing excel data using sas

radha009 — Tue, 12 Jun 2018 18:15:59 GMT

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

Re: proc export update existing excel data using sas

SuryaKiran — Tue, 12 Jun 2018 18:24:12 GMT

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

Re: proc export update existing excel data using sas

art297 — Tue, 12 Jun 2018 19:09:59 GMT

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