About JSifontes

JSifontes · ‎08-10-2020

And yes every record has a country

JSifontes · ‎08-10-2020

It's the last non-blank usually, it's just that it could be in any of the 5 fields depending on the length of the address

JSifontes · ‎08-07-2020

Agree with you both, valid points, the issue is that the address fields allow the users to input the country in any of the 5 fields, it all depends on the size of the address so the country could be in any of the 5 fields. I know it won't be super accurate in that regard when it has a country within the address as shown below, but I have to tackle the problem for the majority of cases I suppose 80/20 rule.

JSifontes · ‎08-07-2020

Hey guys, I am trying to figure out the best approach for this and what I need to do is the following: I have 2 data sets: Set1: Countries Country_Code, Country_Name Set2: Address FIle Customer_Name, Address_1 through Address_5 The address file is free form text, and what I want to do is loop over the countries set and if it finds a matching country from the Country_Name column in Set1 within Address_1-5 of Set2 then return the Country_Code in a new Column on Set2 I just have no clue how to formulate that loop or what the best approach would be All suggestions welcome!

Online Status	Offline
Date Last Visited	‎10-31-2020 12:51 PM

Re: Loop and Return Value from Source List

Re: Loop and Return Value from Source List

Re: Loop and Return Value from Source List

Loop and Return Value from Source List

Re: Loop and Return Value from Source List

Re: Loop and Return Value from Source List

Re: Loop and Return Value from Source List

Re: Loop and Return Value from Source List

Loop and Return Value from Source List

SAS Analytics Explorers