Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: merging two datasets of long format
From
Eric Booth <[email protected]>
To
[email protected]
Subject
Re: st: merging two datasets of long format
Date
Fri, 20 Apr 2012 07:53:08 -0500
<>
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
[email protected]
+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/