DATA Step, Macro, Functions and more

proc export update existing excel data using sas

Reply
Contributor
Posts: 67

proc export update existing excel data using sas

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

Valued Guide
Posts: 558

Re: proc export update existing excel data using sas

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

Thanks,
Suryakiran
PROC Star
Posts: 8,145

Re: proc export update existing excel data using sas

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

 

Ask a Question
Discussion stats
  • 2 replies
  • 53 views
  • 0 likes
  • 3 in conversation