topic Re: SAS Enterprise Guide with VBScript. Looping through SAS programs get stuck. in SAS Enterprise Guide

SAS Enterprise Guide with VBScript. Looping through SAS programs get stuck.

traldim — Tue, 07 Jan 2020 17:40:24 GMT

Hello everyone.

I'm facing a random problem. When executing SAS programs with VBScript and the

SASEGObjectModel.Application.7.1, looping through

CodeCollection get stuck sometimes, even if the program execution was succeeded (the final data bases are correctly created in our server). The script simple doesn't go to the next program of CodeCollection (the prompt executing the script still open... ad infinitum). I'm going with something like this:

Dim oSasApp
Set oSasApp = CreateObject("SASEGObjectModel.Application.7.1")
oSasApp.SetActiveProfile("some-profile")

Dim oSasProj
Set oSasProj = oSasApp.Open("some-project.egp", "")

Dim oProgramList
Set oProgramList = oSasProj.CodeCollection

Dim programOrder
Set programOrder = ...here I assign the SAS programs order array reading from a .txt...

For Each program in programOrder
       For Each sasProgram in oProgramList
              If sasProgram.Name = program Then
                     sasProgram.Run
                     sasProgram.Log.SaveAs "some-folder/" & sasProgram.Name & ".txt"
              End If
       Next
Next

oSasProj.Close
oSasApp.Quit

The problem is not the Log saving, as the log txt file of the stucked program is also correctly created.

Any idea? Maybe problems in our SAS server? Should I declare some kind of options?

SAS Guide version: 7.15
Windows: 10

Re: SAS Enterprise Guide with VBScript. Looping through SAS programs get stuck.

traldim — Tue, 07 Jan 2020 17:44:23 GMT

...the SAS program it stucks is random and also the frequency it happens.

Re: SAS Enterprise Guide with VBScript. Looping through SAS programs get stuck.

ChrisHemedinger — Tue, 07 Jan 2020 18:22:55 GMT

I suggest that you turn on Application Logging (in Tools->Options). This will create a CSCRIPT.nnnn.log file in your user profile area that contains lots of diagnostic info. You might not be able to interpret it yourself, but if you track it with SAS Tech Support and supply a log file that represents when this problem occurs, the development team might be able to diagnose.

Re: SAS Enterprise Guide with VBScript. Looping through SAS programs get stuck.

traldim — Wed, 08 Jan 2020 21:10:48 GMT

That is good info Chris.

Just found out something that changes erverything and makes the problem simpler: if I press enter on prompt the script flows again. So it is waiting for my input. Can't understand why as I did't code anything for that in the .vbs file. Must be something with SAS Enterprise Guide. The data bases I'm manipulating are preatty big, the main programs takes something like 7 hours to run. I'm thinking if SAS Guide is asking anything to goes on. Maybe something related to the data size? Any idea what could be?

Tnks

Re: SAS Enterprise Guide with VBScript. Looping through SAS programs get stuck.

ChrisHemedinger — Wed, 08 Jan 2020 21:14:36 GMT

Is there a prompt displayed? Or in the command-line console?

Re: SAS Enterprise Guide with VBScript. Looping through SAS programs get stuck.

traldim — Wed, 08 Jan 2020 21:20:55 GMT

Nothing displayed on command line. I pressed enter by luck. When running directly with SAS Guide app something it prompts messages saying the log is too long, or that results are too long, asking for my OK (not sure about the messages). I'm thinking in something like that.

Re: SAS Enterprise Guide with VBScript. Looping through SAS programs get stuck.

ChrisHemedinger — Wed, 08 Jan 2020 21:33:36 GMT

Hmm, I see. You can try modifying the options in Tools->Options and bump these thresholds:

Results->General, Prompt before opening results -- change to a high number like 50MB. I think that applies to ODS and logs.

Also, you should consider tweaking your options and/or code to produce more concise results. Generate graphs? Look at whether you are using the ActiveX device (large if you have graphs with lots of points). And how verbose is your log output?

And if you use the Project Log, change those properties for your project. Right-click on the Project name in your project tree, select Properties, then Project Log.

Re: SAS Enterprise Guide with VBScript. Looping through SAS programs get stuck.

traldim — Fri, 17 Jan 2020 13:58:36 GMT

For people facing the same problem, I did 2 things to get around it. Not sure if all of them are necessary or if only one solves it, but here it goes:

First, by VBScript I turned off a list of generations and I applied a delay after the SAS program runs:

For Each program in programOrder
       For Each sasProgram i oProgramList
              If sasProgram.Name = program Then
                     sasProgram.GenSasReport = False
                     sasProgram.GenHTML = False
                     sasProgram.GenListing = False
                     sasProgram.GenPDF = False
                     sasProgram.GenRTF = False
                     sasProgram.Run
                     WScript.Sleep(2000)
                     sasProgram.Log.SaveAs "some-folder/" & sasProgram.Name & ".txt"
              End If
       Next
Next

Them, in my batch file, wich I use to call the VBScript with the "cscript" command, I set it to apply "y" to every single message the VBScript could ask:

cd ./script-folder
echo y | cscript script-file-name.vbs

And that is it.