Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: problems with sort or merge

From   "Dimitriy V. Masterov" <>
Subject   st: problems with sort or merge
Date   Wed, 9 Apr 2003 18:41:28 -0500 (CDT)

Dear Statalist,

I am having problem merging two files.  There in a note in [R] sort that
says that Stata sometimes decides that a dataset in not sorted when in
fact it is. Perhaps this is an instance of that.

The program I use is this:
# delimit;
set more off;
set trace on;

use C:\GED\temp1.dta;
sort cell1 newvar;
save C:\GED\temp1.dta, replace;

use C:\GED\missing_data1.dta, clear;
sort cell1 newvar;

merge cell1 newvar using C:\GED\temp1.dta;

However, I get the following error message:

. merge cell1 newvar using C:\GED\temp1.dta;
using data not sorted

When I open any of the two datasets, and describe the variables, both
appear to be sorted by cell1 newvar. Thus I am not sure what I am doing

Thank you in advance for your help.

Dimitriy V. Masterov

National Opinion Research Center
1155 East 60th St. Room 038
Chicago, IL 60637

1368 East 53rd St., Apt.3
Chicago, IL 60615

Home: (773)288-0259
Mobile: (773)220-2760
Work: (773)256-6005

*   For searches and help try:

© Copyright 1996–2015 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index