Hi All, So, I am doing some text processing and cleaning, and have got this little issue. I want to omit the words 'director' or 'officer' (and a lot more words) from the variable name. For this, I create the do loop, which goes through the list of words and omits them from the variable. what I want to add, is to save the omitted word in another variable, so I know what was the omitted one. For example, if the name is GARY OFFICER, then the varibale name_h would be just GARY, and variable O would be OFFICER. This is why I define the let statement in the do loop, so that it saves the list. The code, however, is not working correctly, and I am thinking that probably my use of let statement is not correct. Can someone please help me on that? Thanks. here's the code: DATA have; INPUT name $1-30; DATALINES; GARRY OFFICER PATRICK DIRECTOR JOHN ; run; data want (drop = list); set have; name_h = name; do list = 'DIRECTOR','OFFICER'; % let i = list; if index(strip(name_h),list) > 0 then O = &i; name_h = tranwrd(strip(name_h),strip(list),''); end; run;
... View more