Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: transposing rows


From   "Nuno" <[email protected]>
To   <[email protected]>
Subject   st: RE: transposing rows
Date   Wed, 7 Mar 2007 11:48:51 -0000

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/



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