Try this which gives an object of the required shape and of
class c("xtabs", "table") :xx <- xtabs(area ~ sic + level, DF) You can optionally do it like this to make it class "matrix" xx <- xtabs(area ~ sic + level, DF)[] and if you don't want the call attribute: attr(xx, "call") <- NULL On 9/4/07, Giulia Bennati <[EMAIL PROTECTED]> wrote: > Dear listmembers, > I have a little question: I have my data organized as follow > > sic level area > a 211 2.4 > b 311 2.3 > b 322 0.2 > b 322 0.5 > c 100 3.0 > c 100 1.5 > c 242 1.5 > d 222 0.2 > > where levels and sics are factors. I'm trying to obtain a matrix like this: > > level > 211 311 322 100 242 222 > sic > a 2.4 0 0 0 0 0 > b 0 2.3 0.7 0 0 0 > c 0 0 0 4.5 1.5 0 > d 0 0 0 0 0 0.2 > > I tryed with table function as > table(sic,level) but i obteined only a contingency table. > Have you any suggestions? > Thank you very much, > Giulia > > ______________________________________________ > R-help@stat.math.ethz.ch mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
