[R] SAS user now converting to R - Help with Transpose

[Corrado]

I think you want to look at the command "reshape", it may solve your problem.

Type ?reshape in the R console on your system.

On Monday 28 September 2009 18:35:25 Gabor Grothendieck wrote:
> > 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 at 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 at 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.



-- 
Corrado Topi

Global Climate Change & Biodiversity Indicators
Area 18,Department of Biology
University of York, York, YO10 5YW, UK
Phone: + 44 (0) 1904 328645, E-mail: ct529 at york.ac.uk