SAS Add-in for Microsoft and Customized Report Templates

[BStats]

Does the SAS Microsoft Add-in have the ability to auto populate a customized report template? If not, what is the best way to achieve this? The company I work for has a specific designed template that they have created and wants it to auto populated after running a stored process. In the past, this appeared to be done using DDE. However, I don't know what would be the current way of achieving this task.

All data analysis is done in SAS. 

Thanks for the help.

[Reeza]

There are options - you can proc export to specified ranges now but I still use DDE. You can replicate the template using ODS EXCEL or TAGSETS.EXCELXP.

[BStats]

Do you know if the Add-in has that ability? For the options you mentioned are there any good examples that I could look at? 

Thanks.

[Cynthia_sas]

Hi, As Reeza suggested, you might try to see whether the Excel template can be created using your Stored Process and PROC REPORT or PROC TABULATE. Generally speaking, when you use the Add-in for Microsoft office you are interactively reaching to SAS from inside Office and "pulling" data and results from SAS into the Office application. The SAS Add-in software knows how to translate from the internal SAS format for data and reports to the Office format (depending on whether you are in Word or Excel or PowerPoint). The SAS Add-in typically doesn't use anything like DDE, although you can use Excel or Word macros or VB Script after you pull your data or report into Office. Reeza's idea of using PROC EXPORT to named ranges as an alternative to DDE is typically a technique that is used when you do NOT have the SAS Add-in to Microsoft Office -- so it might be harder to implement a PROC EXPORT from within a stored process. Depending on what you want to do and what your template looks like, you might want to open a track with Tech Support for more specific help. A lot will come down to what the template looks like and what you are trying to make the stored process update.

cynthia

[BStats]

Thank you. We are looking into all options.

[Reeza]

Search LexJansen.com

For the Export using DDE or specific ranges I wrote a paper which is here:

http://www.sas.com/content/dam/SAS/en_ca/User%20Group%20Presentations/Edmonton-User-Group/FareezaKhu...

[BStats]

Thanks for the paper. I am definitly going to look into everything you mentioned, as well as reviewing your paper. At this point we are looking into any way of completeing this project. We are not stuck on using a stored process or the Microsoft Add-in. So any other ideas would be helpful as well. 

I would share the template but we are under some tight regulations, therefore I am unable. 

Like I said all Ideas are welcome. 

Thank you.