@Patrick - I haven't seen that behaviour in the versions we use, the oldest being 9.4M2. We in fact use SQL Passthru a lot, and that is most commonly where our programs break. Following an SQL Passthru error we typically see an SQL connection CLI error, SYNTAXCHECK mode switches on and the rest of the program finishes quickly as no further data is processed. ... View more

@quickbluefish - What I typically ensure with %INCLUDE chained jobs is that the SAS OPTION SYNTAXCHECK is set. This is set by default for batch jobs anyway. With this option an error still results in ALL code still running, including the %INCLUDE programs, but no data is processed as OBS = 0 has been set. This means failed jobs finish quickly but still contain complete logs which in my view is ideal for troubleshooting. ... View more

If you restructured your programs so that you just scheduled / ran one controlling program that used the %INCLUDE statement to run the others then this would fix your problem. ... View more

It depends what you mean by a downside. I've highlighted the major difference - you need to upgrade at least every three months to maintain standard support versus every two years with LTS.  ... View more

Are you having to do all of the data sourcing for this dashboard or is that already available? In my experience it can take longer to assemble and organise the required data than to build a dashboard. Also VA reports typically require a lot of prototyping figuring out what report objects work best and getting a good layout design.   I am doubtful Gen AI can help here as you can't accurately and fully define your requirements to start with.   ... View more

There must be an issue with your syntax then. Please post your complete SAS log if you want further help. ... View more

That is not a SAS ERROR, it is a SAS NOTE:   NOTE: A CASE expression has no ELSE clause. Cases not accounted for by the WHEN clauses will result in a missing value for the CASE expression.   Your program will continue to run OK. If you want to avoid these notes then just add an ELSE.   ... View more

How do you start your batch jobs? If you run them via a scheduler, then typically schedulers have a stop job feature.   ... View more

Talk to your SAS administrator and ask him to check the SAS metadata server logs for any clues regarding the dropped connections. What is your current EG version?  I too doubt it is an EG version issue otherwise it would be widely reported.    Is it specific to certain programs or does it impact all programs? ... View more

 I've found that the easiest way to supply SAS data to Power BI is via SQL Server. In my experience, most Power BI users have SQL Server available as a data source, so it is very easy to use SAS 9.4 SAS/ACCESS to SQL Server or SAS Viya 4 SQL Server connector to get data from SAS to Power BI.      ... View more

@Vic3 - Have you tried the clipboard tweak described earlier in this post? ... View more

You can only list tables in an SQL Server database via a SAS LIBNAME if you provide correct database and schema names. Without these set the LIBNAME will assign correctly at the server level but can only be used in a limited way like with SQL Passthru for example. Here is one way: libname sqlsrvr odbc noprompt = "server=MyServerName;DRIVER=ODBC Driver 18 for SQL Server;Trusted Connection=yes;"; proc sql; connect using sqlsrvr; create table Want as select * from connection to sqlsrvr (SELECT * FROM [MyDatabase].[MySchema1].[MyTable] A LEFT JOIN [MyDatabase2].[MySchema2].[MyTable2] B ON A.Key1 = B.Key1 ) ; quit; ... View more

Also Java is quoted as being a memory-safe language but in my experience SAS is forever providing memory vulnerability patches for JRE...    I can't see SAS moving away from using C and C++ as the cost and resources for doing so would be astronomical. Back in the day some early versions were written in PL1 and there was a huge effort with SAS Version 6 to convert it to C / C++. ... View more

I've never used PROC S3 / AWS. The advice I posted was from SAS documentation. If the link I provided doesn't help then I'd suggest opening a track with SAS Tech Support.  ... View more