topic Re: Extracting and searching data from web in SAS Procedures

Extracting and searching data from web

alam_ather — Fri, 16 Oct 2015 07:47:15 GMT

I am trying to access data from web and as a learning wrote following code into SAS EG:

filename seercode URL "https://www.google.com";
data siterecode;
infile seercode truncover;
input @1 bigline $char256.;
run;

Unfortunately, encountered following error, can anyone please suggest best way to resolve this issue:

NOTE: Unable to connect to host www.google.com. Check validity of host name.
ERROR: Hostname www.google.com not found.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.SITERECODE may be incomplete. When this step was stopped there were 0
observations and 1 variables.
WARNING: Data set WORK.SITERECODE was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 2.46 seconds
cpu time 0.04 seconds

Thanks

Re: Extracting and searching data from web

Patrick — Fri, 16 Oct 2015 07:57:40 GMT

Your code works for me with SAS installed locally on my laptop. Could it be that your SAS server where your code gets executed doesn't have Internet access?

Re: Extracting and searching data from web

BrunoMueller — Fri, 16 Oct 2015 07:58:32 GMT

You might need a PROXY definition on the FILENAME statement.

I would also use the DEBUG option on the FILENAME statement, this might give you more information as well

See https://support.sas.com/documentation/cdl/en/lestmtsref/68024/HTML/default/viewer.htm#p103pi2vrzn6qhn1e8alrs01jrb7.htm for more details.

Bruno