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.
@Eugenio211 wrote:
Thank you.
how do you add another if statement?
Just type the next IF statement underneath the IF statement in my code.
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.
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 wrote:
Thank you.
how do you add another if statement?
Just type the next IF statement underneath the IF statement in my code.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.