variable assignment based on partial string value

Elliott — Sun, 10 Sep 2017 14:56:34 GMT

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

Re: variable assignment based on partial string value

Miracle — Sun, 10 Sep 2017 15:15:43 GMT

Maybe this?

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

Character Functions

Re: variable assignment based on partial string value

Elliott — Sun, 10 Sep 2017 16:01:15 GMT

Thank you!

topic Re: variable assignment based on partial string value in SAS Programming

variable assignment based on partial string value

Re: variable assignment based on partial string value

Re: variable assignment based on partial string value