DATA Step, Macro, Functions and more

Problem accessing AWS S3 bucket from SAS University Edition

Accepted Solution Solved
Reply
New Contributor els
New Contributor
Posts: 4
Accepted Solution

Problem accessing AWS S3 bucket from SAS University Edition

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?


Accepted Solutions
Solution
2 weeks ago
Occasional Contributor
Posts: 5

Re: Problem accessing AWS S3 bucket from SAS University Edition

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


All Replies
Super User
Posts: 19,878

Re: Problem accessing AWS S3 bucket from SAS University Edition

SAS UE wasn't designed to hit a server, I'd be happily surprised if it works with S3 bucket.
New Contributor els
New Contributor
Posts: 4

Re: Problem accessing AWS S3 bucket from SAS University Edition

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?

Super User
Posts: 19,878

Re: Problem accessing AWS S3 bucket from SAS University Edition

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.
New Contributor els
New Contributor
Posts: 4

Re: Problem accessing AWS S3 bucket from SAS University Edition

Thanks again, Reeza! Good to know that.

Solution
2 weeks ago
Occasional Contributor
Posts: 5

Re: Problem accessing AWS S3 bucket from SAS University Edition

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)

New Contributor els
New Contributor
Posts: 4

Re: Problem accessing AWS S3 bucket from SAS University Edition

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

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