Help using Base SAS procedures

Extracting and searching data from web

Reply
Occasional Contributor
Posts: 16

Extracting and searching data from web

 

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

 

Respected Advisor
Posts: 4,173

Re: Extracting and searching data from web

Posted in reply to alam_ather

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?

SAS Super FREQ
Posts: 708

Re: Extracting and searching data from web

Posted in reply to alam_ather

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#p103pi2vrzn6qh... for more details.

 

Bruno

Ask a Question
Discussion stats
  • 2 replies
  • 233 views
  • 0 likes
  • 3 in conversation