Did you try a where statement?
where Premie is not null
On Tue, Jan 17, 2012 at 3:03 PM, Dan Abner <dan.abne...@gmail.com> wrote:
> Hi everyone,
>
> I have the following:
>
> sqldf("select Premie,count(tpounds) N,avg(tpounds) Avg_Weight,
> stddev_samp(tpounds) StdDev
> from children
> group by Premie
> having !is.na(Premie)")
>
> sqldf() does not like the !is.na(Premie) specification. How does one
> exclude a "missing" group in an aggregated query using sqldf()?
>
> Thanks!
>
> Dan
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> 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<http://www.r-project.org/posting-guide.html>
> and provide commented, minimal, self-contained, reproducible code.
>
--
Joseph C. Magagnoli
[[alternative HTML version deleted]]
______________________________________________
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.
