BookmarkSubscribeRSS Feed
Ksharp
Super User

If you are trying to make some EDIT DISTANCE for two string, then PG 's suggest is good, SAS has already built-in some function for that purpose.

Otherwise , try

data have;
input obs var1 $ var2 $;
datalines;
1 RAT CAT
2 BELL BALL
3 TIME TOM
;
run;
data want(drop=n i);
 set have;
 n=0;
 do i=1 to length(var1);
  if char(var1,i) ne char(var2,i) then n+1;
 end;
 dif=divide(n,length(var1));
run;

Xia Keshan

3 REPLIES 3
JAR
Obsidian | Level 7 JAR
Obsidian | Level 7

Thank you so much!

JAR
Obsidian | Level 7 JAR
Obsidian | Level 7

HI KSharp,

How will I use the same logic for two different string, where words (unlike character here) have pattern:

Here is an example:

String 1: "It is a cat"

String 2: "This is a cat"

Can I use SAS to calculate that "String2 is 25% different from String1"?

Jijil Ramakrishnan

Ksharp
Super User

OK. No problem.

data have;
input obs var1 & $40. var2 & $40.;
datalines;
1 It is a cat    This is a cat
2 a fox jump over a dog    Tom cat jump over a dog
;
run;
data want(drop=n i);
 set have;
 n=0;
 do i=1 to countw(var1);
  if upcase(scan(var1,i)) ne upcase(scan(var2,i)) then n+1;
 end;
 dif=divide(n,countw(var1));
run;

Xia Keshan

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1199 views
  • 0 likes
  • 2 in conversation