Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: st: merging two datasets of long format

From   Eric Booth <>
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

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:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index