Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | "Allan Reese (Cefas)" <allan.reese@cefas.co.uk> |
To | "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |
Subject | st: Table command - semi-concise |
Date | Thu, 30 Jan 2014 09:38:23 +0000 |
Help for the table command indicates "concise specifies that rows with all missing entries not be displayed." This seems true for row and column variables in the var list, and works with one superrowvar. But add a second superrowvar and all combinations of the superrowvars now appear. sysuse auto table make rep78, by(for) concise table make rep78, by(for head) concise The second example has rows for foreign cars with 4.0/4.5/5.0 inches headroom even though there are no makes. My current example is a table of statistics by firms by county and country. It's rather disconcerting to have all the counties listed under each country, when each occurs in just one country. (One work round is to concatenate country and county into one variable; another that's possible for me as there are just two countries is to make two tables.) To me it's a borderline bug, and an opportunity to make the output smarter. The superrowvars should not be output until there's a row with values. Allan * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/