st: Fillin missing values, probability for new value

[Pamela Mueller <pmueller@econ.mpg.de>]

I  need to fill in missing values in my dataset. For most sectors I know 
how many start-ups there were for each year, but the data was not given 
if the number of startups (st) is less than 3 (hence one or two).
Therefore, I know if the missing is 1 or 2 and I know the probability 
for either one. I also know how often 1 or 2 should be each given in 
total for each year.
I tried recode, impute, mvencode but it did not work.
Maybe someone has a hint? Thanks
Pamela

for each year and region the data looks like this:
sect         st         prob1      prob2 
1             4
2             3           
3             .            0.3           0.7
4             8
5             0
6              .           0.45         0.55
7             3
8             5
9              .           0.48         0.52

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Pamela Mueller

Max Planck Institute of Economics
Kahlaische Strasse 10
07745 Jena, Germany

tel +49 3641 686 723
fax +49 3641 686 710

pmueller@econ.mpg.de
www.econ.mpg.de 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

*
*   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/