Hey, I am still improving my SAS automation program. Currently, I am stuck with importing an xlsx file.
At first, I tried simply to run the complete process flow:
'Open the Enterprise Guide application and the project prjObject = app.Open(projectPath, "") prjObject.ContainerCollection.Item(processFlowName).Run()
But the file in the destination library doesn't get updated.
So I tried to explicitly run the task associated with files in the process flow:
For Each item As SAS.EG.Scripting.Element In prjObject.ContainerCollection.Item(processFlowName).Items() If item.Type = SAS.EG.Scripting.SASEGItemType.egFile Then Dim file As SAS.EG.Scripting.File = item If file.Tasks.Count > 0 Then For Each task As SAS.EG.Scripting.Task In file.Tasks task.Run() Next End If End If Next item
But also here, the file is not updated. The debugger shows me, that the log file for this tasked is empty (it was not prior to the run statement.)
I am using SAS EG 5.1 (5.100.0.12019) (64-Bit).
Any help would be appreciated!
Can you share which version of EG you're running? Exact version in Help->About?
There have been several hotfixes released since that version -- see this note for all of the available EG 5.1 fixes. I recommend applying those (just the latest one, which is cumulative) and seeing if that helps.
If the problem persists, I recommend that you open a ticket with SAS Technical Support.
I asked the IT to install the hotfix. Might take some time, though. I'll report as soon as the latest patch has been installed.
The problem persisted even with the latest hotfix installed. I raised a ticket with the technical support.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.