Hi all, Just want to know if anyone has experience using SAS Studio to create a master flow and then run multiple sub-flows to make the master flow as the Job scheduler to run its sub-flows.    My question is how to set the job dependency of these sub-flows (seems that swimlanes is a good starting point) but want to know how to execute two sub-flows in parallel if the up-stream flow is completed.   Viya Job and Execute is not suitable for this implementation, and we do not have a plan to install a third-party scheduler like Airflow in our environment.   Regards, Eddie   ... View more

Dear colleagues,   I would like to know if you have any experience using SAS9 and Viya4 to access databases and tables that are hosted in SQL Server's Linked Server.   In other words, can we have a library definition (i.e. libname statement) to access tables in a Linked Server?   Please kindly share your know-how or KB documents that confirm it is not a supported feature.   Thank you very much.   Eddie   ... View more

Dear colleagues,   Although my question is related to an old Viya3 system on Windows, but I would like to understand more the nature of the file.   I noticed that there are a large number of hidden files _B__T_F*.sashdat in the CASLib data path. I can't recognise the file name and its nature. Does anyone know what it is? As the last modified date of the files is over a year before, can I delete them safely?    Any special handling we need to take care of if we want to migrate to Viya4?     ... View more