The correct example should have been:
*------------begin example------------
sysuse auto, clear
collapse (sum) price mpg, by(rep78 foreign)
list
fillin rep78 foreign
list
*-------------end example-------------
--- Maarten buis <[email protected]> wrote:
> --- "FUKUGAWA, N." <[email protected]> wrote:
> > I compute summation of one variable as follows.
> >
> > . table AREA YEAR, c(sum var1) by(CAT) format(%8.0f)
> >
> > | 1983 1984 1985 1986 1987 1988 1989 1990 1991
> > 1 | 4 32 7 6 17 44 46 34 5
> > 2 | 10 8 2
> >
> > 3 | 14 4 7
> >
> >
> > By default, cell is left blank if no observation is found (for
> > instance, YEAR==1983 and AREA==2).
> > I would like to avoid blank cells in the table and have a table
> > as follows.
> >
> > | 1983 1984 1985 1986 1987 1988 1989 1990 1991
> > 1 | 4 32 7 6 17 44 46 34 5
> > 2 | . . . 10 . 8 2 . .
> > 3 | . . 14 4 . . . 7
> > .
> >
>
> A combination of -collapse- and -fillin- might be helpful here, like
> in
> the example below:
>
> *------------begin example------------
> sysuse auto, clear
> collapse price mpg
> list
> fillin rep78 foreign
> list
> *-------------end example-------------
>
> HTH,
> Maarten
>
>
>
> -----------------------------------------
> Maarten L. Buis
> Department of Social Research Methodology
> Vrije Universiteit Amsterdam
> Boelelaan 1081
> 1081 HV Amsterdam
> The Netherlands
>
> visiting adress:
> Buitenveldertselaan 3 (Metropolitan), room Z434
>
> +31 20 5986715
>
> http://home.fsw.vu.nl/m.buis/
> -----------------------------------------
>
>
>
>
>
> ___________________________________________________________
> All new Yahoo! Mail "The new Interface is stunning in its simplicity
> and ease of use." - PC Magazine
> http://uk.docs.yahoo.com/nowyoucan.html
> *
> * 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/
>
-----------------------------------------
Maarten L. Buis
Department of Social Research Methodology
Vrije Universiteit Amsterdam
Boelelaan 1081
1081 HV Amsterdam
The Netherlands
visiting adress:
Buitenveldertselaan 3 (Metropolitan), room Z434
+31 20 5986715
http://home.fsw.vu.nl/m.buis/
-----------------------------------------
___________________________________________________________
Try the all-new Yahoo! Mail. "The New Version is radically easier to use" � The Wall Street Journal
http://uk.docs.yahoo.com/nowyoucan.html
*
* 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/
