RE: st: merging two datasets of long format

["Raquel Guimaraes" <raquelrguimadem@gmail.com>]

Thanks Eric!!! Sorry for the silly question!

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Eric Booth
Sent: Friday, April 20, 2012 5:53 AM
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: merging two datasets of long format

<>

Hi Raquel:

The issue is that this line:


> merge m:1 id2 id3 id4 "$directory\clean\teachers" 


should be:

merge m:1 id2 id3 id4  using "$directory\clean\teachers" 

When you leave out "using" it thinks the filepath is another variable in
your varlist.

- Eric

__
Eric A. Booth
Public Policy Research Institute 
Texas A&M University
ebooth@ppri.tamu.edu
+979.845.6754

On Apr 19, 2012, at 9:39 PM, Raquel Guimaraes wrote:

> Hi everyone,
> 
> I have two datasets in the long format:
> 
> Students -- identifiers: id1 (student-specific), id2, id3, id4
> Teachers -- identifiers: id2, id3, id4, id5(teacher-specific)
> 
> I want to merge students to teachers using id2, id3 and id4. The two
> datasets above are in long format, and "time" is the time variable.
> 
> When  I do the merge after sorting the variables:
> 
> use "$directory\clean\students", clear
> sort id2 id3 id4
> merge m:1 id2 id3 id4 "$directory\clean\teachers" 
> 
> I got the following error: "factor variables and time-series operators not
> allowed"
> 
> Any help will be appreciated!
> 
> Thanks,
> 
> Raquel

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/