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
Problem with a counterfactual analysis of the Theil-index decompositionHi Statalist, I'm writing a paper concerning changes in in wage-inequality over time in relation to …
ivregress and suestHi, I'm trying to use Oaxaca decomposition and within that, I'm trying to estimate the models using…
outlier results interpretationDear Statalits, I hope you are well. Could you please help me on interpret the below table shows re…
Have question about winsor2 proceduresDear Statalists, I hope you are well. I would like to ask you please about the process of using the…
Number of unique firms/ industriesHi I have a panel data. Gvkey is an identifier for firms and Fyear is an identifier for year. Sic is…
Subscribe to:
Post Comments (Atom)
0 Response to Combine multiple rows into one when end_date = start_date
Post a Comment