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

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

deleted_user — Mon, 05 Oct 2009 20:23:20 GMT

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?

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

sbb — Mon, 05 Oct 2009 21:26:09 GMT

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

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

ChrisNZ — Tue, 06 Oct 2009 00:30:54 GMT

As Scott said.

Also, like is for where clauses only.

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

deleted_user — Wed, 28 Oct 2009 13:32:55 GMT

I used the index function and this work

tks