Modify Character

[Eugenio211]

Hello!  I just want to ask assistance on how to change or modify characters.

below is the example that I'm working on:

LOCATION	CUSTOMER_KEY	City
1401	1000001	GRANDE PRAIRIE
1401	1000002	GRANDE PRAIRIE
1401	1000003	GRANDE PRAIRIE
1401	1000004	GRANDE PRAIRIE
1401	1000005	GRANDE PRAIRIE
1401	1000006	GRANDE PRAIRIE
1401	1000007	WHITECOURT
1401	1000008	GRANDE PRAIRIE
1401	1000009	GRANDE PRAIRIE
1401	1000010	GRANDE PRAIRIE
1401	1000011	WHITECOURT
1401	1000012	GRANDE PRAIRIE
1401	1000013	GRANDE PRAIRIE
1401	1000014	GRAND PRAIRIE
1401	1000015	GRANDE PRAIRIE
1401	1000016	GRANDE PRAIRIE
1401	1000017	GRANDE PRAIRIE
1401	1000018	GRANDE PRAIRIE
1401	1000019	GRANDE PRAIRIE
1401	1000020	WHITECOURT
1401	1000021	GRANDE PRAIRIE
1401	1000022	GRANDE PRAIRIE
1401	1000023	GRANDE PRAIRIE
1401	1000024	GRANDE PRAIRIE
1401	1000025	GRANDE PRAIRIE
1401	1000026	GRANDE PRAIRIE
1401	1000027	GRANDE PRAIRIE
1401	1000028	GRANDE PRAIRIE
1401	1000029	WHITECOURT
1401	1000030	WHITECOURT
1401	1000031	GRANDE PRAIRIE
1401	1000032	GRANDE PRAIRIE
1401	1000033	GRANDE PRAIRIE
1401	1000034	GRANDE PRAIRIE
1401	1000035	GRANDE PRAIRIE
1401	1000036	GRANDE PRAIRIE
1401	1000037	GRANDE PRAIRIE
1401	1000038	GRANDE PRAIRIE
1401	1000039	GRANDE PRAIRIE
1401	1000040	WHITECOURT
1401	1000041	GRANDE PRAIRIE
1401	1000042	GRAND PRAIRIE
1401	1000043	GRANDE PRAIRIE
1401	1000044	GRANDE PRAIRIE
1401	1000045	GRANDE PRAIRIE
1401	1000046	GRANDE PRAIRIE
1401	1000047	GRAND PRAIRIE
1401	1000048	GRANDE PRAIRIE
1401	1000049	GRANDE PRAIRIE
1401	1000050	GRANDE PRAIRIE
1401	1000051	GRANDE PRAIRIE
1401	1000052	GRANDE PRAIRIE
1401	1000053	GRANDE PRAIRIE
1401	1000054	GRANDE PRAIRIE
1401	1000055	GRANDE PRAIRIE
1401	1000056	GRAND PRAIRIE
1401	1000057	GRANDE PRAIRIE
1401	1000058	GRANDE PRAIRIE
1401	1000059	GRANDE PRAIRIE
1401	1000060	GRANDE PRAIRIE
1401	1000061	GRANDE PRAIRIE
1401	1000062	GRANDE PRAIRIE
1401	1000063	GRANDE PRAIRIE
1401	1000064	GRANDE PRAIRIE
1401	1000065	GRANDE PRAIRIE
1401	1000066	WHITE COURT
1401	1000067	GRANDE PRAIRIE
1401	1000068	GRANDE PRAIRIE
1401	1000069	GRANDE PRAIRIE
1401	1000070	GRANDE PRAIRIE
1401	1000071	GRANDE PRAIRIE
1401	1000072	GRANDE PRAIRIE
1401	1000073	WHITECOURT
1401	1000074	GRANDE PRAIRIE
1401	1000075	GRANDE PRAIRIE
1401	1000076	GRANDE PRAIRIE
1401	1000077	GRANDE PRAIRIE
1401	1000078	GRANDE PRAIRIE
1401	1000079	WHITECOURT
1401	1000080	GRANDE PRAIRIE
1401	1000081	GRANDE PRAIRIE
1401	1000082	GRANDE PRAIRIE
1401	1000083	GRANDE PRAIRIE
1401	1000084	GRANDE PRAIRIE
1401	1000085	GRANDE PRAIRIE
1401	1000086	WHITECOURT
1401	1000087	GRANDE PRAIRIE
1401	1000088	GRANDE PRAIRIE
1401	1000089	GRANDE PRAIRIE
1401	1000090	GRANDE PRAIRIE
1401	1000091	GRANDE PRAIRIE
1401	1000092	GRANDE PRAIRIE
1401	1000093	WHITECOURT
1401	1000094	GRANDE PRAIRIE
1401	1000095	GRANDE PRAIRIE
1401	1000096	WHITECOURT
1401	1000097	GRANDE PRAIRIE
1401	1000098	GRANDE PRAIRIE
1401	1000099	GRANDE PRAIRIE
1401	1000100	GRANDE PRAIRIE
1401	1000101	WHITECOURT
1401	1000102	GRANDE PRAIRIE
1401	1000103	WHITECOURT
1401	1000104	GRANDE PRAIRIE
1401	1000105	WHITECOURT
1401	1000106	GRANDE PRAIRIE
1401	1000107	GRANDE PRAIRIE
1401	1000108	GRANDE PRAIRIE
1401	1000109	GRANDE PRAIRIE
1401	1000110	GRANDE PRAIRIE
1401	1000111	GRANDE PRAIRIE
1401	1000112	GRANDE PRAIRIE
1401	1000113	GRANDE PRAIRIE
1401	1000114	GRANDE PRAIRIE
1401	1000115	GRANDE PRAIRIE
1401	1000116	GRANDE PRAIRIE
1401	1000117	GRANDE PRAIRIE
1401	1000118	WHITECOURT
1401	1000119	GRANDE PRAIRIE
1401	1000120	WHITECOURT
1401	1000121	GRANDE PRAIRIE

what I want to do is to make the City column uniform, like 'Grande Prairie' and 'GrandPairie' change to 'Grand Prairie'.

Thanks a lot.

[ballardw]

In a data step something like:

data want;
   set have;
   if city in ("GRANDE PRAIRIE" "GRANDPRAIRIE" ) then city = "GRAND PRAIRIE";
run;

Alternatively if you have a ZIP code you might be able to use the ZIPCITY function to extract the city name with consistent spelling though you will need to remove the state two-character code and if you really want all capital letters use the UPCASE function.

[PaigeMiller]

what I want to do is to make the City column uniform, like 'Grande Prairie' and 'GrandPairie' change to 'Grand Prairie'.

First, I point out that none of the city names in your example data set is either 'Grande Prairie' nor 'Grand Pairie'. Some of the city names are 'GRANDE PRAIRIE' (capital letters).

If all you want is to fix this one very specific typographical error

data want;
    set have;
    if city='GRANDE PAIRIE' or city='GRANDE PRAIRIE' then city='GRAND PRAIRIE';
run;

If there could be typographical errors in any city name, I don't think there's an easy solution.

[Eugenio211]

Thank you.
how do you add another if statement?

[PaigeMiller · Accepted solution]

---

@Eugenio211 wrote:
Thank you.
how do you add another if statement?

---

Just type the next IF statement underneath the IF statement in my code.

[Eugenio211]

Thank you so much.