st: RE: xpose command

[Zhiqiang Wang <ZWang@ccs.uq.edu.au>]

Hi Don
Try this:  
. rename c1 _varname
. xpose, clear varname

Cheers

Zhiqiang

---------------------
Zhiqiang Wang
Department of Medicine
University of Queensland
Australia
Email: zwang@ccs.uq.edu.au


-----Original Message-----
From: Don Spady [mailto:dspady@ualberta.ca] 
Sent: Tuesday, 4 March 2003 10:15 AM
To: Statalist
Subject: st: xpose command

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/
*
*   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/