Hi, Try this: library(reshape2) dat1<-read.table(text="ID Dx A nausea A diabetes A kidney_failure A heart_attack A fever B fever B pneumonia B heart_attack B nausea B cough C kidney_failure C nausea C foot_pain",header=T,stringsAsFactors=F,sep="")
dcast(dat1,ID~Dx,length,value.var="Dx") # ID cough diabetes fever foot_pain heart_attack kidney_failure nausea #1 A 0 1 1 0 1 1 1 #2 B 1 0 1 0 1 0 1 #3 C 0 0 0 1 0 1 1 #pneumonia #1 0 #2 1 #3 0 A.K. ----- Original Message ----- From: Robert Strother <rstro...@gmail.com> To: r-help@r-project.org Cc: Sent: Monday, February 4, 2013 3:16 AM Subject: [R] reshape help Dear R users - I have a list of patient identifiers and diagnoses from inpatient admissions. I would like to reorganize the list, presently in a long format to a wide format in reshape, but in the absence of a "time" element, I am uncertain how to do this - any help greatly appreciated. ID Dx A nausea A diabetes A kidney failure A heart attack A fever B fever B pneumonia B heart attack B nausea B cough C kidney failure C nausea C foot pain I want this to be ID nausea diabetes kidney_failure heart_attack fever pneumonia A 1 1 1 1 1 0 B 0 0 0 1 1 1 R. Matthew Strother, MD Clinical Pharmacology Medical Oncology [[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. ______________________________________________ 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.