09-10-2017 10:56 AM
I am trying to assign a value to a new variable based on a part of a string variable.
I have tried in proc sql with a case when and tried contains that did not work. So I extracted the raw data into a data step and am trying that way.
So if I have XYZ COMMERCIAL in variable type and I am just looking for any entry that contains COMMERCIAL to assign 'X11' to variable flag an in statment does not work.
I wrote if type in ('COMMERCIAL') then flag = 'X11'; else flag = 'Z10' -- this does not work.
How can I do this?
Need further help from the community? Please ask a new question.