Hi all,
I have a dta file with data set as :
fid year tbl_2001 tbl_2002 tbl_2003 tbl_2004 tbl_2005
2 2001 5 7 9 3 2
2 2002 5 7 9 3 2
2 2003 5 7 9 3 2
2 2004 5 7 9 3 2
2 2005 5 7 9 3 2
5 2001 6 1 8 4 3
5 2002 6 1 8 4 3
5 2003 6 1 8 4 3
5 2004 6 1 8 4 3
5 2005 6 1 8 4 3
7 2001 0 3 7 9 1
7 2002 0 3 7 9 1
7 2003 0 3 7 9 1
7 2004 0 3 7 9 1
7 2005 0 3 7 9 1
And I want to create a new variable “tbl” to replace variables (tbl_2001 tbl_2005) as the following data set :
fid year tbl
2 2001 5
2 2002 7
2 2003 9
2 2004 3
2 2005 2
5 2001 6
5 2002 1
5 2003 8
5 2004 4
5 2005 3
7 2001 0
7 2002 3
7 2003 7
7 2004 9
7 2005 1
- How can I get the value of year via the position of variable such as year[1] = 2001, year [2] =2002
- Do you have any suggestions to change the data set?
Thank you in advance.
Hut98
Related Posts with Create a new variable to combine the value of other variables
Table of Sums Without Collapse?Hi Stata Friends - I'm back with a question regarding creating a table of values. I want to ascerta…
Dropping unmatched dataHi everyone, I need some help in processing data for my phd research. I started with a dataset inclu…
Endogeneity 2SLSHi there, I have to report on the difference in estimates of 2SLS and OLS (same model) and the endo…
Need help with creating a Growth Incidence Curve in Stata. I am very new to this wonderful software.Hey there! My name is Philip and I'm currently studying for a bachelors degree in economics. I reall…
Wanted: New Home for Survey Sampling textsI've retired from professional work and I'd like to donate the stat books in my library to a good ho…
Subscribe to:
Post Comments (Atom)
0 Response to Create a new variable to combine the value of other variables
Post a Comment