You have missing data. This is a serious statistical problem, not a
datamanagement problem. What you propose to do is a variant on mean
imputation, which you should not do. If you want to do something about
missing data, than unfortunately you will have to do quite some
reading.
I'd start with (Allison 2002), and than move on to the articles by
Patrick Royston describing the -ice- package.
Hope this helps,
Maarten
Allison, Paul D. (2002) "Missing Data", Thousand Oaks: Sage.
Royston, P. 2004. Multiple imputation of missing values. Stata Journal
4(3): 227�241.
Royston, P. 2005. Multiple imputation of missing values: update. Stata
Journal 5(2): 188�201.
Royston, P. 2005. Multiple imputation of missing values: Update of ice.
Stata Journal 5(4): 527-536.
Royston, P. 2007. Multiple imputation of missing values: further update
of ice, with an emphasis on interval censoring. Stata Journal 7(4):
445-464.
You can find these articles here:
http://www.stata-journal.com/archives.html
--- carmen gamarra <[email protected]> wrote:
> I have a specific problem: I need to know what is the command that
> would allow me to make the correction of some data by age group and
> for years:
>
> The data are as follows:
> Mortality data of: uterine cervix, uterine corpus and uterine cancer
> not otherwise specified
>
> The problem is as follows:
> Many deaths from cancer of the uterine cervix and uterine corpus are
> inadequately coded as �uterine cancer not otherwise specified�
>
>
> I need to know which command in Stata will do the following:
>
> To correct this lack of specificity in the assignment of uterine
> cancer deaths by allocating the deaths coded as �unspecified� to
> either uterine cervix or uterine corpus cancer according to the
> age-specific proportions specified as uterine cervix and uterine
> corpus cancer in each years.
-----------------------------------------
Maarten L. Buis
Department of Social Research Methodology
Vrije Universiteit Amsterdam
Boelelaan 1081
1081 HV Amsterdam
The Netherlands
visiting address:
Buitenveldertselaan 3 (Metropolitan), room Z434
+31 20 5986715
http://home.fsw.vu.nl/m.buis/
-----------------------------------------
__________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
