topic Re: How Compare two strings by percentage in SAS Programming

How Compare two strings by percentage

shubha1babu — Thu, 29 Mar 2018 12:30:41 GMT

Hello All,

I have two variable var1 var2.

In var1 character is like "marutivx" and In var2 character is like "marutivx(0)". I need to calculate the similarities/differences by percentage.

Please help on little urgent basis.

Thanks,

Shubho

Re: How Compare two strings by percentage

tomrvincent — Thu, 29 Mar 2018 13:28:17 GMT

This will help you: http://support.sas.com/kb/48/582.html

Re: How Compare two strings by percentage

Ksharp — Thu, 29 Mar 2018 13:28:28 GMT

That is a tough task. How you define similarities/differences ?

Anyway, COMPARE() might give you a little help.

data _null_;
var1="marutivx";var2="marutivx(0)";
diff=compare(var1,var2,'i');
put var1= var2= diff=;
run;

Re: How Compare two strings by percentage

shubha1babu — Fri, 30 Mar 2018 05:07:49 GMT

Let me frame it once again.

I have 1000 obs. and two variables var1 and var2.I want to create 3rd variable which will show the similarities/differences between two strings by percentage wise.

ex.

var1 var2

maruti marutix

vxez vexz12

LX CNG

JHXD GX

and so on......

Re: How Compare two strings by percentage

tomrvincent — Fri, 30 Mar 2018 12:05:14 GMT

That's what my previous post covers...the complev function.

Re: How Compare two strings by percentage

shubha1babu — Fri, 30 Mar 2018 18:08:05 GMT

Great!! Thanks a lot Tom.It worked.

But I need little more help.Need to compare two strings by first 5 alphabets.

e.g var1 var 2 match_parentage

marutix marutisyz 100

Thanks.

Re: How Compare two strings by percentage

ballardw — Fri, 30 Mar 2018 20:18:32 GMT

@shubha1babu wrote:

Great!! Thanks a lot Tom.It worked.

But I need little more help.Need to compare two strings by first 5 alphabets.

e.g var1 var 2 match_parentage

marutix marutisyz 100

Thanks.

Use the SUBSTR function to select the first 5 characters from each variable.

result = complev(substr(var1,1,5), substr(var2,1,5));