Bellow an example of the data I have. I need to use only the cities "City" and drop "CDP".
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str51 geodisplaylabel double median_age float year "Acalanes Ridge CDP, California" 44.1 2017 "Acampo CDP, California" 53.1 2017 "Acton CDP, California" 50.2 2017 "Adelanto city, California" 27.5 2017 "Adin CDP, California" 43.9 2017 "Agoura Hills city, California" 44 2017 "Agua Dulce CDP, California" 47.3 2017 "Aguanga CDP, California" 56.5 2017 "Ahwahnee CDP, California" 60 2017 "Airport CDP, California" 28.3 2017 "Alameda city, California" 41 2017 "Alamo CDP, California" 48.8 2017 "Albany city, California" 35.7 2017 "Albion CDP, California" 27.3 2017 "Alderpoint CDP, California" 55.1 2017 "Alhambra city, California" 40.9 2017 "Alhambra Valley CDP, California" 49.5 2017 "Aliso Viejo city, California" 36.6 2017 "Alleghany CDP, California" . 2017 "Allendale CDP, California" 54.1 2017 "Allensworth CDP, California" 24.4 2017 "Almanor CDP, California" . 2017 "Alondra Park CDP, California" 36 2017 "Alpaugh CDP, California" 24.4 2017 "Alpine CDP, California" 41.8 2017 "Alpine Village CDP, California" 47.8 2017 "Alta CDP, California" 57.2 2017 "Altadena CDP, California" 43.7 2017 "Alta Sierra CDP, California" 49.5 2017 "Alto CDP, California" 50.6 2017 "Alturas city, California" 43.6 2017 "Alum Rock CDP, California" 32.4 2017 "Amador City city, California" 39.1 2017 "American Canyon city, California" 36.4 2017 "Amesti CDP, California" 33.5 2017 "Anaheim city, California" 34 2017 "Anchor Bay CDP, California" 66.8 2017 "Anderson city, California" 34.2 2017 "Angels city, California" 55 2017 "Angwin CDP, California" 25.9 2017 "Antelope CDP, California" 33.6 2017 "Antioch city, California" 35.2 2017 "Anza CDP, California" 38.3 2017 "Apple Valley town, California" 37.2 2017 "Aptos CDP, California" 47.9 2017 "Aptos Hills-Larkin Valley CDP, California" 47.7 2017 "Arbuckle CDP, California" 30.8 2017 "Arcadia city, California" 43.9 2017 "Arcata city, California" 25.4 2017 "Arden-Arcade CDP, California" 37.5 2017 "Armona CDP, California" 28.6 2017 "Arnold CDP, California" 57.4 2017 "Aromas CDP, California" 42.1 2017 "Arroyo Grande city, California" 47.5 2017 "Artesia city, California" 39 2017 "Artois CDP, California" 19.4 2017 "Arvin city, California" 24.4 2017 "Ashland CDP, California" 32.4 2017 "Aspen Springs CDP, California" 46.5 2017 "Atascadero city, California" 38.2 2017 "Atherton town, California" 49.4 2017 "Atwater city, California" 30.3 2017 "Auberry CDP, California" 44.6 2017 "Auburn city, California" 48 2017 "Auburn Lake Trails CDP, California" 48.4 2017 "August CDP, California" 29.3 2017 "Avalon city, California" 34.5 2017 "Avenal city, California" 31.2 2017 "Avery CDP, California" 38.4 2017 "Avila Beach CDP, California" 63.1 2017 "Avocado Heights CDP, California" 36.6 2017 "Azusa city, California" 29.3 2017 "Baker CDP, California" 30.2 2017 "Bakersfield city, California" 30.5 2017 "Baldwin Park city, California" 33.9 2017 "Ballard CDP, California" 48.2 2017 "Ballico CDP, California" 34.6 2017 "Bangor CDP, California" 58.1 2017 "Banning city, California" 40 2017 "Barstow city, California" 30 2017 "Bass Lake CDP, California" 63.9 2017 "Bay Point CDP, California" 30.6 2017 "Bayview CDP (Contra Costa County), California" 41.8 2017 "Bayview CDP (Humboldt County), California" 42.6 2017 "Beale AFB CDP, California" 24.8 2017 "Bear Creek CDP, California" 56.2 2017 "Bear Valley CDP (Alpine County), California" 44.8 2017 "Bear Valley CDP (Mariposa County), California" 30.4 2017 "Bear Valley Springs CDP, California" 56.7 2017 "Beaumont city, California" 35 2017 "Beckwourth CDP, California" 56 2017 "Belden CDP, California" . 2017 "Bell city, California" 30 2017 "Bella Vista CDP, California" 49.4 2017 "Bell Canyon CDP, California" 47.1 2017 "Bellflower city, California" 34.1 2017 "Bell Gardens city, California" 28.4 2017 "Belmont city, California" 39.6 2017 "Belvedere city, California" 53.5 2017 "Benbow CDP, California" 40.3 2017 end
Code:
gen city = subinstr(geodisplaylabel, " city, California", "", .)
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str51 city float year double median_age "Acalanes Ridge CDP, California" 2017 44.1 "Acampo CDP, California" 2017 53.1 "Acton CDP, California" 2017 50.2 "Adelanto" 2017 27.5 "Adin CDP, California" 2017 43.9 "Agoura Hills" 2017 44 "Agua Dulce CDP, California" 2017 47.3 "Aguanga CDP, California" 2017 56.5 "Ahwahnee CDP, California" 2017 60 "Airport CDP, California" 2017 28.3 "Alameda" 2017 41 "Alamo CDP, California" 2017 48.8 "Albany" 2017 35.7 "Albion CDP, California" 2017 27.3 "Alderpoint CDP, California" 2017 55.1 "Alhambra" 2017 40.9 "Alhambra Valley CDP, California" 2017 49.5 "Aliso Viejo" 2017 36.6 "Alleghany CDP, California" 2017 . "Allendale CDP, California" 2017 54.1 "Allensworth CDP, California" 2017 24.4 "Almanor CDP, California" 2017 . "Alondra Park CDP, California" 2017 36 "Alpaugh CDP, California" 2017 24.4 "Alpine CDP, California" 2017 41.8 "Alpine Village CDP, California" 2017 47.8 "Alta CDP, California" 2017 57.2 "Altadena CDP, California" 2017 43.7 "Alta Sierra CDP, California" 2017 49.5 "Alto CDP, California" 2017 50.6 "Alturas" 2017 43.6 "Alum Rock CDP, California" 2017 32.4 "Amador City" 2017 39.1 "American Canyon" 2017 36.4 "Amesti CDP, California" 2017 33.5 "Anaheim" 2017 34 "Anchor Bay CDP, California" 2017 66.8 "Anderson" 2017 34.2 "Angels" 2017 55 "Angwin CDP, California" 2017 25.9 "Antelope CDP, California" 2017 33.6 "Antioch" 2017 35.2 "Anza CDP, California" 2017 38.3 "Apple Valley town, California" 2017 37.2 "Aptos CDP, California" 2017 47.9 "Aptos Hills-Larkin Valley CDP, California" 2017 47.7 "Arbuckle CDP, California" 2017 30.8 "Arcadia" 2017 43.9 "Arcata" 2017 25.4 "Arden-Arcade CDP, California" 2017 37.5 "Armona CDP, California" 2017 28.6 "Arnold CDP, California" 2017 57.4 "Aromas CDP, California" 2017 42.1 "Arroyo Grande" 2017 47.5 "Artesia" 2017 39 "Artois CDP, California" 2017 19.4 "Arvin" 2017 24.4 "Ashland CDP, California" 2017 32.4 "Aspen Springs CDP, California" 2017 46.5 "Atascadero" 2017 38.2 "Atherton town, California" 2017 49.4 "Atwater" 2017 30.3 "Auberry CDP, California" 2017 44.6 "Auburn" 2017 48 "Auburn Lake Trails CDP, California" 2017 48.4 "August CDP, California" 2017 29.3 "Avalon" 2017 34.5 "Avenal" 2017 31.2 "Avery CDP, California" 2017 38.4 "Avila Beach CDP, California" 2017 63.1 "Avocado Heights CDP, California" 2017 36.6 "Azusa" 2017 29.3 "Baker CDP, California" 2017 30.2 "Bakersfield" 2017 30.5 "Baldwin Park" 2017 33.9 "Ballard CDP, California" 2017 48.2 "Ballico CDP, California" 2017 34.6 "Bangor CDP, California" 2017 58.1 "Banning" 2017 40 "Barstow" 2017 30 "Bass Lake CDP, California" 2017 63.9 "Bay Point CDP, California" 2017 30.6 "Bayview CDP (Contra Costa County), California" 2017 41.8 "Bayview CDP (Humboldt County), California" 2017 42.6 "Beale AFB CDP, California" 2017 24.8 "Bear Creek CDP, California" 2017 56.2 "Bear Valley CDP (Alpine County), California" 2017 44.8 "Bear Valley CDP (Mariposa County), California" 2017 30.4 "Bear Valley Springs CDP, California" 2017 56.7 "Beaumont" 2017 35 "Beckwourth CDP, California" 2017 56 "Belden CDP, California" 2017 . "Bell" 2017 30 "Bella Vista CDP, California" 2017 49.4 "Bell Canyon CDP, California" 2017 47.1 "Bellflower" 2017 34.1 "Bell Gardens" 2017 28.4 "Belmont" 2017 39.6 "Belvedere" 2017 53.5 "Benbow CDP, California" 2017 40.3 end
I should drop all the cities with CDP, such as Ballard in "Ballard CDP, California". Would anyone help with this, please?
Thanks
Ali
0 Response to Splitting words
Post a Comment