I am attempting to download a simple spreadsheet from a webpage into my SAS program and I have been unsuccessful. I am not sure if my issue is due to our firewall or my code. I am using this code within SAS EG7.1. Here is my code and subsequent error message: filename bob url "http://www.nasdaq.com/screening/companies-by-industry.aspx?exchange=NASDAQ" debug; data test6; infile bob lrecl=30000; input col1 $10000.; put col1 $10000.; run; ERROR: Invalid reply received from the HTTP server. The funny thing is, the following code works successfully: filename eSUG url "http://www.sas.com/offices/NA/canada/en/edmonton.html"; data eSUG_achive(keep=pdffile); length pdffile $200; infile eSUG length=len lrecl=32767; input line $varying32767. len; if find(line,".pdf") then do; pdffile=scan(line,2,'"'); output; end; run; filename eSUG clear; Any thoughts on alternative ways to download the spreadsheet within my SAS code would be appreciated. Thanks.
... View more