I have tried to locate our internal IP addresses throughout SAS but my code is not giving me observations. FILENAME Signal '/folders/myshortcuts/SAS_Files/Test.csv'; Data IPData (Keep= ip Geoname_id); Length ip $20 Geoname_id 8; Infile Signal Firstobs=2; Input ip $; Array ipnew {4}; Do i=1 to 4; ipnew{i} = scan(ip,i,'.'); End; Geoname_id = ipnew {4} + (ipnew {3}*256) + (ipnew {2}*256*256) + (ipnew {1}*256*256*256); Run; Quit; Proc Geocode Range Out=Geo Data=IPData Addressvar=Geoname_id Rangedata=CityBlock Beginrangevar=startIpNum Endrangevar=endipnum Rangekeyvar=locId Lookup=CityLocation Lookupkeyvar=locId Lookupyvar=latitude Lookupxvar=longitude Attributevar=(city, country); Run; Quit; I get a table but no variable. How can I fix it please ??? Thank you for your advice.
... View more