hello, (I started in sas) I have two tables : data first; infile cards dlm=','; input city$ :30. any$ :20. ; CARDS; oakland is very beautifull,azerty I never go to oakland,qwerty abc fremont fgh ,anything ; run; and a secondary : data transco; infile cards dlm=','; input field1$ :30. field2$ :20. ; CARDS; oakland,berkeley fremont,newark stanford,loyola ; run; And I would like find any data from field1 in my secondary table in first table for city, and if string match, I would like to replace him from field2. ex : oakland is very beautifull >> transform in : berkeley is very beautifull I never go to oakland >> I never go to berkeley abc fremont fgh >> abc loyola fgh thank you for your help.
... View more