Dear all,
I'm have successfully schedule my program with EG, plus I getting idea from https://communities.sas.com/t5/SAS-Enterprise-Guide/Running-SAS-EG-Projects-sequentially/td-p/342843 to schedule few project in a sequence that I want by amended the vbscript, please see below which the schedule job run without any issue(at least in my view the task is perform without issue)
From
prjName = "C:\Users\XXXXXX\Desktop\Project1.egp" 'Project Name
To
prjPaths = Array("C:\Users\XXXXXX\Desktop\NewSchedule\PROJECT1.egp", "C:\Users\XXXXXX\Desktop\NewSchedule\PROJECT2.egp")
For Each prjName in prjPaths
The only issue for me is i have project which the name have space or path with space, like
path = C:\Users\XXXXXX\Desktop\New Schedule project name = PROJECT 1.egp
I have try to google but no luck and trying the code such as
"""C:\Users\XXXXXX\Desktop\NewSchedule\PROJECT 1.egp"""
"C:\Users\XXXXXX\Desktop\NewSchedule\""PROJECT 1.egp"""
Appreciated if you could guide/advise me the correct syntax to fix the above, thank you for your time and thank in advance.
Dear all,
Today i have tested the vbscript code below and it run without any issue, not sure why it failed at the begining.
prjPaths = Array("C:\Users\XXXXXX\Desktop\NewSchedule\PROJECT 1.egp", "C:\Users\XXXXXX\Desktop\NewSchedule\PROJECT 2.egp")
For Each prjName in prjPaths
Hope this help others.
Thanks for your time
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.