topic Re: Importing a file which is downloaded after being registered from a website using SAS in New SAS User

Importing a file which is downloaded after being registered from a website using SAS

Red1 — Tue, 14 May 2019 13:53:10 GMT

I have a problem importing a file from a website where you need to be registered to launch the download of the csv file, here is my code :

filename foo url 'http://XXXX:8028/'
         USER='XXX' PASS='XXX' debug;

proc import file=foo 
out=bigdata_tel2 
dbms=csv 
replace;
delimiter=";";
getnames=no;
run;

The result is the html code of the page, I also tried that url :http://XXXX:8028/aaa.csv notice that the url doesn't change when I download the file.

Here is the website :

It's my first time importing a file from a website, any help is welcome. Thanks

Re: Importing a file which is downloaded after being registered from a website using SAS

Ksharp — Wed, 15 May 2019 14:05:34 GMT

two options:

1) Check PROC HTTP documentation and see if it could pass username and pw.

2) Use the third side software cURL to download that CSV, and PROC IMPORT it .

Re: Importing a file which is downloaded after being registered from a website using SAS

Red1 — Wed, 15 May 2019 14:46:07 GMT

Thanks for your answer, I tried that :

filename resp TEMP;
proc http

     method="GET"
     url="http://XXX:8028"
     webusername="XXX"
     webpassword="XXX"
     out=resp;
     run;

proc import file=resp

     out=bigdata_tel2
     dbms=csv
     replace;
     delimiter=";";
     getnames=no;
     run;

But the result is the same.. . html code