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
This will help you: http://support.sas.com/kb/48/582.html
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;
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......
That's what my previous post covers...the complev function.
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.
@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));
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.