Statalist The Stata Listserver


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

st: Replacing missing values


From   "Ms. Marilyn Ibarra" <ibarra@uga.edu>
To   statalist@hsphsun2.harvard.edu
Subject   st: Replacing missing values
Date   Mon, 21 Aug 2006 11:06:55 -0400 (EDT)

I have the following data:

Nace_ind	Industry     1998     1999  2000	
c_d_e		Total	     3.2       4.3   1.2	
da12		Beverages    2.2       9.5   4.3	
da13		Tobacco	       
da15		Textiles     2.1       4.9   6.5	
dj12		Wood
dc43		Electrical   8.5       3.3   9.1		
The first row are the variable names.  I would like to replace all missing values with the values of the first row (nace_ind=c_d_e and Industry=Total).  It would look like this:


Nace_ind	Industry     1998     1999  2000	
c_d_e		Total	     3.2       4.3   1.2	
da12		Beverages    2.2       9.5   4.3	
da13		Tobacco	     3.2       4.3   1.2
da15		Textiles     2.1       4.9   6.5	
dj12		Wood         3.2       4.3   1.2
dc43		Electrical   8.5       3.3   9.1

Thank you in advance,
Marilyn. 





----------------------
Ms. Marilyn Ibarra
University of Georgia
Economics Department
503 Brooks Hall
706-340-2879
*
*   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