DATA Step, Macro, Functions and more

Accesing S3 Amazon using proc http

Reply
Frequent Contributor
Posts: 131

Accesing S3 Amazon using proc http

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

Super User
Posts: 9,574

Re: Accesing S3 Amazon using proc http

Posted in reply to juanvg1972

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Frequent Contributor
Posts: 131

Re: Accesing S3 Amazon using proc http

Posted in reply to KurtBremser

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

Super User
Posts: 9,574

Re: Accesing S3 Amazon using proc http

Posted in reply to juanvg1972

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 3 replies
  • 151 views
  • 0 likes
  • 2 in conversation