|
|  |
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
Re: st: Re: Generating 'filler' data
Fillin can't work.
After all, how does it know that the limit for the bucket is 4095,
and not 3713?
Joe
On Jun 1, 2007, at 9:36 PM, Michael Blasnik wrote:
You said it: ."What I want to do is to 'fill in' the buckets". Try
help fillin
Michael Blasnik
----- Original Message ----- From: "Joe Trubisz" <[email protected]>
To: <[email protected]>
Sent: Friday, June 01, 2007 8:56 PM
Subject: st: Generating 'filler' data
Hi...
I have a piece of software that generates up to 4096 values
from a microarray plate. Therefore, it can generate something like:
<id> <bucket> <value>
where <id> is a plate number, <bucket> is a value from 0-4095
and <value> is a number > 0.
Problem is that it only generates values > 0 and I have no control
of the software to generate even those values that are zero. Hence,
I can have 2-<id>s such as:
1 1 4
1 4 5
1 6 8
2 3 3
2 4 3
2 8 13
I want to run a correlation against them, which is OK since I only
care about the buckets that match, since bucket 4 = bucket 4,
regardless of the <id>.
What I want to do is to 'fill in' the buckets for a particular id
with
zero values for the buckets that don't exist. For example, using
the above data for id=1, i'd convert it to:
1 1 4
1 2 0
1 3 0
1 4 5
1 5 0
1 6 8
etc...
Is there a way to do this, outside of exporting the data and writing
a perl program?
Thanks in advance
Joe
*
* 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/
*
* 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/
