SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

SAS and VB

Reply
N/A
Posts: 0

SAS and VB

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
N/A
Posts: 0

Re: SAS and VB

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

thank you
Snk
SAS Super FREQ
Posts: 8,819

Re: SAS and VB

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
N/A
Posts: 0

Re: SAS and VB

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)
Ask a Question
Discussion stats
  • 3 replies
  • 212 views
  • 0 likes
  • 2 in conversation