Hi there,
I am looking for a code that combine the rows when end_date = start_date for a certain ID when all the variables have same values. For example, in the table below, ID 1 has 4 rows and their variables x and y have the same values in each rows under ID 1. ID 1 has end_date=start_date in each of its row. In that case, ID 1 will be combined into one row that will show the very first start_date and very last end_date.
id start_date end_date x y
1 10 12 10 12
1 12 14 10 12
1 14 16 10 12
1 16 21 10 12
2 11 13 15 17
2 13 15 15 17
3 16 18 20 22
3 18 20 20 22
3 20 25 20 22
Result will look like this:
id start_date end_date x y
1 10 21 10 12
2 11 15 15 17
3 16 25 20 22
I am seeking for help to get the code.
Thank you.
Kind regards,
Rakib
Related Posts with Combine multiple rows into one when end_date = start_date
Preliminary analysis using latent variablesHello, I am running a mediation model where I plan to use two latent variables as mediators. For pr…
ivreg2h : (1) for panel data? (2) the same command for single equation and set of fully simultaneous equations?Dear Stata list members, I want to analyze a model using Lewbel's (2012) method of internal instrum…
deflate data using 1980 valueDear All, I found this question here (http://bbs.pinggu.org/forum.php?mod=...a=#pid55243106). The da…
Diff in Diff with different timesDear Statalisters, I am studying the following question: "What is the impact of distributing divide…
invariant regressorsDear all, I can't understand what's going on.. I have panel data and when i run BE in stata, indivi…
Subscribe to:
Post Comments (Atom)
0 Response to Combine multiple rows into one when end_date = start_date
Post a Comment