topic Re: VBScripting in SAS Enterprise Guide

VBScripting

cjohnson — Tue, 19 Apr 2011 16:06:01 GMT

I am trying to learn more about using VBScript to run SAS processes. I have written the script below just to open and run a few code files in SAS EG, but this is as far as I got. Is there any good reference for this?

'Set ErrorHandler
On Error Resume Next

'Run Daily
ProjectName = "\\Nasvs1\Shared\4700Mac\Shared3\Actuarial\SAS\Projects\ISO.egp"
Files = Array("LIBRARIES", "PLCY")
Call Work(ProjectName, Files)

'Define Functions
Sub Work(ProjectName, Files)
Set App = CreateObject("SASEGObjectModel.Application.4")
Set Project = App.Open(ProjectName,"")
Set Container = Project.CodeCollection
For Each File In Files
For Each Object In Container
If Object.Name = File Then Object.Run

Next
Next
Project.Save
Project.Close
End Sub

'Reset Error Handler
On Error Goto 0

Re: VBScripting

ChrisHemedinger — Wed, 20 Apr 2011 14:03:30 GMT

Here is some reference documentation.

For 4.1:
http://support.sas.com/documentation/onlinedoc/guide/SASEGScripting41.zip

For 4.2, and generally useful for 4.3 as well (no substantive changes):
http://support.sas.com/documentation/onlinedoc/guide/SASEGScripting42.zip

Also, there are several examples at (for 4.2 or 4.3):

http://support.sas.com/kb/40/781.html

Chris

Re: VBScripting

cjohnson — Wed, 20 Apr 2011 14:13:59 GMT

Thanks. This is exactly what I needed.