Statalist


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

st: merge problem - need help


From   [email protected]
To   [email protected]
Subject   st: merge problem - need help
Date   Sat, 01 Nov 2008 14:54:20 +0100

hi stata users

does anybody know that problem:

I have a large dataset and therefore I have to split it into two sub datasets.
Then I have used both to calculate something in each of them.
When merged them in the first dataset, I have recognized that stata has not merged correctly

1.dataset

timevar     identifier     var1   

1999          202             3
1999          204             3
1999          333             3
1999          543             3
2000          202             5
2000          300             6
2000          533             7

sub datasets
1.)
timevar     identifier     var1 var2_99

1999          202             3     2
1999          204             3     2
1999          333             3     2
1999          543             3     2

2.)
timevar     identifier     var1 var2_00
2000          202             5     4
2000          300             6     5
2000          533             7     6

How you can see, I have programmed var2_XX and I have made a simple calculation 

Then, I have deleted var 1 and only timevar, identifier and var 2_XX remained.

Now I want to merge these results in the large dataset.

the bad result:

timevar     identifier     var1   var2_99 var2_00

1999          202             3       2              4
1999          204             3       2              5
1999          333             3       2              6
1999          543             3       2              .
2000          202             5       .               .
2000          300             6       .               .
2000          533             7       .               .

The command has been :
sort identifier timevar
merge identifier timevar using "subdataset_99", nokeep

and respectively:
sort identifier timevar
merge identifier timevar using "subdataset_00", nokeep

stata did not recognized that timevar is 1999 and 2000 depending on the using dataset, I guess...

Any ideas???

Thanks !!!!

B








-- 
Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger
*
*   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/



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