Help with adress

[YannRC]

Hi, I try to clean a dataset of adress. There are not good. I know that the best practice is to geolocalise every adress but i have to clean quickly. The first thing I want to to is to change AV by AVENUE, BLD by BOULEVARD,etc... I know that I can use TRANWRD but i can change only one WORD. So, my idea was to use multiple CASE WHEN.... in a query. But i have this error. And I don't really understand Why. Can you help me? I use SAS STUDIO

[Tom · Accepted solution]

Your table does not have the variable AV that you referenced in the expression using the CONTAINS keyword/function.  I suspect you meant to use the string 'AV' instead.  

You should use the FINDW() function instead of using CONTAINS to avoid changing part of name that just happens to have AV in it.  For example "BRAVO STREET".

Or perhaps look at using regular expressions.

PS: Please post text, such as code or LOG lines, as text and not pictures.  You can use the Insert Code button to get a pop-up window where you can paste or edit the text.