@thesasuser - Why the need to share external database connections as @Patrick has already asked? Personally I've never encountered any recent issues with every SAS user having their own connections, especially with the high performance of modern networks. ... View more

@epower  - We use SAS 9.4 and Enterprise Guide with local repositories. These are managed by MS Visual Studio, totally independent of SAS. Using MS VS Solution Explorer you can double-click on a program to open it in EG. Saving a program in EG updates it in the local repository. Alternatively if your local repo is available via a Windows share, opening the program into EG via Windows Explorer is also possible.  ... View more

Looks like you are joining a SAS table with a Teradata table. If that is the case then neither SQL example is likely to be very efficient as the whole Teradata table has to be extracted to the SAS server before it can do the join with the SAS table.  ... View more

The way most users interact with SAS 9.4 is to start a SAS Workspace Server session dedicated to each user. You can't pool database connections across each user's sessions. To be able to pool external database connections between users you would need a shared SAS server that runs continuously and as @Tom  has mentioned SAS/SHARE is probably your only option, plus use the options CONNECTION = GLOBAL on your LIBNAME statements. That obviously means you would need to both install and license it. IMHO that seems like overkill just to support connection pooling.  ... View more

@npm_sas  - What database are you connecting to? For some databases like SQL Server you can use IWA - Integrated Windows Authentication (Trusted Connection=yes) like this and avoid any user credentials: libname SQLSRVR odbc noprompt = "server=SQLServerName;DRIVER=SQL Server Native Client 11.0;Trusted Connection=yes" DATABASE = MyDatabase schema = dbo;    ... View more

I'm pretty sure that functionality was dropped from EG 7.x. If no node / code is selected all nodes / all code is run. If a certain node(s) / code block is selected then only the selections are run. There is now only the one option on the Run icon:       ... View more

Open the CSV file in a text editor like Notepad++ and look for malformed rows. Embedded carriage returns in text columns is one reason why this can occur. If the CSV is small and there are only a few rows to fix then manually editing it then reimporting it is the quickest approach.  ... View more

From the documentation: In SAS 9.4M5, the ODS EXCEL statement supports the following options: TAGATTR= style attribute SHEET_INTERVAL= NOW You need to be using at least 9.4M5 to use NOW. ... View more

I recommend trying the CPORT and CIMPORT procedures for migrating SAS catalogs. What issues do you have with SAS programs? These are normally just stored in text files so there should be any problems reading them  on your Windows 11 PC. ... View more

What scheduling server are you using? If you are using Platform Process Manager / LSF, then there are housekeeping tasks you can do to see if that reduces delays. It's also possible you might be reaching some configuration limit on simultaneous flows and new ones only start when current ones complete. I recommend you open a Tech Support track to investigate further. ... View more

We need evidence as to what is the problem otherwise we can only guess - get one of the users for whom the autoexec is not working to run the same LIBNAME manually. Post the complete SAS log including any errors. ... View more

You will get more useful answers if you post the actual SAS log of your program including notes rather than posting code that contains a syntax error. ... View more

Wouldn't it just be a lot easier to use the Control-M user interface? ... View more

Are you running PROC MEANS directly against a DBMS table as the option only applies to external database tables? ... View more

I would first suggest you check what your SAS Viya session setting is for this option: proc options option = dbclient_max_bytes; run; Then try increasing it 1 byte at a time.    There maybe other encoding options worth trying like: data MyOraTable (encoding = wlatin1); set MyOraLIB.MyOraTable; run;   ... View more