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
IV Probit error: "could not find initial values"Hello All! Does anyone have an idea why this error message could be popping up? Or what does it mea…
IV Probit error: "could not find initial values"Hello All! Does anyone have an idea why this error message could be popping up? Or what does it mea…
Drop observations after the last non missing value a variableHi, I would like to drop observations after the last non missing value of the variable WC01001A by …
Proportional Reduction in Error and Percent Correctly Predicted after Multinomial ProbitDear Colleagues, I am using Stata 14.2 to estimate a multinomial probit model of vote choice in the…
matsize and Pesaran estimationLadies & Gentlemen, up to 7 regressors, STATA could produce regression output successfully. When…
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