I tried most suggestions on here, unfortunately I couldn't solve it.
I have a long data of more than 100 variables. I want to generate a new variable for each of them. I wanted to copy their corresponding labels from the old variable.
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input long GeoFips int(LineCode years) str20 GeoName str95 Description long y str6 newvar 1000 100 1998 "Alabama" " Forestry, fishing, and related activities" 19434 "ffr" 1000 100 1998 "Alabama" " Forestry, fishing, and related activities" 19434 "ffr" 1000 100 1998 "Alabama" " Forestry, fishing, and related activities" 19434 "ffr" 1000 100 1999 "Alabama" " Forestry, fishing, and related activities" 18375 "ffr" 1000 100 1999 "Alabama" " Forestry, fishing, and related activities" 18375 "ffr" 1000 100 1999 "Alabama" " Forestry, fishing, and related activities" 18375 "ffr" 1000 100 2000 "Alabama" " Forestry, fishing, and related activities" 17131 "ffr" 1000 100 2000 "Alabama" " Forestry, fishing, and related activities" 17131 "ffr" 1000 100 2000 "Alabama" " Forestry, fishing, and related activities" 17131 "ffr" 1000 100 2001 "Alabama" " Forestry, fishing, and related activities" . "ffr" 1000 100 2001 "Alabama" " Forestry, fishing, and related activities" . "ffr" 1000 100 2001 "Alabama" " Forestry, fishing, and related activities" . "ffr" 1000 100 2002 "Alabama" " Forestry, fishing, and related activities" 16955 "ffr" 1000 100 2002 "Alabama" " Forestry, fishing, and related activities" 16955 "ffr" 1000 100 2002 "Alabama" " Forestry, fishing, and related activities" 16955 "ffr" 1000 100 2003 "Alabama" " Forestry, fishing, and related activities" 15553 "ffr" 1000 100 2003 "Alabama" " Forestry, fishing, and related activities" 15553 "ffr" 1000 100 2003 "Alabama" " Forestry, fishing, and related activities" 15553 "ffr" 1000 100 2004 "Alabama" " Forestry, fishing, and related activities" 16099 "ffr" 1000 100 2004 "Alabama" " Forestry, fishing, and related activities" 16099 "ffr" 1000 100 2004 "Alabama" " Forestry, fishing, and related activities" 16099 "ffr" 1000 100 2005 "Alabama" " Forestry, fishing, and related activities" 15875 "ffr" 1000 100 2005 "Alabama" " Forestry, fishing, and related activities" 15875 "ffr" 1000 100 2005 "Alabama" " Forestry, fishing, and related activities" 15875 "ffr" 1000 100 2006 "Alabama" " Forestry, fishing, and related activities" 15742 "ffr" 1000 100 2006 "Alabama" " Forestry, fishing, and related activities" 15742 "ffr" 1000 100 2006 "Alabama" " Forestry, fishing, and related activities" 15742 "ffr" 1000 100 2007 "Alabama" " Forestry, fishing, and related activities" 15627 "ffr" 1000 100 2007 "Alabama" " Forestry, fishing, and related activities" 15627 "ffr" 1000 100 2007 "Alabama" " Forestry, fishing, and related activities" 15627 "ffr" 1000 100 2008 "Alabama" " Forestry, fishing, and related activities" 15837 "ffr" 1000 100 2008 "Alabama" " Forestry, fishing, and related activities" 15837 "ffr" 1000 100 2008 "Alabama" " Forestry, fishing, and related activities" 15837 "ffr" 1000 100 2009 "Alabama" " Forestry, fishing, and related activities" 14939 "ffr" 1000 100 2009 "Alabama" " Forestry, fishing, and related activities" 14939 "ffr" 1000 100 2009 "Alabama" " Forestry, fishing, and related activities" 14939 "ffr"
I would like to avoid labeling each new variable by the same text already in "Description"
Code:
gen newvar="X" replace newvar="ffr" if Description=="Forestry, fishing, and related activities"
Code:
gen newvar="X" replace newvar="ffr" if Description=="Forestry, fishing, and related activities"
ffr
Forestry, fishing, and related activities
0 Response to copy variable labels
Post a Comment