Rename in SAS

[aabbccwyt]

Hi, 

Like shown in the screenshot, Michigan is misspelled as Michiigan and I'm suppose to fix the error. 

Here is what I have:

data Location;
        rename Michiggan = Michigan;
run;

Can anyone tell me what I did wrong please? Thank you.

[Jagadishkatam · Accepted solution]

I believe you should have a sas dataset with column A info, if yes, then you should try the below code

data Location;
set have;
        if columnA='Michiggan' then columnA = 'Michigan';
run;

[aabbccwyt]

Thank you. It worked.

[unison]

Hi there try:

data have;
location='Michiggan, MI';
output;
location='Ohio, OH';
output;
run;

data want;
set have;
if scan(location,1,',','it')='Michiggan' then location='Michigan, MI';
run;

-unison

[ballardw]

RENAME is used to change the Name of a variable, the values of a variable.

Hint: if you are going to work with address type date, city and state as shown, you should have a separate column for the City and separate for the State. Best is to accomplish this as the data is brought into SAS.

If your data has a ZIP code value you might want to investigate the ZIPCITY function.

data example;
    zip=49861;
    city = zipcity(zip);
run;

Which returns "Michigamme, MI"

So you may also want to check what the actual correct value is supposed to be. Is that supposed to be the STATE name in long form (in which case your Atlanta, GA is questionable) or the name of a city in the state (I don't find a city named Michigan though there is a Michigan Center  ZIP=49254).