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?
Foreach loopHi all, I please have another question. So I have variables Revenue_GDP, Expenditure_GDP, Consumpt…
one sided test of proportions using svyI am trying to do a one sided test of proportions with survey data. I've svyset the data. Normally I…
Checking merges over a very large number of filesMy apologies in advance if this has been covered - I have looked but haven't found anything quite th…
How to construct a new variable by singling out one or more words from a longer phrase?I want to have a new variable which is constructed by taking out one or more words after "Battle of …
endogeneityDear researchers, I am using the generalized DID model “Two way-fixed effect”. I have more than two …
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