library(reshape) melt(dataset) # assuming dataset is a data.frame. --- On Mon, 9/28/09, baxterj <j...@vt.edu> wrote:
> From: baxterj <j...@vt.edu> > Subject: [R] SAS user now converting to R - Help with Transpose > To: r-help@r-project.org > Received: Monday, September 28, 2009, 10:24 AM > > I am just starting to code in R and need some help as I am > used to doing this > in SAS. > > I have a dataset that looks like this: > > Chemical Well1 Well2 Well3 Well4 > BOD 13.2 14.2 15.5 14.2 > O2 7.8 2.6 3.5 2.4 > TURB 10.2 14.6 18.5 17.3 > and so on with more chemicals.... > > I would like to transpose my data so that it looks like > this: > Chemical WellID Value > BOD Well1 13.2 > BOD Well2 14.2 > BOD Well3 15.5 > BOD Well4 14.2 > O2 Well1 7.8 > O2 Well2 2.6 > .... and so on > > In sas I would code it like this: > proc sort data=ds1; by chemical; run; > Proc Transpose data=ds1 out=ds2; > by chemical; > var Well1 Well2 Well3 Well4; > run; > data ds3; set ds2; > rename _name_ = WellID; > rename col1 = value; > run; > > How can I do this in R?? Any help is much > appreciated. Thanks! > -- > View this message in context: > http://www.nabble.com/SAS-user-now-converting-to-R---Help-with-Transpose-tp25645393p25645393.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > 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. > __________________________________________________________________ The new Internet Explorer® 8 - Faster, safer, easier. Optimized for Yaho ______________________________________________ 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.