I'm normally pretty competent when it comes to reshaping data. However, I am running into trouble here reshaping long.


Code:
reshape long value, i(state) j(yearID)
I'm running a pretty simple reshape command. In my original data below I have 14 variables. I want to instead have 3. State, yearID, and value. However, my reshape command is giving my 16 variables. It is preserving the original 14 and then adding a yeartest variable which looks correct, and then the value variable is all missing values.

I'm not sure what I am doing incorrect.






Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str2 stateab int(value20060061 value20100061 value20120061 value20130061 value20140061 value20145161 value20155161 value20165161 value20175161 value20185161 value20195161 value20205161 value20215161)
"AK" 146 146   .   .   . 160 160 160 160 160 160 160 160
"CT" 137 137 137 137 137   . 160 160 160 160 160 160 160
"DC" 141 141 141 141   . 160 160 160 160 160 160 160 160
"DE" 141 141 141 141   . 160 160 160 160 160 160 160 160
"IA"   .   .   . 125   . 160 134 132 134 135 135 135 135
"ID" 119 129 129 129   . 160 160 160 160 160 160 160 160
"KS" 137 137 137 137   . 152 152 152 152 152 152 152 152
"LA" 125 135 135 135 135   . 160 160 160 160 160 160 160
"MD" 141 141 141 141 141 160 160 160 160 160 160 160 160
"ME" 126 126 126 126   . 160 160 160 160 160 160 160 160
"MS" 123 123 123 128   . 160 160 160 160 160 152 152 152
"MT"   . 128 128 128 128 160 160 160 160 160 160 160 160
"NC"   .   .   .   .   . 160 160 160 160 160 160 160 160
"ND" 139 139 139 139   . 160 160 160 160 160 160 160 160
"NH" 127 127 127 127   . 160 160 160 160 160 160 160 160
"NV"   . 133 133 133   . 160 160 160 160 160 160 160 160
"RI"   .   .   .   . 142   . 160 160 160 160 160 160 160
"SC" 131 131 131 131   . 160 160 160 150 150 150 150 150
"SD" 124 124 124 124   . 160 160 160 160 160 160 160 160
"TN" 136 136 136 136   . 160 160 160 160 160 160 160 160
"UT" 138 138 138 138   . 160 160 160 160 160 160 160 160
"VA" 147 147 147 147 147   . 160 160 160 160 160 160 160
"VT" 141 141 141 141   . 160 160 160 160 160 160 160 160
"WI" 133 135   .   .   .   . 160 160 160 160 160 160 160
"WV" 133 133 133 133   . 160 160 160 160 160 160 160 160
end