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,864

Re: SAS Data to Existing Excel Spread Sheets

Posted in reply to deleted_user
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

Posted in reply to deleted_user
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

Posted in reply to deleted_user
thanks a lot for your help.
Ask a Question
Discussion stats
  • 3 replies
  • 102 views
  • 0 likes
  • 2 in conversation