<>
*************
by year, sort : egen float accounts_total = total(accounts), missing
*************
HTH
Martin
-----Ursprüngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]] Im Auftrag von Srini
Gesendet: Sonntag, 8. März 2009 01:30
An: [email protected]
Betreff: st: preserving missing values when using total
Hi,
After data manipulation, I have a data set with multiple observations per
year. I used total to sum over these observations to get collapse the data,
but realized that the process was replacing missing values with zeroes.
year accounts accounts_total
district 1 72 . 0
district 1 72 . 0
district 1 72 . 0
district 1 72 . 0
district 1 73 . 0
district 1 73 . 0
district 1 73 . 0
district 1 74 10 34
district 1 74 20 34
district 1 74 4 34
district 1 75 15 32
district 1 75 17 32
In my case, accounts data is missing for the first few years. How can I
ensure that when I take the total by year, accounts_total = . for year = 72
and year = 73? Currently, STATA has accounts_total = 0 for those years.
If there isn't a specific command, I can try and use the method suggested by
Nick Cox in 2005 in this thread: Egen functions - preserving missing values?
Thanks.
Sinduja
*
* 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/
*
* 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/
