Architecting, installing and maintaining your SAS environment

PROC S3 Procedure Questions

Reply
Contributor
Posts: 26

PROC S3 Procedure Questions

[ Edited ]

SAS Current version: 9.04.01M4P110916

 

Is the SAS/ACCESS Interface to Amazon Redshift required to use the PROC S3 procedure to connect to a S3 bucket? 

 

There are several SAS programmers that require access to the S3 bucket. Is there one config file for all SAS programmers or need to add the config file in each SAS programmer /home/username Linux directory?

SAS Employee
Posts: 271

Re: PROC S3 Procedure Questions

Hi @Jlochoa

 

If the programmers are using a centralized account (the same credentials) then a single directory would be fine. If they each have their own accounts they will need to have individual directories so that their keys are not shared.

 

Best wishes,
Jeff

Contributor
Posts: 26

Re: PROC S3 Procedure Questions

Hi Jeff,

 

Is there a way to set server side encryption in the Proc S3 config file or some other way. The S3 bucket requires this encryption.

 

Thanks,

jose

Super User
Super User
Posts: 7,932

Re: PROC S3 Procedure Questions

I have played a little with this using SAS 9.4m5, not sure if there are any changes from 9.4m4.

 

Basically I was experimenting with just storing PROC S3 format configuration files in users home directories.  For each bucket they need to access have them create a file text file in the .ssh directory with the name of the bucket can content like:

ssl=yes
keyID=key1
secret=key2
region=useast

Then they can do something like:

* Copy file to S3 ;
%let bucket=mybucket;
proc s3 config="~/.ssh/&bucket";
  put "myfile" "/&bucket/myfile";
run;
Contributor
Posts: 26

Re: PROC S3 Procedure Questions

Hi Tom,

 

I created the .ssh directory in my /home/username directory and added the tks3.conf file. Unfortunately, the access denied error message in the log file

 

ERROR: Could not put file.

ERROR: Access Denied
Ask a Question
Discussion stats
  • 4 replies
  • 174 views
  • 1 like
  • 3 in conversation