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
Output t-test resultsHi, I performed t-tests for many variables in my dataset. I have written code as following: foreac…
Uploading new data sets Date Crude Oil Production, Norway Crude Oil Production, World Global Real Economic Activity Based…
Looping and Recodinglooping and recoding Hello, I am trying to reverse code pt_bbq1_ - pt_bbq14_ below There are 5 poss…
Question of replaceMy dataset contains a varible of sex, the formate of which is string and the value of which contain …
Calculating Age from two variablesHello everyone, I have a dataset like this- input str4 hsn double cdob str10 bqdate_1 "1004" 19251 …
Subscribe to:
Post Comments (Atom)
0 Response to dropping multiple observations for same ids
Post a Comment