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
Combining tables with identical variables, long formatHey guys, Is there an easy way how to combine two tables with identical variables in a long format?…
Need help generating new variable to capture 18th observation onwards for each data groupDear all, I have generated a new variable (Ambtemp2oC_01) to capture temperature readings above two …
Improving performance of large excel tables with tabout, append - suggestions?Dear Statalist, I have been an avid reader of the list for years and it has helped me tremendously …
Smith et al (2004) Panel Unit Root TestHello everyone, I would like to compare first and second generation unit root test results by apply…
Lags in Bayesian varsI am on state 17 trying to run a Bayesian var.. Does anyone here know how lags are determined in Bay…
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