topic PROC S3 - ERROR: Unknown region in Statistical Procedures

PROC S3 - ERROR: Unknown region

milind3889 — Mon, 08 Jul 2019 22:01:05 GMT

I am using below proc s3 statement.

proc s3 profile="sas_aws";
list  "s3://vertex-rwe/RWE_S3/Premier_20190226/Compressed_Source_Files/2018Q3";
run;

sas_aws profile is defined in AWS CLI configuration file.

region is us-east-1

I am getting below error after execution of below code.

84 proc s3 profile="sas_aws";
85 list "s3://vertex-rwe/RWE_S3/Premier_20190226/Compressed_Source_Files/2018Q3";
86 run;

ERROR: Unknown region.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE S3 used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

Re: PROC S3 - ERROR: Unknown region

JBailey — Thu, 11 Jul 2019 16:55:59 GMT

Hi @milind3889

Here is a working example.

proc s3 region=useast profile='bogus-profile';
   put "C:\temp\postgres\contacts.csv" "/sasxjb-bucket/contacts.csv";
   list "/sasxjb-bucket/";
   info "/sasxjb-bucket/";
run;

The region codes can be a little tricky. You can find them here - S3 Procedure Doc

Notice that the REGION= value is not enclosed in quotes.

To clean up, I empty the bucket and destroy the bucket (must be empty):

proc s3 region=useast profile='bogus-profile';
   delete "/sasxjb-bucket/contacts.csv";
   destroy "/sasxjb-bucket/";
run;

Hope this helps.

Best wishes,

Jeff