variable assignment based on partial string value

[Elliott]

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?

Thanks,

Elliott

[Miracle · Accepted solution]

Maybe this? 

if index(upcase(type),'COMMERCIAL')>0 then flag = 'X11'; else flag = 'Z10';

Character Functions

[Elliott]

Thank you!