Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Re: how to list variables vertically

From   Friedrich Huebler <>
Subject   st: Re: how to list variables vertically
Date   Mon, 8 Mar 2004 06:49:55 -0800 (PST)


You don't need Excel, you can transpose the data in Stata. Type
-xpose, clear- and then -list- the data. Note that -xpose- will lead
to the loss of all data held as strings.

Friedrich Huebler

--- LACHENMAIER <> wrote:
> Hi all,
> this might be a very simple question, but I have not found a
> solution
> yet.
> Is it possible to create a list or table with the variables
> appearing
> vertically and the observations horizontally?
> The output should look like 
>       Observ1 Observ2 Observ3
> Var1   xx1     xx2     xx3      
> Var2   yy1     yy2     yy3                  
> Var3   zz1     zz2     zz3
> This type of presenting the data would be very useful to compare
> two
> observations. Of course one can do it by copying the data to Excel
> and
> transpose the data, but this gets very inconvenient if the number
> of
> variables is larger than the number of columns in Excel (one has to
> paste it first horizontally before one can transpose it).
> Thanks a lot,
> Stefan

Do you Yahoo!?
Yahoo! Search - Find what you’re looking for faster
*   For searches and help try:

© Copyright 1996–2015 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index