Help in Instr function

Kalai2008 — Fri, 11 Aug 2017 14:07:52 GMT

This code works in SQL developer, but getting error in SAS
proc sql;
select
case WHEN Name LIKE '%' || substr(name2,instr(name2,' ',-1)+1)|| '%' then 'Y' else 'N' end as survey1
from x;
run;

ERROR: Function INSTR could not be located.
ERROR: Expression using addition (+) requires numeric types.

Re: Help in Instr function

RW9 — Fri, 11 Aug 2017 14:34:01 GMT

Yes, SAS implements ANSI SQL, not Oracle additional components.

Your case can be re-defined but would need to see some of the data it is working on to get an idea of what you want. I would guess at:

case when index(name,name2) > 0 then "Y" else "N" end as survey1

Note the above uses a SAS function index() so wouldn't work if you pass it through to the database, however if you did that the original query would work anyways.

topic Re: Help in Instr function in SAS Programming

Help in Instr function

Re: Help in Instr function