Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: RE: tabulate and empty cells


From   Andreas Stiehler <as@berlecon.de>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: tabulate and empty cells
Date   Wed, 10 Nov 2004 10:23:04 +0100


Thanks Alex!
Not sure if this is what you are looking for, but you can:
1)
	tab variable, missing
and missing observations will appear in tables, or
2) 	recode variable .=0
This is not really what I mean. I look for a solution that is independend of missing values.

Assume that there are no missing values and all observations are distributed in categories "medium" or "small" (see example below): How can I get a row for "large" with Zeros as output?

Why do I need it?: To automate the programming of graphs and table-ready data files (by using matrices).

Thank you again,

Andreas



Best wishes,
Alex

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Andreas
Stiehler
Sent: Wednesday, November 10, 2004 9:33 AM
To: statalist@hsphsun2.harvard.edu
Subject: st: tabulate and empty cells


Dear Statalisters,

Maybe you can help me regarding a problem with the "tabulate" command:

If the cells in a row or column are empty, they disappear in the stata
output (as well as in the saved results).

But I would like to get zeros in.

For example-my wish is a table like that:
			Items
large		0
medium		5
small		10

But actually the output appears as:
			Items
medium		5
small		10

Do you  have any ideas to solve that problem?

Thanks!
Andreas




Dr. Andreas Stiehler
Analyst

Berlecon Research GmbH
Oranienburger Straße 32
D-10117 Berlin
Fon: +49 30 285296-0
Fax: +49 30 285296-29
E-Mail: as@berlecon.de

Web: www.berlecon.de
Analysten-Weblog: weblog.berlecon.de
Newsletter-Abo: mailto:berlecon-aktuell-subscribe@berlecon.de
--------------------------------------------------------------------
Berlecon Research - Wir analysieren das Potenzial neuer Technologien
--------------------------------------------------------------------

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


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


Dr. Andreas Stiehler
Analyst

Berlecon Research GmbH
Oranienburger Straße 32
D-10117 Berlin
Fon: +49 30 285296-0
Fax: +49 30 285296-29
E-Mail: as@berlecon.de

Web: www.berlecon.de
Analysten-Weblog: weblog.berlecon.de
Newsletter-Abo: mailto:berlecon-aktuell-subscribe@berlecon.de
--------------------------------------------------------------------
Berlecon Research - Wir analysieren das Potenzial neuer Technologien
--------------------------------------------------------------------


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