topic Re: PROC S3 Procedure Questions in Administration and Deployment

PROC S3 Procedure Questions

Jlochoa — Wed, 30 May 2018 14:44:08 GMT

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?

Re: PROC S3 Procedure Questions

JBailey — Wed, 30 May 2018 19:37:12 GMT

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

Re: PROC S3 Procedure Questions

Jlochoa — Fri, 01 Jun 2018 16:21:48 GMT

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

Re: PROC S3 Procedure Questions

Tom — Fri, 01 Jun 2018 16:58:56 GMT

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;

Re: PROC S3 Procedure Questions

Jlochoa — Fri, 08 Jun 2018 15:41:28 GMT

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

Re: PROC S3 Procedure Questions

jeclev — Tue, 23 Jun 2020 21:32:05 GMT

The .tks3.conf file does not go in the .ssh directory. It should be in your home directory.