The  MS SQL varchar(max) supports upto 2 GB of data whereas the Viya varchar(*) can support upto 536,870,911 characters. That could be one reason for the issue. ... View more

During deployment cas and PostgreSQL accounts passwords are needed.  If they are changed later impact is a possibility. ... View more

Any restriction on the SAS side will be easy to bypass. Consider restricting at the SMTP server level. The mail server admin at your place could help. ... View more

Hello I have two questions regarding the upcoming SAS 9.4M9 1.When it is likely to be made available? 2. We are targeting to run our stored process server / web Application server with https during install process itself (rather than perform the post install configuration). I have reviewed the M8 document, but the process is not very clear about providing the SSL/TLS certificate. (or have I missed something?). Can you please guide. Needless to say I have SAS 9.4M9. Thanks, in anticipation. ... View more

Thanks @Tom , @SASKiwi  and @Patrick . for the quick response. I have a question about SAS/SHARE. I have the impression that it can provide shared connection to SAS Datasets. Does it work with RDBMS say for example Oracle, MS SQL Server etc.? ... View more

In order to use OAuth options, while configuring the ODBC manager select the Authentication Mechanism as OAuth2. The next step would be to fill the necessary Oauth2,HTTP and SSL  options as applicable at your place and you should be good. No authentication statement would be needed in the libname statement. ... View more

Hello We are also planning to upgrade from SAS 9.4M6 to (preferably) SAS 9.4M9. Did watch the presentation by  @MargaretC  Wood appreciate if somebody can guide to more specific information than in the presentation or that at https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/whatsdiff/upgradeswhatsnew94.htm Thanks ... View more

Thanks @XavierBizoux  I tried running the python code from the reference   https://docs.aws.amazon.com/secretsmanager/latest/userguide/retrieving-secrets-python-sdk.html .  I have installed boto3. I am getting the following error  Any suggestions? ... View more

Hello I executed the following code (solution from the forum post   Solved: PROC DATASETS "WARNING: No matching members in directory." - SAS Support Communities ) data _null_; set sashelp.vtable(where=(libname='LIBDBRK' and MEMTYPE='DATA')) nobs=obs; if (obs > 0) then rc = dosubl('proc datasets lib=libdbrk memtype=data kill NOLIST NOWARN;run;quit;'); run; and this gave the following log 80 data _null_; 81 set sashelp.vtable(where=(libname='LIBDBRK' and MEMTYPE='DATA')) nobs=obs; 82 if (obs > 0) then 83 rc = dosubl('proc datasets lib=libdbrk memtype=data kill NOLIST NOWARN;run;quit;'); 84 run; NOTE: There were 0 observations read from the data set SASHELP.VTABLE. WHERE (libname='LIBDBRK') and (MEMTYPE='DATA'); NOTE: DATA statement used (Total process time): real time 1.59 seconds cpu time 0.03 seconds 85 86 /* region: Generated postamble */ 87 /* Close ODS destinations */ 88 &graphterm; ;*';*";*/;run;quit; 89 quit;run; 90 ods html5 (id=web) close; 91 ods listing close; 92 %if %sysfunc(fileref(_gsfname)) lt 0 %then %do; 93 filename _gsfname clear; NOTE: Fileref _GSFNAME has been deassigned. 94 %end; 95 %studio_capture_custom_output; 96 /* endregion */ 97 Wondering if I need to make any changes to my libname statement as mentioned in the previous post? ... View more

Hello I have been able to successfully connect using the following code libname libdbrk jdbc preserve_tab_names=yes schema=catalog.schema class="cdata.jdbc.databricks.DatabricksDriver" URL="jdbc:databricks:Server=abcd-efgh.cloud.databricks.com:443;HTTPPath=/sql/1.0/warehouses/1234567890; Token=Personal_Access_token;" While the library is successfully created, cannot see any tables. I ran the proc datasets as follows proc datasets lib=libdbrk; run; The log has proc datasets lib=libdbrk; WARNING: Execute error: Directory Libref LIBDBRK Engine JDBC Physical Name jdbc:cdata:Databricks:Server=abcd-efgh.cloud.databricks.com:443 Schema catalog.schema WARNING: No matching members in directory. 81 run; Looking to the community for guidance. Thanks ... View more