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));
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.