SAS Data to Existing Excel Spread Sheets

[deleted_user]

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

[Cynthia_sas]

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

[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

[deleted_user]

thanks a lot for your help.