ERROR: Unable to get SAS code. Unable to find the specified file.

KermitTheFrog — Wed, 05 May 2021 07:41:21 GMT

I am using the "Schedule Task" option with SAS EG (with the VBScript) to run a project during the night.

When running it manually it works perfectly, however when it is using the Scheduler, every morning the same error appears:

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %put ERROR: Unable to get SAS code. Unable to find the specified file.;
ERROR: Unable to get SAS code. Unable to find the specified file.
4          
5          QUIT; RUN;

I checked the VBScript and the path to the file seems right.

Option Explicit
Dim app         ' As SASEGuide.Application

Call dowork

'shut down the app
If not (app Is Nothing) Then
    app.Quit
    Set app = Nothing
End If


Sub dowork()
    On Error Resume Next
    '----
    ' Start up Enterprise Guide using the project name
    '----
    Dim prjName     ' As String
    Dim prjObject   ' As SASEGuide.Project
    Dim containerName     ' As String
    Dim containerObject   ' As SASEGuide.Container
    Dim containerColl     ' As SASEGuide.ContainerCollection

    prjName = "F:\path\to\my\file.egp" ' Project Name
    containerName = "Process Flow" ' Container Name
      
    Set app = CreateObject("SASEGObjectModel.Application.8.1")
    If Checkerror("CreateObject") = True Then
        Exit Sub
    End If
    
    Set prjObject = app.Open(prjName,"")
    If Checkerror("App.Open") = True Then
        Exit Sub
    End If
    
        
    '-----
    'Get The Container Collection and Object
    '-----    
    Set containerColl = prjObject.ContainerCollection
    If Checkerror("Project.ContainerCollection") = True Then
        Exit Sub
    End If
    
    Dim i       ' As Long
    Dim count   ' As Long
    count = containerColl.count
    For i = 0 To count - 1
        Set containerObject = containerColl.Item(i)
        If Checkerror("ContainerCollection.Item") = True Then
            Exit Sub
        End If
        
        If (containerObject.Name = containerName) Then
            Exit For
        Else
            Set containerObject = Nothing
        End If
    Next 
    
    If not (containerObject Is Nothing) Then
        '----
        ' Run the Container
        '----
        containerObject.Run
        If Checkerror("Container.Run") = True Then
            Exit Sub
        End If               
    End If
                
    '-----
    ' Save the new project
    '-----
    prjObject.Save
    If Checkerror("Project.Save") = True Then
        Exit Sub
    End If
    
    '-----
    ' Close the project
    '-----
    prjObject.Close
    If Checkerror("Project.Close") = True Then
        Exit Sub
    End If
       
End Sub

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

Am I missing something ?

Re: ERROR: Unable to get SAS code. Unable to find the specified file.

ChrisNZ — Wed, 05 May 2021 07:49:03 GMT

It looks like the F: drive is unavailable to the scheduler.

This about why this could be the case on your machine,

A common reason is that it's a network drive unauthorised to the user chosen to run the batch job.

Re: ERROR: Unable to get SAS code. Unable to find the specified file.

ChrisNZ — Wed, 05 May 2021 07:50:30 GMT

Also: Maybe use the UNC oath instead of a mapped drive letter.

Mapping drives is best avoided, it creates all sorts of problems.

topic Re: ERROR: Unable to get SAS code. Unable to find the specified file. in SAS Programming

ERROR: Unable to get SAS code. Unable to find the specified file.

Re: ERROR: Unable to get SAS code. Unable to find the specified file.

Re: ERROR: Unable to get SAS code. Unable to find the specified file.