SAS Add in for Microsoft Excel - How to link with SAS code

[skallamp]

Hello,

I would like to send the SAS output in excel version and the user should be able to refresh/update this excel report whenever there is a change in the data.

An example would be Monthly sales of a Laptop.

If I created an excel report which contains the geography details, Price, Units etc on a month basis and wanted to add the next month when ever the new data is available in the server.

Can I use the SAS 7.1 excel add in option to refresh my results? How to I do this? I need to do this from scratch? Is there a good document available for reading?

Thanks,

+Sathyan

[M_Dexter]

Sathyan,

You might find this Getting Started book useful:  SAS(R) Add-In 7.1 for Microsoft Office: Getting Started in Microsoft Excel, Microsoft Word, and Micr....

Marie