|
|  |
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: RE: transposing rows
My experience with something similar tells me that the best way to this is
not to use all the years at once but one at a time and then append all the
years together. To do this I just use -reshape- and then destring to exclue
the "NA"s in the data.
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of
[email protected]
Sent: quarta-feira, 7 de Mar�o de 2007 10:12
To: [email protected]
Subject: st: transposing rows
Dear all,
my data are stored in an excel file where each row contains a variable and
each column represents a year, as follows:
1994 1995 1996 1997
TOTAL SALES 844854 949870 956692 876844
DEPRECIATION NA 38477 39937 36588
DEPN NA NA NA NA
OPERATING PROFIT 52971 93029 93613 112022
I need to transpose the rows so that each variable is contained in a column
and each row represents a year. In other words I need to get:
TOTAL SALES DEPRECIATION DEPN OPERATING PROFITS
1994
1995
1996
1997
Does anyone know how STATA can do it?
Thanks for your help
Mariarosaria
-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/
*
* 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/
