topic Re: how to group/ do correction for similar character value in SAS Programming

how to group/ do correction for similar character value

chenzinc — Mon, 22 Nov 2021 07:31:30 GMT

I am validating a huge 8000 observations dataset. And there is one column named Brand.

what the data shows:

Nike

nikes

nikeshoe

Nike shoe

nike brand

Nike.

what i want:

Nike

how can I do corrections and group them together?

ChrisNZ — Tue, 23 Nov 2021 04:24:46 GMT

How?
You need to define rules and apply them.

You cannot do 2 until you've done 1.

How do you decide to group these characters strings into the same group?

chenzinc — Tue, 23 Nov 2021 12:12:47 GMT

how can I change all the strings name to just only Nike?

Ksharp — Tue, 23 Nov 2021 12:50:55 GMT

if find(have,'nike','i') then flag='Nike' ;

ChrisNZ — Wed, 24 Nov 2021 01:39:36 GMT

so Moniker is a good match? pannikel too?

ChrisNZ — Wed, 24 Nov 2021 01:41:12 GMT

> how can I change all the strings name to just only Nike?

Since you make no rules then this code matches your requirements:

if 1 then STRING='Nike';

Ksharp — Wed, 24 Nov 2021 11:53:36 GMT

Chris,
I don't realize it is a fuzz match problem. Just gave OP a start point .