5/3/2023 0 Comments Geodist sas 9.1The web tools* gave 1972 miles, 7.7 miles, and 25 miles respectively. Note SAS output dis1 and dis2 as blank, and 10.2 miles for dis3. ![]() Put "Distance between zipcodes 0211 is " dis3 I want to calculate the distance using latitudes and longitudes but it should exactly replicate the outcome of GEODIST function for the same input of latitudes and longitudes. Put "Distance between zipcodes 5003 is " dis2 data null input lat1 long1 lat2 long2 Distance geodist(lat1,long1,lat2,long2,'DM') put 'Distance ' Distance 'miles' datalines 35.2 -78.1 37.6 -79.8 run SAS writes the following output to the log: Distance 190.72474282 miles. Put "Distance between zipcodes 1001 is " dis1 In addition, for the pair that SAS could not calculate, I still could input on a web tool and found out the distance. I selected one of the calculated distances and compared it with the web site tools that calculated the distance between first zipcode and second zipcode and found that the result could not be matched to what the web tool calculations. I then used the GEODIST function to calculate the distances and found that SAS calculated some of pairs but not all of them. ![]() Then I manually merge the ZIPCODE.DATA which has ZIP, x (which I assmed it was latitude)), and y (which I assumed as longitude) with my zipcode pair data. ![]() Second, I downloaded manually the recent ZIPCODE.DATA from MAPSONLINE, but found that I actually couldn't save into the SASHELP path becuase no data can be added there. I didn't know why, but when I checked the SASHELP library, it was not there. I first used the zipcitydistance function, but got an error message saying that "" does not exist. I would like to calculate the distance between two columns (about 100 rows) of zipcodes (source zipcodes and destined zipcodes) in SAS university version.
0 Comments
Leave a Reply. |