BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
els
Fluorite | Level 6 els
Fluorite | Level 6

Hi,

 

I am trying to access an S3 bucket from SAS University Edition server on AWS (SAS 9.4 M4) with PROC S3:

 

PROC S3 KEYID="<access key>" SECRET="<secret access key>" REGION=USWEST;
	LIST "/mybucket-sas";
RUN;

I am getting the following error:

 

 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
61
62 PROC S3 KEYID="<access key>" SECRET="<secret access key>" REGION=USWEST;
63 LIST "/dataanalytics-sas";
64 RUN;

ERROR: Could not list bucket contents.
ERROR: Could not load the specified encryption algorithm.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE S3 used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds

65
66
67 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
80

 

 

I tried adding NOSSL option to the proc s3 command, but it didn't change anything. The AWS user has full access to S3 and KMS. Would you know what could be the problem and how to fix it?

1 ACCEPTED SOLUTION

Accepted Solutions
wYrazik
Fluorite | Level 6

Dear els,

 

Indeed as you have already discovered HTTPS and SFTP access are not supported in the SAS University Edition (virtual machine):

http://support.sas.com/software/products/university-edition/faq/trouble_error_tkessl.htm

 

but in SAS® OnDemand for Academics:

http://support.sas.com/software/products/ondemand-academics/

PROC S3 works as expected. I'm using it quite extensively.

 

If you're an independent learner as I am, You're also qualified to signup for SAS® OnDemand for Academics:

http://support.sas.com/software/products/ondemand-academics/#s1=2

follow the link "registration application" to register (https://odamid.oda.sas.com/SASODARegistration/). 

 

I hope it helps You address your analytical challenge.

 

Please let me know if it solves the problem with S3 

 

Greetings from Warsaw, Poland (EU)

View solution in original post

6 REPLIES 6
Reeza
Super User
SAS UE wasn't designed to hit a server, I'd be happily surprised if it works with S3 bucket.
els
Fluorite | Level 6 els
Fluorite | Level 6

Thank you for your response Reeza! Let me just add that I have used the SAS UE AMI from the AWS Marketplace to create the server instance.

 

I have also tried running the SAS UE server vApp image locally in a virtual environment (VMWare) and I am getting exactly the same error; however, if I run the proc s3 command in a Jupyter notebook, there is an extra line in the error message indicating that the problem may be related to the SSL/TLS handshake while the connection to the S3 bucket is being established:

 

11   ods listing close;ods html5 file=stdout options(bitmap_mode='inline') device=png; ods graphics on / outputfmt=png;
NOTE: Writing HTML5 Body file: STDOUT
12   
13   PROC S3 KEYID="<access key>" SECRET="<secret access key>" REGION=USWEST;
14   	LIST "/dataanalytics-sas/";
15   RUN;
ERROR: Could not list bucket contents.
ERROR: Could not load the specified encryption algorithm.
ERROR: Could not find extension: (tkersa2)
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE S3 used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
16   ods html5 close;ods listing;

17

Adding NOSSL option, again, didn't help. Would you know if I can install the tkersa2 extension?

Reeza
Super User
I'm pretty sure you can't do secure connections from SAS UE. There's a point about that somewhere here. At least for FTP https://support.sas.com/software/products/university-edition/faq/trouble_FTP_VB.htm

You can't modify the image in any manner so if that's what you're referring to with an extension then that's not possible.
els
Fluorite | Level 6 els
Fluorite | Level 6

Thanks again, Reeza! Good to know that.

wYrazik
Fluorite | Level 6

Dear els,

 

Indeed as you have already discovered HTTPS and SFTP access are not supported in the SAS University Edition (virtual machine):

http://support.sas.com/software/products/university-edition/faq/trouble_error_tkessl.htm

 

but in SAS® OnDemand for Academics:

http://support.sas.com/software/products/ondemand-academics/

PROC S3 works as expected. I'm using it quite extensively.

 

If you're an independent learner as I am, You're also qualified to signup for SAS® OnDemand for Academics:

http://support.sas.com/software/products/ondemand-academics/#s1=2

follow the link "registration application" to register (https://odamid.oda.sas.com/SASODARegistration/). 

 

I hope it helps You address your analytical challenge.

 

Please let me know if it solves the problem with S3 

 

Greetings from Warsaw, Poland (EU)

els
Fluorite | Level 6 els
Fluorite | Level 6

Thanks a lot for the update wYrazik! I really appreciate it.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 2888 views
  • 9 likes
  • 3 in conversation