Find function is giving unexpected results. Output: I am expecting 1 as the answer here but getting 0. In text format output for last three fields: full_rating: "Action: New Rating (Mar-07-2018) From ""-"" to ""BB-""" b_rating: "Action: New Rating (Mar-07-2018) From ""-"" to ""BB-""" find: 0 Code: proc sql;
create table old_match_change as
select *, find(compress(upcase(full_rating),' ():"'), compress(upcase(b_rating),' ():"')) as find
from old_match
where find(compress(upcase(full_rating),' ():"'), compress(upcase(b_rating),' ():"'))=0;
quit;
... View more