Hi All, I am trying to automate a process in SAS8.3 Enterprise guide and SQL database. My SAS program pulls the data from SQL Database, performs some Proc SQL & Data Steps and pushes the cleaned data back to SQL table. I want to automate this process and schedule it to run on a weekly basis. I tried basic scheduling of Enterprise Guide process flows and projects:-
“File” -> “Schedule Project” or click on “Schedule” the workspace and then select “Project” or “Process Flow”. This opened up my operating system scheduler and I am able to see my scheduled task but it never gets executed. Being a beginner in SAS , I am clueless about how to proceed further and possibly debug the situation.
If the task is scheduled in the scheduler then it is a scheduler issue. What does the scheduler display?
Ans what happens if you run y hand the command entered in the scheduler's task?
The scheduler just shows up the task as ready. please see the pic for reference
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.