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

st: RE: One question (long)


From   "Wallace, John" <John_Wallace@affymetrix.com>
To   "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu>
Subject   st: RE: One question (long)
Date   Fri, 6 Dec 2002 11:32:04 -0800

I think you want to use the -joinby- command.  Here's an example I just
tried

Two text files, test1.txt and test2.txt are to be merged using -joinby-

test1.txt content:

Index,Measure
1,300
2,400
3,100
4,200
5,600
10,300
9,400
8,100
7,200
5,600
15,300
12,400
13,100
14,200
16,600 

test2.txt content:

Measure,Weight
100,1.1
200,1.2
300,1.3
400,1.4
500,1.5
600,30

Note that Index has many more entries than Weight, which is, I think, the
case with the dataset you're working with.  Also, test2.txt has Measures
that do not exist in test1.txt, and the records are ordered by Measure
value, whereas in test1.txt they are ordered by Index - so the structure of
the data is quite different.  -joinby- doesn't appear to care.

First, convert test2.txt to a stata dataset, so that -joinby- can work with
it:
-insheet using test2.txt-
-save "test2.dta"-

Open the large dataset
-insheet using test1.txt-

Merge the datasets using -joinby-
-joinby using test2.dta-

You'll see your variable list expand from
Index
Measure

to

Index
Measure
Weight

and when you -browse- the dataset you will see
 
Index	Measure	Weight
3	100	1.1
8	100	1.1
13	100	1.1
7	200	1.2
4	200	1.2
14	200	1.2
10	300	1.3
1	300	1.3
15	300	1.3
12	400	1.4
2	400	1.4
9	400	1.4
5	600	30
16	600	30
5	600	30

Is this what you were looking for?

John Wallace
Research Associate
Affymetrix, Inc

-----Original Message-----
From: Rodrigo Briceņo [mailto:rbriceno@sanigest.com] 

yes, I thought that but the case is that I have repeated GRDs and then I
need to look for the specific GRD and assign their weight. We only have
approximately 500 GRDs and the database has 300,000 registers. I think that
I need a kind of logical formula to combine the two data sets.

-----Mensaje original-----
From: Jiang, Tao [mailto:TJiang@air.org] 

merge the two data sets.

-----Original Message-----
From: Rodrigo Briceņo [mailto:rbriceno@sanigest.com]
Sent: Friday, December 06, 2002 1:47 PM
To: Statalist (E-mail)
Subject: st: One question


Hello friends!

I have a discharges database with more than 300,000 registers. I need to
assign a weight to each discharge (each patient) according to a list.  How
can I do that?

patient  GRD  Weight
1           334
2           300

Thanks

Rodrigo Briceņo

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.423 / Virus Database: 238 - Release Date: 11/25/2002
 
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



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