I am having trouble transposing some data. I do not think this is a
reshape problem.
Below are the original data as imported from Excel using StatTransfer.
In this form it is difficult to determine the effects of various
treatments
on the values of the chemicals present.
If I do xpose, clear varname I get the second table. Here things
are in the right order, but the variable names are lost; i.e. where
do I put in Treatment, Sample, Sodium etc. I know where to put it, but
isn't there a way in xpose to do this automatically.
c1 c2 c3 c4 c5 c6 c7
Treat 0 0 1 1 2 2
Sample 1 2 1 2 1 2
Na 7.9 7.8 7.2 8.3 16.4 16.4
K 21.4 20.6 19.1 20.7 19.1 19
cl 13.4 12.6 12.6 11.6 13 13
ca 8.6 8.3 8.8 8.8 6.2 6.3
.xpose, clear varname
I get this in the editor
v1 v2 v3 v4 v5 v6 _varname c1
c1
0 1 7.9 21.4 13.4 8.6 c2
0 2 7.8 20.6 12.6 8.3 c3
1 1 7.2 19.1 12.6 8.8 c4
1 2 8.3 20.7 11.6 8.8 c5
2 1 16.4 19.1 13 6.2 c6
2 2 16.4 19 13 6.3 c7
I have lost the values of the first variable (the na k cl etc)
THIS IS WHAT I WANT, but I don't want to do it manually.
treat Sample Na K cl ca
0 1 7.9 21.4 13.4 8.6
0 2 7.8 20.6 12.6 8.3
1 1 7.2 19.1 12.6 8.8
1 2 8.3 20.7 11.6 8.8
2 1 16.4 19.1 13 6.2
2 2 16.4 19 13 6.3
What am I doing wrong? (Besides using Excel as a data sheet)
Many thanks in advance.
Donald Spady
Dep't of Pediatrics, University of Alberta
(780) 407-1244
Nature has no reset button.
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
