Hi all,
I am trying to create a hyperlink to Google Maps for my addresses that I'm outputting to Excel via the ExcelXP tagset. The first part of the link turns up ie the maps.google.com part but not the northing and eastings. I've googled the problem but can not find the answer, can someone please help?
proc report data = address_history nowd ;
column party_id address startdt enddt latlong_northing latlong_easting ;
define party_id / 'Client ID' ;
define address / 'Address' group ;
define startdt / 'Start' format = ddmmyy10. ;
define enddt / 'End' format = ddmmyy10. ;
define latlong_northing / group noprint ;
define latlong_easting / group noprint ;
compute address ;
urlstring = cats('http://maps.google.com/?q=',latlong_northing,',',latlong_easting) ;
call define(_COL_, 'URL', urlstring);
endcomp;
run ;
Many thanks in advance
regards
Steve
Dont worry, I figured it out. Proc Report builds from left to right so moving the northings and eastings to the left of address in the column statement fixed the problem.
That's a very easy solution to a problem I spent a very long time trying to solve!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.