topic Re: sas proc http in SAS Programming

sas proc http

Sharique — Wed, 12 Apr 2017 09:43:04 GMT

i am using the below code in EG to download federal rates from the url. But each time it throws error.Kindly help.

filename out 'C:\Users\islams\out.csv';

proc http method='get'

out=out

url="https://fred.stlouisfed.org/series/FEDFUNDS/downloaddata/FEDFUNDS.csv"

proxyhost="10.61.186.3"

proxyport=9090;

run;

ERROR

ERROR: java.net.ConnectException: Connection refused

Re: sas proc http

RW9 — Wed, 12 Apr 2017 09:53:35 GMT

Well, your code seems fine from a SAS perspective, and clicking on the link does download the file. I doesn't however do anything on my machine either, so I would assume that website does not allow that type of access, or that you need login details to be able to do this type of task. Unfortunately, this is outside the scope of this forum, either contact your IT to check, and/or that website to see what is needed.

Re: sas proc http

Kurt_Bremser — Wed, 12 Apr 2017 11:01:06 GMT

How do you run SAS? If you have a client/server install, you most probably have no permission to use the proxy from the server. This would also invalidate your C:\ path for the outfile, as you might not have write access to that path on the server.

Re: sas proc http

ChrisHemedinger — Wed, 12 Apr 2017 11:33:51 GMT

How confident are you about those proxy settings? Have those worked for you before?