thesasuser Tracker

Sending emails from SAS Viay4 on AWS using Oauth2 and Microsoft graph and Excel files as attachment

thesasuser — Fri, 03 Apr 2026 21:11:29 GMT

Hello
I have been trying to send emails with excel files as attachment using SAS code from SAS Viya4 on AWS.
Sending of email using Oauth2 and Microsoft graph is the method we are expected to use.
(SMTP approach is no more allowed).
One can send emails but when an excel file is attached, it file is restricted to 270 bytes. The file is simply unusable.
The relevant portion of the code are attached.
There are no error in the log and get the message "NOTE : 202 ACCEPTED.
Request the community for guidance.
The code is as given below.


/* Step 1: Base64 encode the XLSX file */
filename myfile "/mnt/viya-share/data/test/cars.xlsx";
filename b64file temp;

data _null_;
    infile myfile recfm=n;
    file b64file lrecl=32767;
    input byte $char1.;
    put byte $base64x1. @@;  
run;
/* Step 2: Build JSON email payload */
filename mailbdy temp;

/* Write JSON header */
data _null_;
    file mailbdy;
    put '{';
    put '  "message": {';
    put '    "subject": "Test email from SAS Viya 4",';
    put '    "body": { "contentType": "Text", "content": "Hello from SAS Viya!" },';
    put '    "toRecipients": [ { "emailAddress": { "address": "recipient@example.com" } } ],';
    put '    "attachments": [';
    put '      {';
    put '        "@odata.type": "#microsoft.graph.fileAttachment",';
    put '        "name": "cars.xlsx",';
    put '        "contentType": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",';
    put '        "contentBytes": "';
run;

/* Append Base64 content directly */
data _null_;
    infile b64file lrecl=32767;
    file mailbdy mod;
    input;
    put _infile_;
run;

/* Close JSON */
data _null_;
    file mailbdy mod;
    put '"';
    put '      }';
    put '    ]';
    put '  },';
    put '  "saveToSentItems": "true"';
    put '}';
run;

/* Send via microsoft Graph */
/* Step 3: Send email via Microsoft Graph */
filename sendresp temp;

proc http
    url="https://graph.microsoft.com/v1.0/users/sender@example.com/sendMail"
    method="POST"
    in=mailbdy
    out=sendresp;
    headers
        "Authorization"="Bearer &access_token"
        "Content-Type"="application/json";
run;

Anonymous http -post request to SAS Viya4

thesasuser — Mon, 23 Feb 2026 13:57:53 GMT

Hello

We are using SAS 9.4 environment to process http post request from within the organization.
These requests are anonymous (i.e.,no user authentication needed). The response (json/xml) is generally delivered in 500-700 milli-Seconds.
The requests originate from non SAS processes.
We are exploring the possibility of moving this process to Viya4 and have set a test process using postman. This is a two step process. Authentication itself takes 2+ seconds.
Wondering if there is a way to by pass the authentication.

Understanding the difference between TLS certificates in Viya

thesasuser — Tue, 17 Feb 2026 17:35:31 GMT

Hello
While working on configuration of SAS Viya4 for using customer provided ca certificates, I came across these terms.
trustedcerts.pem, sas-ingress-certificate.pem, sas-ingress.key and sas-ingress-CA-certificate.pem.
Wondering if some one can help me understand these terms?

Re: Error in SAS Viya4 on Openshift cluster using manual method

thesasuser — Sat, 07 Feb 2026 18:01:59 GMT

I chose to deploy using the deployment operator method as detailed here and it worked.
SAS Help Center: SAS Viya Platform: Deployment Guide

Deploying sas-deployment-operator on Open Shift in namespace mode

thesasuser — Fri, 30 Jan 2026 14:08:55 GMT

Hello
We are exploring options to deploy SAS Viya 4 in a name space mode either manually or using deployment-operator/ SAS-Orchestration utility on a OpenShift Cluster.

One thought is to deploy the deployment-operator in name space mode.
Wondering if anyone in the SAS community has experience in this and can share their thoughts?
Thanks

Error in SAS Viya4 on Openshift cluster using manual method

thesasuser — Tue, 20 Jan 2026 19:21:00 GMT

Hello
I have been trying to deploy SAS Viya4 on open shift using the manual method ( SAS Help Center: Deploy the Software , https://learn.sas.com/course/view.php?id=6945 )
I get stuck up at this step:
oc apply --selector="sas.com/admin=namespace" -f site.yaml --prune
The output says "error: no objects passed to apply"
Wondering if anybody can enlighten/guide on this?
Thanks

SAS Viy4 deployment using Kubernetes : Clusterwide and cluster local permissions.

thesasuser — Fri, 16 Jan 2026 15:07:37 GMT

Hello
I am looking at the Deployment of SAS Viya4 on Open Shift using Kubernetes. (https://go.documentation.sas.com/doc/en/itopscdc/v_056/dplyml0phy0dkr/p127f6y30iimr6n17x2xe9vlt54q.htm#p0n0x0jvog312an1wggpgnam1jsw )
I am looking at the steps 3,4 and 5
Step (Steps 2 and 3) say "As an administrator with cluster permissions, run"
In another step (step 4) it says "As an administrator with local cluster permissions"
In yet another step (step 5) it says "As an administrator with namespace permissions, run ".
My question is are "administrators with cluster permission" and "administrators with cluster local permissions" different?

Latency numbers of On Prem SAS/ SAS Viya and On cloud SAS Viya on AWS

thesasuser — Sun, 11 Jan 2026 18:09:56 GMT

Hello

We are in the process of implementing SAS Viya in our organization. We have Oracle database on premises.

The I/T department has a question on the latency numbers on premises and on cloud installation of Viya4 on AWS. In this context latency means a delay in the data transmission between on-prem and cloud causing our job or process run time to be slower
All I could find is the information on Disk I/O. rate (100-150/Mb/sec/Core).
Wondering if someone can guide me on the latency requirement aspect.

Applying new license to SAS Viya4 using the Deployment Operator

thesasuser — Sun, 04 Jan 2026 16:53:10 GMT

Hello
In the documentation for applying new license to SAS Viya4 using the Deployment Operator
it says "Applying your license using the SAS Viya Platform Deployment Operator requires an outage
for your SAS Viya platform"
Does that mean stopping SAS Viya4 deployment before applying license?

Re: SAS Viya4 License - Kubernetes

thesasuser — Sun, 04 Jan 2026 04:03:07 GMT

Hello
I too have the same issue?
I would appreciate if yyou can share how the issue was resolved.

Re: Understanding SAS Viya4 deployment on AWS

thesasuser — Tue, 23 Dec 2025 15:01:07 GMT

Thanks @JackMcGuire
We don't have visual data mining.
I did go through the link. But it does not answer the question.

Understanding SAS Viya4 deployment on AWS

thesasuser — Mon, 22 Dec 2025 16:29:00 GMT

Hello
I am trying to understand SAS Viya4 on AWS.
After SAS Viya4 is deployed on AWS, under site-config there is a folder "vdm".
Trying to what this "vdm" is and what is its significance.
I would appreciate if someone can explain.

Creating alerts in Pager Duty using SAS

thesasuser — Mon, 15 Dec 2025 21:14:41 GMT

Hello
I am exploring the possibility of creating alerts on Pager duty for adverse events on SAS servers using SAS code.
By adverse events I mean high memory/CPU consumption, Low free disk space etc.
Wondering if anybody can share their experience on this.

Upgrading SAS Viya 2024.09 LTS to SAS Viya2025.03 LTS

thesasuser — Wed, 26 Nov 2025 16:07:15 GMT

Hello
We are trying to upgrade SAS Viya 2024.09 LTS to SAS Viya2025.03 LTS and running into an issue.
In the 2024.09 LTS version the rabbitmq stateful sets confirm to the "sas" storage class whereas in the 2025.03 LTS version this storage class needs to be "io2-vol-mq".
The deployment appears to fail on this count.
Wondering if any body can enlighten us in making this change while retaining the old data?

Creating a custom folder on the ompute pod on SAS Viya4 on AWS

thesasuser — Tue, 04 Nov 2025 17:34:37 GMT

Hello
Wondering if it is possible to create a custom folder /data-drivers/jdbc on the compute pod of SAS Viya 4 deployment running on AWS?

Obtaining a description of node on SAS Viya4 on AWS

thesasuser — Fri, 31 Oct 2025 14:45:24 GMT

Hello
Wondering if there is a way to get the details of nodes in a SAS viya4 deployment using kubectl? (or may be some config file that has the details)
I was interested in knowing the details of disk space, vCPU, RAM and attached storage.

Thanks

Re: Using Azure Service Principal to access DataBricks from SAS Viya Application

thesasuser — Mon, 27 Oct 2025 15:12:56 GMT

Hello @UttamKumar
This is about the Service Principal based access from SAS Compute Server to Azure DataBricks
I see one needs TenantID,SubscriberID,, ResourceGroup, DatabricksWorksSpace, ClientID, ClientSecrete, and AuthScheme for use in the properties statement.
We have SAS Viya 4 LTS 2024.09 and Databricks on AWS.
As a user I can logon to Databricks dashboard from my browser.(OAuth2 access is set).
I have used your method except for TenantID,SubscriberID,, ResourceGroup, DatabricksWorksSpace info.
But I get the error this error
ERROR: No login information was available for authdomain @origin. The credential for the user "xxxxxxx" in the domain "AzureEntra" does not exist.
Any suggestions?

Connecting to Databricks from SAS Viya4 using Client-ID and secret

thesasuser — Fri, 24 Oct 2025 20:32:22 GMT

Hello
We have SAS Viya4 and Databricks both installed on AWS. We were able to connect to Databricks using Personal Access Token PAT.
But now the requirement is to connect using client-id and secret.
I have been able to do this in the windows environment without any issue.

Not able replicate this on Viya4 /Databricks on AWS.
Wondering if anybody can enlighten me on this on the modifications, I need to implement in the connection string,
The connection string in use for PAT is given below:

libname libdbrk SPARK platform=databricks
  driverClass='cdata.jdbc.databricks.DatabricksDriver'
  server="abcd-efgh.cloud.databricks.com" port=443
  user=token pwd="xxxxxxxxxxxxxxxxxxxxxxxxxxxxx-x"
  httpPath="/sql/1.0/warehouses/12346abcd"
properties='DefaultColumnSize=256;QueryPassthrough=true;Other=ConnectRetryWaitTime=300;Catalog=mycatalog;Database=myschema'
  schema=myschema  bulkload=no;

Re: Obtaining cadence and release information using kubectl on Viya4 on AWS

thesasuser — Fri, 24 Oct 2025 17:36:45 GMT

Thanks.
It worked like a charm.

Obtaining cadence and release information using kubectl on Viya4 on AWS

thesasuser — Fri, 24 Oct 2025 15:37:44 GMT

Hello
Wondering if it is possible to obtain the cadence and release information of a Viya4 deployment using kubectl command.
I know we can get it from SAS Studio, but I am trying to see if that can be had through kubectl.