1. Before you post to this list again, please read "An Introd to R" -- or other basic R tutorial. "Intro" ships with every R installation. There's a reason for this -- to avoid badgering this list with basic R queries that minimal homework could answer.
2. However, see also ?table and links therein. 3. "?"[" and ?subset are also relevant. -- Bert On Tue, Jun 5, 2012 at 8:34 AM, mkm1616 <mkm1...@gmail.com> wrote: > Hi all, I'm new to using R, and apologize for simplicity of this > question. > > I'm using a data set with over 60,000 observations, Two variables are > patient ID, and cost incurred by the patient. I'd like to generate > frequency/table by patient and cost IF the total cost is over 2000. > > Right now I'm using: > > by(x$cost, x$patient, sum) > > but this generates a huge list for each patient. > > What is the best way to either (1) export the output into a csv so I > can visually inspect each patient or more helpful (2) create the table > IF sum of cost > 1000 > > Thanks! > > ______________________________________________ > 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. -- Bert Gunter Genentech Nonclinical Biostatistics Internal Contact Info: Phone: 467-7374 Website: http://pharmadevelopment.roche.com/index/pdb/pdb-functional-groups/pdb-biostatistics/pdb-ncb-home.htm ______________________________________________ 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.