this behaviour sounds like "startup" settings being used by the first SAS session persist over all sessions.
Need to find a way to start a new session each time.
This behaviour could be similar to the distinction of "stored process servers" and "workspace servers" in SAS BI platform.
In EG, just disconnecting from the server ensures the next code submitted will run in a new session.
Is there a way though to insert insert a macro variable into an open and existing project?
' This VB.NET code runs my SAS code wonderfully but need a way to pass parameters in!!
Dim appMain as New SAS.EG.Scripting.Application
Dim prjMain as New SAS.EG.Scripting.Project
Dim prjName as String
prjName = "mysasegproject.egp
appMain.Open(prjMain.ToString, "")
prjMain = appMain.Project()
prjMain.Run()
Is there any way to insert a macro variable into this code logic so my project can use it?
I tried using Windows environmental variables and having my SAS EG project read them. That works BUT the environmental variables are "sticky" and cannot be changed if your code runs multiple iterations.
Any ideas would be greatly appreciated.
Thanks,
Lou
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.