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
Multiple lines (>100) on a tsline plot?Hello, I have some panel data that spans 5 years (2000-2005) and 150 countries with LN GDP Per Capi…
Averaging with a condition while generating a new variableHi there! I have household-level data with unique household_id. For each household, I have data for…
cgmreg - error messageHi, I'm relatively new to stata, and cant seem to get around this error message. I am trying to car…
how can we draw a nomogram in 10 multiple imputated dataset?Hello Members, I am a new Stata user and now trying to write a paper about prediction model. But we…
Saving value (N or percentage) after a tabulate command and using it in putdocxHi STATA-users, I ´d like to write my report directly in stata with the putdocx tool and want to re…
Subscribe to:
Post Comments (Atom)
0 Response to Combine multiple rows into one when end_date = start_date
Post a Comment