Hello, Try
Total <- aggregate(cost~patient, data=x) Total[Total$cost > 1000, ] As for writing to a csv file, see ?write.csv Hope this helps, Rui Barradas Em 05-06-2012 16:34, mkm1616 escreveu:
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.
______________________________________________ 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.
