topic Capture city and country from address String in SAS Programming https://communities.sas.com/t5/SAS-Programming/Capture-city-and-country-from-address-String/m-p/85687#M18390 <HTML><HEAD></HEAD><BODY><P>There are four columns for address which contain street address, city and country.</P><P> The issue is they are not structured, i.e addr2 colunmn may contain city name for some records and addr3 may contain city name.</P><P> Now I would like to contacatenate all address fields to one string and get the city and country names from it.</P><P>How do we achieve that?Is there any SAS Uitlity that has list of all cities and countries in the world?</P></BODY></HTML> Thu, 29 Nov 2012 19:13:45 GMT SASPhile 2012-11-29T19:13:45Z Capture city and country from address String https://communities.sas.com/t5/SAS-Programming/Capture-city-and-country-from-address-String/m-p/85687#M18390 <HTML><HEAD></HEAD><BODY><P>There are four columns for address which contain street address, city and country.</P><P> The issue is they are not structured, i.e addr2 colunmn may contain city name for some records and addr3 may contain city name.</P><P> Now I would like to contacatenate all address fields to one string and get the city and country names from it.</P><P>How do we achieve that?Is there any SAS Uitlity that has list of all cities and countries in the world?</P></BODY></HTML> Thu, 29 Nov 2012 19:13:45 GMT https://communities.sas.com/t5/SAS-Programming/Capture-city-and-country-from-address-String/m-p/85687#M18390 SASPhile 2012-11-29T19:13:45Z Re: Capture city and country from address String https://communities.sas.com/t5/SAS-Programming/Capture-city-and-country-from-address-String/m-p/85688#M18391 <HTML><HEAD></HEAD><BODY><P>There isn't such a utility that I'm aware of.&nbsp; However, if you post a subset of your file, someone might be able to suggest an alternative way of doing what you want.</P></BODY></HTML> Fri, 30 Nov 2012 00:10:33 GMT https://communities.sas.com/t5/SAS-Programming/Capture-city-and-country-from-address-String/m-p/85688#M18391 art297 2012-11-30T00:10:33Z