Hello,
I am updating a .dta file that looks like this:
I am updating pre 1999 and post 2010, and currently have a .csv in state, year, v1 formula. It looks like this when imported:
How can I use stata to transpose/reformat the .csv I have so it can be added to the file I am updating? In other words, I need years to become the variables and have just one instance of each state.
Thank you!
Note: I realize I haven't changed "n.a." to . yet.
I am updating a .dta file that looks like this:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str14 statename int(et_gits1999 et_gits2000 et_gits2001) "Alabama" . . . "Alaska" 185 185 185 "Arizona" 185 185 185 "Arkansas" . . . "California" . . . end
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str110 state str85 year str4 et_gits "Alabama" "1997" "n.a." "Alabama" "1998" "n.a." "Alabama" "1999" "n.a." "Alabama" "2000" "n.a." "Alaska" "1997" "185" "Alaska" "1998" "185" "Alaska" "1999" "185" "Alaska" "2000" "185" end
How can I use stata to transpose/reformat the .csv I have so it can be added to the file I am updating? In other words, I need years to become the variables and have just one instance of each state.
Thank you!
Note: I realize I haven't changed "n.a." to . yet.
Comment