Dear members,
I have a panel dataset and I would like to append another dataset to it which has the same set of identifiers and years. It is essentially a duplicate which has different values for the variables. The reason I want to do this is so that I can create xtline graphs to compare the two sets of data for the variable x where the IDs are on the y axis and year on the x axis. For example, two red lines for ID 1, two green lines for ID 2.
I have figured out how to plot separate graphs and put it side by side for comparison. But to enable better comparison, I would like to combine the datasets and plot them together on the same graph. Any help on how to combine the two datasets and obtain a single graph comparing them would be greatly appreciated.
Example data
I want to turn this:
clear
input int(id year x_1)
1 1992 160
1 1993 120
1 1994 179
1 1996 121
2 1992 140
2 1993 187
2 1994 230
2 1995 308
2 1996 80
3 1992 76
3 1993 200
3 1994 190
3 1995 120
3 1996 82
end
into this:
clear
input int(id year x_1)
1 1992 160
1 1992 180
1 1993 120
1 1993 123
1 1994 179
1 1995 180
1 1998 190
1 1996 121
1 1996 130
2 1992 140
2 1992 180
2 1993 187
2 1993 198
2 1994 230
2 1994 160
2 1995 308
2 1995 210
2 1996 80
2 1996 120
3 1992 76
3 1992 134
3 1993 200
3 1993 208
3 1994 190
3 1994 209
3 1995 120
3 1995 170
3 1996 82
3 1996 120
end
Related Posts with Combining panel datasets with the same IDs and years to create advanced graphs
Tabulating and dropping grouped dataHi, I have a dataset based on a survey where each individual is given a unique id and has several r…
Propensity score matching and outcome variableDear all, I am trying to create a control group using Propensity score matching. The idea is to sel…
Combining multi-item measuresHello, I have 10 variables that all measure how much an individual compares himself to society on a…
Combining meglm and svy: error messageOur goal is to build a three-level hierarchical linear model based on complex survey design in Stata…
Robust Estimation - VAR modelHello all, How do I perform robust estimation in VAR to correct for presence of any heteroskedastic…
Subscribe to:
Post Comments (Atom)
0 Response to Combining panel datasets with the same IDs and years to create advanced graphs
Post a Comment