function like don't work in data step, if clause

[deleted_user]

Hello,

I need to swap "sql like" function for a similar one on the "data step if clause".

Ex.:
proc sql;
select
case
when descr_job like '%DOC%' then 'Doctor'
else ''
end as group
from employees

Ex.:
data new_employees;
set employees;

if descr_job like '%DOC%' then group = 'Doctor';
else group = '';
run;

Obs.: This data step don't work in SAS 8.2.

What fuction can i use in this case?

[sbb]

Do you not have access to SAS Documentation? Consider the INDEX function.

Scott Barry
SBBWorks, Inc.

SAS v8 DOC (not a very clean interface)
http://v8doc.sas.com/sashtml/


SAS 9 DOC
http://support.sas.com/onlinedoc/913/docMainpage.jsp?


Current SAS DOC starter page:
http://support.sas.com/documentation/onlinedoc/base/index.html

[ChrisNZ]

As Scott said.

Also, like is for where clauses only.

[deleted_user]

I used the index function and this work

tks