Recently I encountered an issue. I downloaded some data from the Census and Social Explorer and merged them together. Presumably, most of the data from other sources are from the Census but were recoded, renamed or reorganized in more accessible ways. That said, some of them are the same thing but with different variable names, for example, the population of a county. I know "compare" command can compare variables and see if they are identical, but it can only compare two variables. "sum" can list some statistics that compare the variables, but chances are that some variables just happened to have the same mean, sd, min, max, but are not identical. I was wondering if there is an extended version of "compare" that compare all the variables and identify the identical variables. Thanks.
Related Posts with compare all the variables and get rid of the duplicated variables with different variable name
Resolving "Initial values not feasible" error after using melogit command and the choice between melogit and meqrlogitDear Statalists, I'm working on a multi-level model using data from cross-countries survey data for…
georoute command and HERE API not working?hello all, I'm having some trouble with the HERE API and the georoute package. I registered for a H…
Panel DataHi How do I estimate a random effects of individual and time effects in panel data models with stata…
PPML multicolinealityHi, I have estimated a model with OLS and PPML. With OLS I obtain R2 = 0.78 estat vif = 1.2 With…
Difference of a variable based on corresponding variables in other columnsHi, Based on a subset of data pasted below: Code: * Example generated by -dataex-. To install: ssc…
Subscribe to:
Post Comments (Atom)
0 Response to compare all the variables and get rid of the duplicated variables with different variable name
Post a Comment