@SASKiwi This is the first time I am attempting to establish a connection. It's pretty much trial and error as our organization is fairly new in the AWS space. We're actually testing this functionality in our SAS Test server which is on 9.4M6 (prod is currently on 9.4M4). If I understood this documentation correctly, it appears the ODBC functionality should be available in 9.4M6: https://support.sas.com/kb/52/777.html Not sure if this is helpful information, but minutes before, I was able to connect to S3 using the following code: options set=HTTPS_PROXY="http://username:&password@proxy.com:portnumber"; options set=HTTP_PROXY="http://username:&password@proxy.com:portnumber"; proc s3 AWSCredentials="~/.aws/credentials" AWSCONFIG="~/.aws/config" PROFILE="profile"; GET "/aws/075f0a3.txt" "/home/userid/075f0a3.txt"; run; @JBailey Are there any notes or messages displayed in the SAS log? For clarification, by SAS log, do you mean the log that appears in Enterprise Guide once a program has completed? The program that I executed did not complete, it stayed in "running" state the entire time until I killed it (last attempt, I let it run for 50 minutes). I am actually curious whether there are other logs that I can leverage. I'd like to understand where the program is "stuck". I checked in my user folder on the unix server, I was unable to find anything that appears like a log. Note: I don't have a lot of experience in SAS either. Are you running SAS in AWS or on-premises? On-premises, I was not aware I can run SAS in AWS. 🙂 Looking at the program, you posted. I see some similarities, but the glaring differences are the addition of proxy information. Would you be able to point me to documentation explaining these options? Are these options available with ODBC only? Oh, also, is it safe to assume that the schema portion is referring to "Database" in Athena as opposed to "Data Source"? /* this is the skeleton that I posted on the communities */
libname athena odbc
complete="DRIVER={Simba Athena ODBC Driver};
AwsRegion=us-east-1;
S3OutputLocation=s3://bogus-athena-results/;
AuthenticationType=IAM Profile;
AwsProfile=617292732428-jbsandbox;
UseProxy=1;
ProxyScheme=HTTP;
ProxyHost=111.111.111.111;
ProxyPort=80;
ProxyUID=ProxyUserID;
ProxyPWD=ProxyPassword;" schema=somedb; Thank you very much!
... View more