I want to combine datasets 1 (student ID and teacher name) and 2 (type of
class) to create dataset 3, as shown below. I don't think it is a simple
merge.
Part of the complication may arise from the fact that datasets 1 and 2 have
different numbers of cases. I am inclined to suspect I should use "generate"
in a one-by-one way to insert the data needed from dataset 2, rather than
merge.
*************
DATASET 1
Student Teacher
Student1 Teacher1
Student2 Teacher2
Student3 Teacher1
Student4 Teacher2
Student5 Teacher1
DATASET 2
Teacher Class Type
Teacher1 a
Teacher2 b
DATASET 3
Student Teacher Class Type
Student1 Teacher1 a
Student2 Teacher2 b
Student3 Teacher1 a
Student4 Teacher2 b
Student5 Teacher1 a
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
