Newbie here.
I am trying to merge two files - one is a headteacher survey from 200 schools. The second is a parent survey carried out with 6 parents from 60 schools (so 360 observations in total) randomly selected from the 200. Both have the variable SchoolName as the identifier.
I have tried the following:
Using the parent file as the master one and the command "merge 1:m SchoolName using" the parent file. I've also tried the command merge m:1. It keeps returning the message "that variable SchoolName does not uniquely identify observations".
I have searched for duplicates and found none.
I've checked SchoolName is stored as a number in both files.
Thank you for your help.
Related Posts with Merging two data files
How to add a constraint when matching using teffects psmatch, cem or psmatch2?Hello dear statalists, I am trying to match the houses sold at year t with similar houses sold in ye…
Define nested loops for dependent and independent variablesI have a panel data set from 1970 to 2014 on yields and prices for four different crops. I need to r…
Two Stage Least Squares with multiple Fixed Effects (using reghdfe)Dear Statalist, I am trying to estimate a two stage least squares where both stages contain multipl…
Dropping repeated columns from a matrixDear statalist, I have a matrix in which two or more columns are exactly same. Is there some way of…
How to genearte the list of vars for nodes using nw2fromedge command when the number of nodes exceeds 1000Hello, could someone help me on this question. I am using the network analysis command "nw2fromedge"…
Subscribe to:
Post Comments (Atom)
0 Response to Merging two data files
Post a Comment