Hi Everyone,   can someone enlighten me, as of why the Flow Editor is not being installed, when setting up Platform Suite for SAS including SAS Process Manager?    Reading the PM User's Guide from IBM,    it states, that there are THREE applications: I know, that flows are created by using the Schedule Manager Tab in SMC. But why can I not alternatively choose LSF Flow Editor?   Cheers, FK1 ... View more

Hi Folks,   I do have a problem with the datasource (driver ???): when firing this SAS code: LIBNAME DATAMART sqlsvr schema='SAS_DATAMART' INSERTBUFF=32767 READBUFF=32767 DBCOMMIT=0 Datasrc=SAS_ACCESS_TREIBER; proc freq data=DATAMART.CIContact; table CompanyCode; run; I get the following error: ERROR: ERROR: [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Incorrect syntax near 'SAS_DATAMART'. ERROR: ERROR: [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]The batch could not be analyzed because of compile errors.   However, when using the other datasource in the Libname Statement, everything works fine:   LIBNAME TSQL sqlsvr schema='SAS_DATAMART' INSERTBUFF=32767 READBUFF=32767 DBCOMMIT=0 Datasrc=MICROSOFT_SQL_TREIBER; proc freq data=TSQL.CIContact; table CompanyCode; run; The reason, I have two similar datasources defined is, that we are using SAS Marketing Automation and we found out, that the performance on the database is much better when using SAS Access Driver from Data Direct (s0sqls27.dll) rather than using ODBC Driver 17 for SQL Server from Microsoft.   Unfortunately, it seems as if SAS Access driver causes troubles when using "outside" of SAS Marketing Automation context!   Could I change something regarding the datasourve definition via Windows ODBC Admin Client in order to make the whole thing work?   ... View more

Hi Folks,   back in the 7.x versions of EG I could select two *.sas programs in EITHER the Project Tree or Process Flow of Enterprise Guide and right click and click "compare". Then Winmerge would do the code comparing (see:  https://blogs.sas.com/content/sasdummy/2015/04/03/compare-sas-programs-in-sas-enterprise-guide/ )   In SAS Enterprise Guide 8.2 Update 1 (8.2.1.1223) (64-bit), which I am using now, I can only do the comparisson, when navigating to the Process Flow. In the Project Tree context menu, when right clicking, I do not get the "compare" option. Do I have to adjust some option in order to get the option, or has it just "moved" to the Process Flow? These are the options I am being shown, when slecting two programs in the Project Tree:         ... View more

Hi Everyone,   when connecting to our Microsoft SQL Database via "SAS/ACCESS Interface to Microsoft SQL",  SAS uses the installed Progress DataDirect Microsoft SQL Server Wire Protocol ODBC driver component. (https://www.progress.com/odbc/microsoft-sql-server)         I noticed, that the "S0SQLS27.DLL" being used, is dated Novermber 21st, 2018. So my first question would be: Is this still the up-to-date-driver, I should use?   And the other question is: why is a 32 bit driver used, even though, I am running SAS on Windows 2016 Server 64bit?   This is, how the odbc.ini looks:     Thx, FK       ... View more