topic Re: SAS Data to Existing Excel Spread Sheets in SAS Procedures

SAS Data to Existing Excel Spread Sheets

deleted_user — Thu, 12 Jun 2008 23:27:12 GMT

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

Re: SAS Data to Existing Excel Spread Sheets

Cynthia_sas — Fri, 13 Jun 2008 11:59:42 GMT

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

Re: SAS Data to Existing Excel Spread Sheets

deleted_user — Mon, 16 Jun 2008 15:55:15 GMT

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

Re: SAS Data to Existing Excel Spread Sheets

deleted_user — Fri, 20 Jun 2008 21:12:39 GMT

thanks a lot for your help.