SAS Support Communities

SASKiwi

@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;

SASKiwi

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:

SASKiwi

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.

SASKiwi

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.

SASKiwi

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.

SASKiwi

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.

SASKiwi

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.

SASKiwi

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.

SASKiwi

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

SASKiwi

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

SASKiwi

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;

SASKiwi

If that is where EG is installed, that is where you schedule your EG project.

SASKiwi

Where is EG currently installed?

SASKiwi

Here is a link to the doc explaining how you schedule EG projects. Note EG projects can only be scheduled on the computer where EG is installed. You could also use the help menu in your version of EG - search for automating projects.

SASKiwi

This is the answer I got when I asked Google: You will need to provde more details regarding your specific requirements.

Online Status	Offline
Date Last Visited	Monday

SAS Support Communities

Follow Us

What is...