Hello Everyone,

May I ask if anyone has an idea if we can generate a row of data in stata? If I have a row, and I need to generate another row, with exact values, however, then rename one variable value in the new row.

I have, for example:

Code:
geoid2           geodisplaylabel               median~e            popula~n          year
603393500       UpperLake-Clearlake       44.7               11596             2009
But I need to split these two words to be

Code:
geoid2           geodisplaylabel                median~e            popula~n          year
603393500       Clearlake                         44.7               11596             2009
603393500       UpperLake                       44.7               11596             2009
Thank you in advance,
Ali