Would like to know if there is a way to libname directly to AWS S3 in the same way that you can in LINUX, UNIX or Windows?
Libnaming from a AWS EC2 hosted SAS Server directly to an AWS S3 Bucket, e.g. libname s3buck "s3://mybucket/";
The question is not related to SAS University. The question is related to whether SAS can directly interface via libnames to S3 as a file server, or if there is another way of connecting with ease.
Thanks
G
Hi gra_in_aus,
I'm also trying to find out if there any in-built procedures or process in SAS to upload files to AWS S3? and how to establish connectvity between SAS and AWS?f you have answers can you please share them?
Thanks,
S.
Hi SASPhile,
Apparently in SAS 9.4m4 maintenance release there is a new PROC S3 procedure. I am lead to believe that it has basic functionality for data movement to S3.
Many Thanks
G
I'm using 9.4 M3. Cant find it.
but how to set up S3 on machine? Is there a free version to test it out how SAS and S3 works?
Apologies for the confusing you need to have the 4th maintenance release installed.
https://communities.sas.com/t5/tkb/articleprintpage/tkb-id/library/article-id/1696
Hello,
I am using SAS University Edition Enterprise Miner, SAS Studio on AWS.
Trying to load a file to the SAS environment from my Macbook.
Could you please highlight steps/video on how to upload data to /myfolders location on the AMAZON AWS? -- Such that it is available in SAS environment.
Thanks
Found the below SAS Note useful, libnames will not work for earlier releases hence this is the best way
http://support.sas.com/kb/57/091.html
Also I have heard S3 can mounted as driver on Linux Servers but does the permission/authentication to connect to the bucket remain as is has not been tested by me.
S3 is Amazon's data storage system and can be used for saving files and utilizing when requried.
If you are going with S3 you can either use the AWS CLI (by installing it on the server) to establish connection with S3 and use files.
You can mount S3 buckets on the server (this will then work as any other mount point).
Proc S3 can be used for accessing data.
If you are using S3 then you will have to create buckets in it and restrict the access of each bucket.
Regards,
Ankit
Hello,
I was trying to use Proc S3 to connect to S3 folders by following steps mentioned by SAS documentation(http://support.sas.com/documentation/cdl/en/proc/70377/HTML/default/viewer.htm#n1volodm4xnj3xn1s99po...) like creating configuration file.
After running commands like listing folder, i get a timed out error after few minutes of running Proc S3.
Couold you please help me with this?
Thanks in advance.
Gaurav, you will need to check on the S3 front and also enable workspace server logs and check the reason for the time out.
This could be a long running code or a heavy amount of data being fetched.
Network level checks would also need to be performed to ensure that no such timeout time has been set.
Hope the above checks help in narrowing down the issue.
Regards,
Ankit.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.