topic SAS and VB in Microsoft Integration with SAS

SAS and VB

deleted_user — Thu, 17 Jul 2008 11:33:38 GMT

Hi, is there a way to run SAS file in VB without having SAS installed on the client/local machine. What SAS/MS or other software needed to accomplish this.

thanks
Sk

Re: SAS and VB

deleted_user — Thu, 24 Jul 2008 19:58:30 GMT

I would really appreciate if some one can give an input on this.

thank you
Snk

Re: SAS and VB

Cynthia_sas — Fri, 25 Jul 2008 04:05:12 GMT

Hi:
If you need a quick response, then you should contact Tech Support for help.

A search of the Tech Support site shows these hits (among others), searching on the terms "VB Script", "VBA", ".Net", ".COM" and "IOM":
http://www2.sas.com/proceedings/sugi30/044-30.pdf
http://www2.sas.com/proceedings/sugi30/009-30.pdf
http://support.sas.com/kb/25/276.html
http://www2.sas.com/proceedings/sugi30/234-30.pdf
http://www2.sas.com/proceedings/sugi28/032-28.pdf
http://www2.sas.com/proceedings/forum2008/011-2008.pdf
http://support.sas.com/kb/25/959.html
http://www2.sas.com/proceedings/forum2008/395-2008.pdf
http://www2.sas.com/proceedings/sugi27/p174-27.pdf
http://www2.sas.com/proceedings/sugi30/157-30.pdf

I wonder why you're not looking at SAS Enterprise Guide. One of the uses of EG is to allow a user to have EG on a local machine --- without a local copy of SAS and EG manages communication and code processing and talks to a server copy of SAS.

cynthia

Re: SAS and VB

deleted_user — Sun, 17 Aug 2008 00:10:57 GMT

Sure, use DDE (it's sas technology thats been around for a long time that uses older microsoft version of vba, but it's still a nice SAS to Microsoft gateway, and gives you lots of direct microsoft functional control over the spreadsheet/workbook)