Hello,
I am trying to get the driving distance and time between two points in Canada using SAS and Google Maps. The code below works for US coordinate pairs but not Canadian. The Canadian coordinates work when put in the Google Maps directions menu. I tried a variety of Canadian coordinate pairs and none of them work.
Has anyone had this issue? Know of a solution?
Thanks.
Greg
ps. I'm using SAS 9.2
/*USA cocordinates - this works */ %let ll1=%str(42.691560,-73.827840); %let ll2=%str(35.805410,-78.797679);
/* Canadian Coordinates - does not work? */ /*%let ll1=%str(46.284774,-63.178973);*/ /*%let ll2=%str(46.292494,-63.172751);*/
filename x url "https://www.google.ca/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;
%put x; %put z;
filename x clear; filename z clear;
... View more