BookmarkSubscribeRSS Feed
juanvg1972
Pyrite | Level 9

Hi,

 

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

15 REPLIES 15
Reeza
Super User

What's your SAS version, not EG version?

 

%put &sysvlong;
LinusH
Tourmaline | Level 20

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).

Data never sleeps
juanvg1972
Pyrite | Level 9

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!!

juanvg1972
Pyrite | Level 9

I am sorry, my SAS EG is 7.11

and SAS: 9.04.01M4P110916

LinusH
Tourmaline | Level 20
PROC S3 should be available in the M4 release...?
Data never sleeps
juanvg1972
Pyrite | Level 9

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

AlanC
Barite | Level 11

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.

https://github.com/savian-net
Reeza
Super User

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. 

juanvg1972
Pyrite | Level 9

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
Reeza
Super User

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.

AlanC
Barite | Level 11

Reeza,

 

He mentioned that he is using SAS 9.04. I don't think it existed at that time.

https://github.com/savian-net
Reeza
Super User

@AlanC The SAS version posted is 9.4 TS1M4 which does support PROC S3. 

 

AlanC
Barite | Level 11

Correct. I didn't see that SAS posts the version that way. Thanks.

https://github.com/savian-net
JBailey
Barite | Level 11

Hi @juanvg1972,

 

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;

 

Best wishes,

Jeff

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 15 replies
  • 2255 views
  • 3 likes
  • 6 in conversation