topic Re: sounds like function in SAS Procedures

sounds like function

robertrao — Mon, 20 May 2013 20:07:16 GMT

Hi I have a variable in a dataset and want to check if a word sounds like

I used the following and did not work for me..

Could you please correct??

Thanks

data want;

set have;

if description like "myocar" then flg=1;

run;

Re: sounds like function

Haikuo — Mon, 20 May 2013 20:22:39 GMT

Proc SQL =* operator.

Proc sql;

create table want as

select *, case when description =* "myocar" then 1 else 0 end as flg

from have;

quit;

Haikuo

Re: sounds like function

robertrao — Mon, 20 May 2013 20:27:26 GMT

Hi Thanks. Is there any Datastep option to do the same??

Thanks

Re: sounds like function

Haikuo — Mon, 20 May 2013 20:28:44 GMT

Sure, if you insist:

data want;

set have;

if soundex(description)=soundex('myocar') then flg=1;

run;

Haikuo

Re: sounds like function

robertrao — Mon, 20 May 2013 20:44:03 GMT

Hi ,

I still keep getting all missing values in the flg variable even though there are words starting with myocar

Where could i have gone wrong???

Re: sounds like function

Haikuo — Mon, 20 May 2013 21:17:27 GMT

Statring with "myocar" and Sounds like it are completely different concept, considering the scenario like this:

mmyocar vs myocar, NOT Starting, but very much Sound like;

while: myocarapdofhaposdjf vs myocar, nah.

data test;

a='myocaringhongtingdon';

output;

a='mmyocar';

output;

run;

data _null_;

set test;

if soundex(a)=soundex('myocar') then put a "Sound like";

else put a "NOT sound like";

run;

You need to be clear on what you are really after, then choose the right tools. Soundex works based on English pronunciation, if it does not meet your need, look for other options like spedis, complev, compare, compged.

Re: sounds like function

robertrao — Mon, 20 May 2013 21:30:37 GMT

Thanks for the detailed explanation. I appreciate your help.

Thanks...