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
Graph bar by two groups in one chart (not combined)Hello Statalist, I would like to put two graphs in one chart. (1) bar graph (mean) of output by nat…
Multilevel (mixed): How to decide between different COV() options?Dear Statalist members, I am currently running some multi-level models. However, I wonder how to de…
esttab and ivlassoHello, I am using ivlasso to get the CHS (post-)-lasso-orthogonalized vars. I would like to export …
reorder rows from -expand-I would like the output from the -expand- command but with the rows in a different order. As a simpl…
Splitting a string variable into two observations (but only sometimes)My data looks like this: HTML Code: coursetitle period spanish …
Subscribe to:
Post Comments (Atom)
0 Response to Find observations with same content for one variable
Post a Comment