Attempting to convert character latitude/longitude values from character to numeric to utilize GEODIST function in PROC SQL. Current code running on SAS (r) 9.4 (TS1M3) data <dataset>; set <tmp_dataset>; LATITUDE2=input(LATITUDE, 20.15); LONGITUDE2=input(LONGITUDE, 20.15); run; Output using PROC PRINT or as samples selected via PROC SQL displays as: AX_LATITUDE2 AX_LATITUDE AX_LONGITUDE2 AX_LONGITUDE ------------------------------------------------------ 40.54115 40.541147 -105.077 -105.076775 39.9924 39.992399 -104.978 -104.978418 40.39116 40.391158 -104.712 -104.711740 41.63468 41.634681 -93.698 -93.697993
... View more