Dear Rxperts,
q <- data.frame(p=rep(c("A","B"),each=10,len=30),
a=rep(c(1,2,3),each=10),id=seq(30),
b=round(runif(30,10,20)),
c=round(runif(30,40,70)))
The operation below...
tabular(((p=factor(p))*(a=factor(a))+1) ~ (N = 1) + (b + c)*
(mean+sd),data=q)
yields some rows of NAs and NaN as shown below

             b               c
 p a   N  mean  sd    mean  sd
 A 1   10 16.30 2.497 52.30  9.358
   2    0   NaN    NA   NaN     NA
   3   10 15.60 2.716 60.30  8.001
 B 1    0   NaN    NA   NaN     NA
   2   10 15.40 2.366 57.70 10.414
   3    0   NaN    NA   NaN     NA
   All 30 15.77 2.473 56.77  9.601

How do I remove the rows having N=0 ?
I would like the resulting table look like..
             b               c
 p a   N  mean  sd    mean  sd
 A 1   10 16.30 2.497 52.30  9.358
     3   10 15.60 2.716 60.30  8.001
 B  2   10 15.40 2.366 57.70 10.414
   All 30 15.77 2.473 56.77  9.601

Thanks so much,
Santosh

	[[alternative HTML version deleted]]

