Search up: SAS Windows Automation Object
and you will find a paper "Using SAS as an Automation Server in
Windows Application Development" by Zhuan (John) Xu --
Richard A. DeVenezia
On Thu, Feb 10, 2011 at 6:12 PM, Tanmoy Mukherjee <firstname.lastname@example.org> wrote:
> I will appreciate if someone can guide me with regards to running SAS V9.2 through Excel 2010 VBA Macros. I have a excel macro that calls an outside database, creates a dataset which then needs to be run on SAS V9.2 and then the results exported to Excel again. Since all we are doing outside of Excel is running SAS I was wondering if a VBA code can be written to call the SAS program and execute the query.
> I will appreciate if someone can guide towards the same.
> Thanks and Regards,