Help using Base SAS procedures

SAS Data to Existing Excel Spread Sheets

Reply
N/A
Posts: 0

SAS Data to Existing Excel Spread Sheets

Does anyone know of any solutions or papers written on moving PC SAS data to an existing Excel template. The data is the same from month to month including some SAS Graphics.
Fred W.
Seattle
SAS Super FREQ
Posts: 8,742

Re: SAS Data to Existing Excel Spread Sheets

Hi:
I believe this falls into the area of DDE, ODBC and OLE-DB methods ... where SAS issues instructions to Excel using one of these Microsoft technologies.

If you search for previous forum postings on this subject, I believe there have been other forum postings on these questions. Also, if you search on support.sas.com, you should find some examples of using these technologies to have SAS write to an existing spreadsheet or Microsoft file.

cynthia
N/A
Posts: 0

Re: SAS Data to Existing Excel Spread Sheets

there was a poster/paper in SAS Global Forum 2008, populating existing excel template with SAS data.


http://www2.sas.com/proceedings/forum2008/229-2008.pdf

SK
N/A
Posts: 0

Re: SAS Data to Existing Excel Spread Sheets

thanks a lot for your help.
Ask a Question
Discussion stats
  • 3 replies
  • 98 views
  • 0 likes
  • 2 in conversation