[R] Excluding all missing values with dcast ("reshape2" package)

[Michael.Laviolette at dhhs.state.nh.us]

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.Laviolette at 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.
>