I would like to find out which observations have the same content for one variable. Is there a command for this?
I would like to merge 2 data sets but I receive the message "variable FILE does not uniquely identify observations in the master data". In my master data set I have company observations.
The data set that I want to use for merging contains results of a text analysis. And this Stata file has a variable called FILE. I used files that are named Companyname_AR_year. In the variable FILE this is the same. So in order to do the merging, I generated a variable in the master data set generate FILE=Companyname+"_AR_"+string(year,"%02.0f").
They should be unique, however apparently there is a mistake.
Is it possible to find out which observations have the same name?
Thank you and best regards, Robert
Related Posts with Find observations with same content for one variable
Test the difference of coefficients? Hi guys, I need to examine the impacts of X on Raw Return and Alpha in two sub groups : outflow and…
Calculating top and bottom 2.5%Hi everyone, I am trying to add 95% confidence intervals to a kdenstiy plot. I think I need to cacu…
Calculating skewness and kurtosis of monthly returnsHello all, I have a dataset with a firm identifying number (called "PERMNO"), a date variable ("dat…
Both fixed effect and first difference of some independent variables?Hi, I have a short panel data and after doing unit root ht test, I found that some of the independen…
xtqreg warning message: fitted values of the scale function are not positiveHi, I am running a quantile regression for panel data. I have 50 individuals and at least 500 obser…
Subscribe to:
Post Comments (Atom)
0 Response to Find observations with same content for one variable
Post a Comment