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

You really need to provide more details of what you are doing and not just mention some obscure config file. I'm going to guess that you are accessing an Amazon S3 cloud platform. If so and you are using PROC S3 then you can specify the TKS3 CONFIG like so: Going by the example you could just create dev, intg and uat folders (/u/marti/dev/.tks3.conf) each with their own config file then refer to them as above. ... View more

@thesasuser - I suspect the main cost implication would be increased memory usage as each compute server instance will consume memory regardless of whether it has been used or not. I wouldn't expect CPU usage to change much as the overhead of starting a compute server would be low compared to when it is used for processing. ... View more

As I understand it this is the key issue from the above:   "A compute context you configure to have pre-started available compute servers must run those compute servers under a shared service account"   This service account must be defined in the OS (via LDAP etc)  as OS processes are run under it. In any case there is no equivalent of internal accounts in Viya because there is no equivalent of SAS 9 metadata repositories. ... View more

Is this a recent problem and they all used to work OK? If so then what might have changed? The jobs that hang - do they sometimes work or do they always hang? How are you running these jobs in SAS - via EG, SAS Studio, SAS Windowing System, or batch?      Given there is very little evidence to work with, opening a Tech Support track is probably your best option if you haven't already done so. ... View more

Getting an official response from SAS Tech Support by opening a support track is the best option here for such a specialist topic. ... View more

Getting exactly the same error doesn't necessarily mean the same cause and solution applies. As already mentioned, opening a Tech Support track is the best way to make progress. ... View more

Usually companies have default backup procedures for all permanent on-premises storage. My company does. Find out from your storage experts what they are - daily, weekly, monthly, incremental or full. The key thing is to ensure all SAS server permanent storage is backed up, including SAS applications and the data for these. Exclude SAS temporary storage from being backed up.   You should really have a discussion with your management regarding backup policy. There may already be backup standards in your company that you need to adhere to. That's certainly the case with mine and we walked through the requirements at the server design stage. ... View more

If you haven't done so already Tech Support is your best way to progress this. You can open a track online here: https://service.sas.com/csm   Database connection setup is tricky and sometimes requires a lot of troubleshooting. ... View more