Hi,
I am getting following ERROR message while executing the below code in SAS Eguide 7.12 ; SASVersion:9.4 ; O.S : Linux64 .
Request anyof you to suggest how the below code can be executed ?
Error Message:
ERROR: The connection was reset by a peer..
Code:
%let ll1=%str(42.691560,-73.827840);
%let ll2=%str(35.805410,-78.797679);
* no changes required below this line;
filename x url "https://www.google.com/maps/dir/&ll1/&ll2/?force=lite";
filename z temp;
data _null_;
infile x recfm=f lrecl=1 end=eof;
file z recfm=f lrecl=1;
input @1 x $char1.;
put @1 x $char1.;
if eof;
call symputx('filesize',_n_);
run;
data _null_;
infile z recfm=f lrecl=&filesize. eof=done;
input @ 'miles' +(-15) @ '"' distance :comma12. text $30.;
units = scan(text,1,'"');
time = scan(text,3,'"');
file print;
put "DRIVING DISTANCE BETWEEN &ll1 AND &ll2 : "
distance units" (TIME: " time ")";
stop;
done:
file print;
put "CANNOT FIND THE DRIVING DISTANCE BETWEEN &ll1 AND &ll2 : " /
"TRY ANOTHER PAIR OF COORDINATES";
stop;
run;
filename x clear;
filename z clear;
I've seen that error as a general browser error with nothing to do with SAS.
Since you are using a google URL as a data source that may be more of an internect connection/ status issue.
Since I get a "connection refused" I suspect it may be something on the URL.
Thanks for the Reponse.
I checked and the URL is valid.
URL:https://www.google.com/maps/dir/42.691560,-73.827840/35.805410,-78.797679/?force=lite
I tried again and still the same Error.
Thanks.
Did you check the url from sas server or from your computer?
I checked the URL using the browser (IE) in Local computer.
Donot know how to check using SAS server.
Could you please help?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.