Hi,
I am trying to drop some of my repeated observations. I attached a screenshot, there are multiple observations for some of the ids. I want to drop extra observations for a unique person. For instance, for the id:945000 there are 3 rows, I want to decrease it to 1 since variable "ilk" takes " ." for all observations. For id:1028000 I want to drop the first row since the variable "ilk" takes "." for the first partner and keep observation for the second partner since it has a numeric value. I have 4994 unique cases, and they may have multiple partners. if you have any simple suggestions for solving this, I will be glad.
Related Posts with dropping multiple observations for same ids
Extraction of submatrix containing probit estimatesI want to extract submatrices of the coefficient vector and the var/cov matrix which are returned fo…
import excel and reshapeDear All, I have this data set in excel as: Array and data is here test.xlsx. How can I obtain the …
PvarI am using 7 countries and 7 variables for the 19 years. My problem is that pvarsoc does not work. I…
Use outreg2 on multiple analysesHello, Running the module fairlie produces two tables: logistic regression and decomposition, and i…
Scatter plot: individual slope versus baseline GFRDear Stata users, I am trying to create a scatter plot of individual slopes (GFR) versus baseline …
Subscribe to:
Post Comments (Atom)
0 Response to dropping multiple observations for same ids
Post a Comment