Re: software for transpose
From: Pravin Jadhav pravinj@gmail.com
Subject: Re: [NMusers] software for transpose
Date: Fri, 9 Dec 2005 12:32:48 -0500
Jim,
Most data editing softwares will allow you to transpose the data efficiently.
Here is an example using Splus.
#CREATE data
data <- data.frame(ID = rep(1:2, each = 2), TIME = rep(c(1, 10), 2), DV = round(rnorm(4, 10, 2), 2))
#PRINT data
data
ID TIME DV
1 1 7.09
1 10 9.77
2 1 9.98
2 10 11.06
#TRANSPOSE data
t(data)
ID 1.00 1.00 2.00 2.00
TIME 1.00 10.00 1.00 10.00
DV 7.09 9.77 9.98 11.06
However, you might not need to do this for calculating percentiles. There is ?quantile function
in Splus to calculate empirical percentiles.
Hope it helps.
Pravin