Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Generating 'filler' data


From   Joe Trubisz <[email protected]>
To   [email protected]
Subject   st: Generating 'filler' data
Date   Fri, 1 Jun 2007 20:56:13 -0400

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/



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