Hello,
I have a database that has repeated observations on a single variable. The problem is that the variable is a string type. I would like to develop a program in which it takes for example the first obs of the variable, then compare it to all the others and in the case that it is repeated the program could erase all but one, so there is just one and not a lot of repeated variables
Something like this:
var x
1 SAN JAVIER
2 SAN JAVIER
3 MATEGUA
4 OROBAYAYA
5 SAN JAVIER
6 OROBAYAYA
7 SUCRE
Related Posts with How to keep only the observations that are not repeated on a single string variable?
Matching values from a panel dataset to a cross-section datasetDear all, I hope you can help me with what seems to be a rather simple issue that i cannot seem to f…
Plot recurrent event survival model(PWP-TT) with Time-Dependent effectsHi everyone, i'm working on a dataset with counting process structure. I have something like this: …
Keep running a replace command until (0 real changes made)Hello! I have a paneldata with the ages of individuals with around 50 million observations. The age …
Drop panel-observations if data have no countHi everyone I have the variables "year" (2009-2019) for each "company key" (e.g.: 1661) and two co…
Apply values across all in the same groupHi all, I have a dataset of about 10k participants across 600 groups (ParentSiteID in the dataset). …
Subscribe to:
Post Comments (Atom)
0 Response to How to keep only the observations that are not repeated on a single string variable?
Post a Comment