Hi,
i am new on sas enterprise guide (7.11 version) so that reason my question sounds silly
i want to make routes for field teams for intensive points. I have data-set which includes decimal points at a city and i want to define 1km diameter-length fields which includes min 60 max 80 points. To make this i took the center point (decimal) of the city and try to calculate the distance (haversine formula) from center and later making group of them which 1km distance interval but i can not make it right. Have you any advice or how can i make the distance calculation?
By the way i am using computed columns to take this action not programming. Thank you in advance
Note: Geodist function does not exist in 7.11 version of SAS Enterprise Guide
LATIT | LONGI | Province | City |
36,60883 | 34,32703 | neverland | nowhere |
36,71302 | 34,33731 | neverland | nowhere |
36,45804 | 34,15251 | neverland | nowhere |
36,63386 | 34,34518 | neverland | nowhere |
36,60949 | 34,31894 | neverland | nowhere |
36,45832 | 34,14116 | neverland | nowhere |
36,55178 | 34,23458 | neverland | nowhere |
36,59352 | 34,28714 | neverland | nowhere |
You can calculate the distances without needing the geodist function. Take a look at: http://www.sascommunity.org/wiki/Driving_Distances_and_Drive_Times_using_SAS_and_Google_Maps
Then, I'd use proc modeclus to find the closest 60 or 80 points. Code is provided at: http://www.sas-programming.com/2013/05/finding-closest-pair-in-dataset-using.html
Art, CEO, AnalystFinder.com
You can calculate the distances without needing the geodist function. Take a look at: http://www.sascommunity.org/wiki/Driving_Distances_and_Drive_Times_using_SAS_and_Google_Maps
Then, I'd use proc modeclus to find the closest 60 or 80 points. Code is provided at: http://www.sas-programming.com/2013/05/finding-closest-pair-in-dataset-using.html
Art, CEO, AnalystFinder.com
thank you for swift reply!
Now i must improve my coding technique on SAS 🙂
it s a bit hard for me because i m new on SAS Enterprise Guide
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.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.