Thanks for the response. The drop option of dcast was the first thing I tried. Sorry for the lack of reproducibility, but my data set is large, I couldn't find anything in the package examples, and I had hoped the modification would be straightforward. Using dcast was my first choice because it returns a data frame. I was successful using xtabs; there was just the extra step of converting the returned table to a data frame. Thanks again!
-M.L. This is not a reproducible example ;) anyways, dcast has an attribute: drop should missing combinations dropped or kept? does that not do what you want? On 03.12.2012, at 16:07, michael.laviole...@dhhs.state.nh.us wrote: > > Hello--I'm doing a simple crosstab using dcast: > > rawfreq <- dcast(nh11brfs, race3~CHCCOPD, length) > > with the results > > race3 Yes No NA > 1 White non-Hispanic 446 5473 21 > 2 Other non-Hispanic 29 211 0 > 3 Hispanic 6 81 1 > 4 <NA> 10 83 1 > > How would I modify this call to exclude all missing values; that is, to > obtain > > race3 Yes No > 1 White non-Hispanic 446 5473 > 2 Other non-Hispanic 29 211 > 3 Hispanic 6 81 > > Apologies if this has come up before, and thanks. > > -M.L. > ______________________________________________ R-help@r-project.org 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.
