Skip to content
Prev 178245 / 398506 Next

omit empty cells in crosstab?

Perhaps this is a common question but I haven't been able to find the answer.

I have data with many factors, each taking many values. However, only
relatively few combinations appear in the data, ie have nonzero counts, in
other words the resulting table is sparse. Say we have 10 factors each with
10 levels. The result of table() would exceed the memory space (on a 32bit
machine). Is there any way to produce a table with empty cells omitted?
(without first producing the whole table and then removing rows.)

Thanks,
Steve