topic Re: PROC HTTP error in SAS Procedures

PROC HTTP error

PaigeMiller — Fri, 15 Nov 2019 13:14:28 GMT

I am trying to follow @ChrisHemedinger's article on web scraping at https://blogs.sas.com/content/sasdummy/2017/12/04/scrape-web-page-data/

I can access the web site mentioned in the following code via my web browser, but the code returns an error.

563   filename src temp;
564   proc http
565    method="GET"
566    url="https://www.unitedstateszipcodes.org/14068/"
567    out=src;
568   run;

ERROR: Error connecting to 13.225.212.116:443. (The connection has timed out.)
ERROR: Unable to connect to Web server.

I am guessing that the error is because my company's firewall prevents this type of HTTP access, but that's a guess. What do you think? Are there other possible causes of this error?

Re: PROC HTTP error

Ksharp — Fri, 15 Nov 2019 13:41:43 GMT

I tested it under SAS On-Demand Academic ,

No problem.

68         
 69         filename src temp;
 70           proc http
 71            method="GET"
 72            url="https://www.unitedstateszipcodes.org/14068/"
 73            out=src;
 74         run;
 
 NOTE: “PROCEDURE HTTP”所用时间（总处理时间）:
       实际时间          0.55 秒
       用户 CPU 时间     0.04 秒
       系统 CPU 时间     0.00 秒
       内存              2202.84k
       OS 内存           27808.00k
       时间戳           2019-11-15 下午01:40:21
       Step Count                        45  Switch Count  3
       页错误数                       0
       页回收数                     1120
       页交换数                        0
       主动上下文切换数        88
       被动上下文切换数      0
       块输入操作数            0
       块输出操作数           352

Re: PROC HTTP error

PaigeMiller — Fri, 15 Nov 2019 13:54:04 GMT

Yes, I tested it on my home computer using University Edition, works fine there as well.

Re: PROC HTTP error

ChrisHemedinger — Sat, 16 Nov 2019 19:35:11 GMT

There are PROXY host/port options that you can specify on PROC HTTP...if you can learn your organization's proxy settings.

Re: PROC HTTP error

PaigeMiller — Tue, 19 Nov 2019 13:31:12 GMT

I did learn the proxy settings, and then I needed to add to my PROC HTTP code the proper values for the options

PROXYHOST=

PROXYPORT=

PROXYUSERNAME=

PROXYPASSWORD=

AUTH_BASIC