replacing text in a data set

geneshackman — Sat, 27 Feb 2021 23:44:06 GMT

I have a data set that has a variable, "Group". Some cases have the value "Urban-Rural Residence". Some other cases have a value that is almost the same, but for some reason not exactly the same, although I don't see how. Excel thinks the other value is exactly the same.

I doubt it would be worth it to post or send a data set, because I'm not sure if any data set i post or send would actually have the difference in values.

Instead, I would like have code that says the following, and my question is how to do it.

If the value includes the string "Urban" then Group = "Urban-Rural Residence";

Thus, i would find some part of the value that hopefully is identical in all versions of the value, and just manually make them all have the same value.

There seem to be a bunch of sas functions that might do this, but I don't quite get the difference in them all, even though I've searched a bit and read a bunch of stuff. What's the difference between contain, find, findw, index? Or would I use some other function?

Thanks

Gene

Re: replacing text in a data set

Shmuel — Sun, 28 Feb 2021 01:16:31 GMT

Try:

group = compress(group,,'kA');

if index(group,'Urban') then group = "Urban-Rural Residence";

Re: replacing text in a data set

geneshackman — Sun, 28 Feb 2021 02:17:11 GMT

Thanks very much. This one worked.
if index(group,'Urban') then group = "Urban-Rural Residence";

topic Re: replacing text in a data set in SAS Programming

replacing text in a data set

Re: replacing text in a data set

Re: replacing text in a data set