09-27-2017 08:25 AM
I am trying to dowload or directly read S3 files from AWS in a SAS BASE program. Is that possible?
I have found in documentation the procedure 'proc S3', but it's not avalilable in my SAS version.
Is there any other way to read or download S3 files to SAS??
I am working with SAS EG 6.1
Thanks in advance
09-27-2017 10:31 AM
6.1 would be 9.4, but perhaps an earlier maintenance level.
Upgrading within a major SAS release is usually not a very big task (depending on the nature of the installation of course).
09-27-2017 10:56 AM
SAS admins don't plan any upgrading coming soon...
If you can give a possible solution to download S3 files not with 'proc S3' I will be very gratefuk
Sorry for my english and thanks!!
09-27-2017 01:17 PM
I have read that is: 9.04M5, but I am not sure.....
I can't upgrade, becasuse admins don't plan do it....until.....I don't know....
Is there any other solution to connect SAS to AWS S3 and download files?
Thanks in advance
09-27-2017 04:34 PM
I think your version of SAS even predates PROC HTTP which would allow you to go against S3 REST APIs.
Consider doing it outside of SAS and bringing it in a delimited file or something else.
09-27-2017 11:40 PM
If the version is correct it should have PROC S3 Included as part of the Base Procedure which is most SAS installations.
What makes you think you don't have PROC S3?
If you're getting an error message post your code and log.
09-28-2017 05:45 AM
This is my log:
27 proc s3 ; ERROR: Procedure S3 not found. 28 create "/xxxxxxxx"; 29 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE S3 used (Total process time): real time 0.00 seconds cpu time 0.00 seconds
09-28-2017 10:27 PM
What's your output from a PROC SETINIT?
Are you sure your version is correct? Perhaps they didn't install it correctly?
I would consider contacting SAS tech support and talking to your IT area. If they've explicitly locked down access to S3 that's something you would need to be aware of before proceeding in my opinion.
05-01-2018 09:07 AM
PROC S3 was added in SAS 9.4M4. Let's make certain there is no weirdness regarding the version of SAS you are actually running on. Can you run the following code in a single SAS session and post the results from the log?
proc s3; create "/xxxxxx"; run; %put &sysvlong;