topic SAS EG and Vb Script in SAS Enterprise Guide

SAS EG and Vb Script

deleted_user — Thu, 04 Feb 2010 16:05:27 GMT

Hi
I am running a SAS EG 4.1 project scheduled to run from a VB script.

I want to ask if some error occur in sas project. Does that vb script close that sas session or that project file for us.

Also i need to know does this occur if i give endsas statement or abort statement.
what are its effects after dissconecting from server.

thanks
avi

Re: SAS EG and Vb Script

ChrisHemedinger — Thu, 11 Feb 2010 15:20:41 GMT

See this paper on SAS programming with EG:

http://support.sas.com/resources/papers/sgf2008/eguide.pdf

There is a small section that warns you on the dangers of ENDSAS.

Chris

Re: SAS EG and Vb Script

deleted_user — Mon, 29 Mar 2010 18:12:59 GMT

Won't it be a solution to your problem ?

Function Checkerror(fnName)
Checkerror = False

Dim strmsg ' As String
Dim errNum ' As Long

If Err.Number 0 Then
strmsg = "Error #" & Hex(Err.Number) & vbCrLf & "In Function " & fnName & vbCrLf & Err.Description
'MsgBox strmsg 'Uncomment this line if you want to be notified via MessageBox of Errors in the script.
Checkerror = True
End If

End Function

NB : For the complete vbs instruction see : http://support.sas.com/forums/thread.jspa?threadID=9182&tstart=0 Message was edited by: Fab.from.be