I would like to know how to collapse a data with two ID variables. For some variables, I wanted the first value and for some variables I wanted the last variable. This is a data frame contains around 25 variables and around 600 thousand observations with 64 repetitions. After collapse, depending on the ID variables the data may get reduced to below 200 thousand observations.
Thanks in advance