topic Re: Accesing S3 Amazon using proc http in SAS Programming

Accesing S3 Amazon using proc http

juanvg1972 — Thu, 28 Sep 2017 09:48:15 GMT

Hi,

I want to know if it's possible to access ti S3 in Amazon using proc http. I want to do a step similar to this:

filename fichurl temp;
proc http
 url="https://raw.githubusercontent.com/jpatokal/openflights/master/data/airports.dat"
 method="GET"
 out=fichurl;
run;

DATA WORK.AIRPORT_URL (drop= F9-F14);
    length id 8. aeropuerto ciudad pais cod_iata cod_icao $50.;
    INFILE fichurl DLM=','  DSD  MISSOVER ;
    INPUT
        ID              
        aeropuerto              
        ciudad               
        pais           
        cod_iata             
        cod_icao               
        latitud         
        longitud          
        F9 F10 F11 F12 F13 F14
                     ;
RUN;

is that possible?

NOTE: I can't use proc S3 because of my SAS version

Re: Accesing S3 Amazon using proc http

Kurt_Bremser — Thu, 28 Sep 2017 11:13:48 GMT

Did you try it? If yes, what were the results (log)?

Re: Accesing S3 Amazon using proc http

juanvg1972 — Thu, 28 Sep 2017 11:16:20 GMT

I didn't try it. I wnat to know how to change the above code to work with S3 if possible.

For example, how to pass user and pass, and if its any special option..

Thanks

Re: Accesing S3 Amazon using proc http

Kurt_Bremser — Thu, 28 Sep 2017 11:23:53 GMT

You need to set up your SAS for using TLS. See Encryption in SAS for more.