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

John Kane jrkrideau at yahoo.ca
Mon Sep 28 22:17:09 CEST 2009


library(reshape)
melt(dataset)  # assuming dataset is a data.frame.

--- On Mon, 9/28/09, baxterj <jdew at vt.edu> wrote:

> From: baxterj <jdew at vt.edu>
> Subject: [R]  SAS user now converting to R - Help with Transpose
> To: r-help at 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 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.
> 


      __________________________________________________________________
The new Internet Explorer® 8 - Faster, safer, easier.  Optimized for Yaho



More information about the R-help mailing list