SAS and VB

[deleted_user]

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

[deleted_user]

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

thank you
Snk

[Cynthia_sas]

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

[deleted_user]

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)