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
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.
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.
How confident are you about those proxy settings? Have those worked for you before?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.