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 ?    ... View more

I have an Export Step in my SAS EG Project to create a .csv file in a Network location.  When triggering the job manually it works perfectly fine.   I am trying to set up an automated job instead of running it manually using the Scheduler (i.e. using a vbscript). However, I get the following error:    The open data operation failed. The following error occurred. Could not find a part of the path 'F:\path\to\my\file.csv'. The F: drive is a network drive. It could most likely be that the F: is not accessible in the session context started by the vbscript and that it is accessible in the normal interactive one (when I trigger it manually). Therefore, my question is: Is there a way to map the F: drive in the vbscript ? Obviously, if a better solution than tweaking the vbscript exist, I will be more than happy to hear it.    ... View more

I am trying to update an oracle table. I encounter this error when running the following data step: data oracle.have(drop=_:); modify oracle.have end=last; if _n_=1 then do; declare hash h1(dataset:'update'); declare hiter hh1('h1'); _rc = h1.defineKey('id','tid','valid_to'); _rc = h1.defineData('valid_from'); _rc = h1.defineDone(); end; if h1.find()=0 then do; replace; _rc = h1.remove(); end; run; ERROR: File ORACLE.HAVE.DATA is sequential. This task requires reading observations in a random order, but the engine allows only sequential access. I assume this is because of the modify statement... Is there any way to bypass this error ? The only actual way I found to this day is to use proc sql with an update statement. ... View more