About thesasuser

thesasuser · ‎06-13-2025

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

Sajid01 · ‎06-04-2025

Hello Connection pooling is something I saw in the java world. Creating library definitions in the metadata server and pre-assigning would serve a similar purpose, though they are not the same.

SASKiwi · ‎05-28-2025

No that isn't possible. If you highlight a section of code and press the run button it has the same effect as run selection. The Run / Run selection functions have been combined.

thesasuser · ‎05-14-2025

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.

SASKiwi · ‎04-29-2025

@thesasuser - Not sure what you mean by "more specific information". There are a lot of resources under your posted link that you need to work through before you decide what your upgrade strategy will be. You may also want to engage with your SAS Account Manager if you want to take advantage of SAS's free installation sizing service or to engage specialist installation and / or migration help. Key decisions need to be made regarding whether you want to keep your existing server infrastructure, architecture and OS or if you wish to change it. Any significant change here will likely require a brand-new install plus migration effort rather than an upgrade in place. I highly recommend you use SAS's Content Assessment tool for evaluating your current SAS infrastructure - you will see the documentation for that in your posted link.

SASKiwi · ‎04-29-2025

What type of SAS upgrade? SAS 9.4 maintenance level upgrade or something else? I don't think there is any batch-style way of doing this. However, given EGP files are simply zip files, it should be easy enough to use a zip tool to open them, then use "find-and-replace" tools like Notepad++ to make the required changes.

XavierBizoux · ‎03-28-2025

Hi, I'm not an expert with AWS Python SDK. The code for get_secret_value can be found here. You should most probably define the class in your code and then use that class. Let me know if that helps. If not, you may ask for help on the AWS repository itself. Regards, Xavier

thesasuser · ‎03-05-2025

Thanks everyone for your help and support. The issue was resolved with the help of SAS Tech Support. Thanks SAS Tech Support for the solution. The issue was that I was using the jdbc engine whereas SAS Access Interface to Spark provides connectivity to Databricks. The details are given here SAS Help Center: Support for Spark on the SAS Viya Platform. Look for the section on Databricks. One would need the details about server, httpPath and PersonalAccessToken among other things.

gwootton · ‎02-25-2025

The sas-cas-operator is an operator, which is responsible for standing up the CAS server pod(s) based on the provided definition in the casdeployment resource object. We have operators for other services that work similarly. The sas-cas-control pod is a service pod that interacts with the CAS server after it has started, translating REST requests made to the service into CAS server instructions.

gwootton · ‎02-10-2025

No, this is a staging location as part of the deploy web applications process, they are not being used outside of that process. As I understand it when you run the "Build Web Applications" task, the WAR/EAR files are generated into Web/Staging, and in the "Deploy Web Applications" the web app servers are stopped, the WAR/EAR files are extracted to Web/Staging/exploded then those extracted files are copied to SASServerX_Y/sas_webapps, and then the web app servers are started again.

MJMA · ‎02-03-2025

Hi @ScottMcCauley , Is this process valid if I use the GitHub projects (both, IaC and DaC)? Thanks!

thesasuser · ‎01-29-2025

Hello Thanks for showing to create caslib to an external data source of Hadoop. How can we modify the the following for Oracle? caslib hivelib desc="HIVE Caslib" datasource=(SRCTYPE="HIVE",SERVER="gatekrbhdp01.gatehadoop.com", HADOOPCONFIGDIR="/opt/sas/hadoop/client_conf/", HADOOPJARPATH="/opt/sas/hadoop/client_jar/", schema="default",dfDebug=sqlinfo) GLOBAL ;

Kurt_Bremser · ‎01-24-2025

Does this help: https://answers.microsoft.com/en-us/windows/forum/all/how-do-i-disable-windows-hello-for-logging-into/2a97c1e4-52ba-4053-9ae4-5922905b623b

andreas_lds · ‎01-24-2025

Maybe the windows event log contains something useful.

SP7 · ‎01-16-2025

Depending on the workload, you might need to configure different storage classes for these volumes. For instructions about how to configure a different storage class, see the README file at $deploy/sas-bases/examples/sas-programming-environment/storage/README.md (for Markdown) or $/deploy/sas-bases/docs/sas_programming_environment_storage_tasks.htm (for HTML).

Online Status	Offline
Date Last Visited	Wednesday

Re: SAS grid on SAS 9.4 Master Batch baemon and master batch scheduler...

SAS grid on SAS 9.4 Master Batch baemon and master batch scheduler not...

Establishing connection to Databricks workspace from SAS 9.4

Re: Why does SAS randomly report "Library WORK does not exist" during ...

Stored process error in SAS 9.4 :Fixed prompt requires a default value...

Re: Provisioning persistant volume for SAS Viya4 on openshift cluster

Provisioning persistant volume for SAS Viya4 on openshift cluster

Re: setting sas.logon.initial password in sitedefault.yaml during SAS ...

setting sas.logon.initial password in sitedefault.yaml during SAS Viya...

Moving to the next course in SAS Viya Deployment Subscription

Re: Why does SAS randomly report "Library WORK does not exist" during ...

Re: Getting Oracle engine cannot be found even after SAS/ACCESS Interf...

Re: Connect to SAS Grid with SAS ODBC Driver

Re: Connect to SAS Grid with SAS ODBC Driver

Re: Updating the contents of SAS EG Project (*.egp) in batch mode

setting sas.logon.initial password in sitedefault.yaml during SAS Viya...

Re: Assistance Needed for Upgrading SAS 9.4 M6 to M8 version.

Re: Resetting/Update password of SAS OS accounts

Re: Email sending restriction

Re: ODBC Connection from SAS 9.4 M6 on Windows Server Cannot see tabl...

Re: Resetting/Update password of SAS OS accounts

Re: Connection pooling to external database in sas 9.4

Re: SAS EG 8.4 : Right click and run selection on SAS App

Re: ODBC Connection from SAS 9.4 M6 on Windows Server Cannot see tabl...

Re: Assistance Needed for Upgrading SAS 9.4 M6 to M8 version.

Re: Updating the contents of SAS EG Project (*.egp) in batch mode

Re: Extracting token from AWS Secrets using Proc Http

Re: Connecting to Databricks using JDBC from SAS Viya 4

Re: SAS-CAS_Control and SAS-CAS-Operator

Re: Files in the exploded folder after rebuilding web applications

Re: Using the SAS Configurator for Open Source to Build Python and R

Re: SAS® Viya™ Caslib

Re: Authentication to Stored Process Web Interface using Windows Hello

Re: Failed login to stored process server

Re: Running datastep code in Viya4. Is there a limit on pod size