[email protected]
1. Please don't send formatted text to Statalist (see FAQ for other guidelines).
2. Verify you have the number of "columns" (i.e. variables) and "rows"
(i.e. observations) you think you do before you -xpose- via
qui ds
di `:word count `r(varlist)'' " columns and " `=_N' " rows"
i.e.
use 00total3b.dta, clear
rename commid _varname
qui ds
di `:word count `r(varlist)'' " columns and " `=_N' " rows"
xpose, clear varname
rename _varname commid
save 00totalnew.dta
On 6/1/06, [email protected] <[email protected]> wrote:
I'm having a problem with the xpose command.
I have two datasets � one from 1996 and one from 2000 that are similar. I
stat transferred them from excel into stata (they are too large for Excel to
transpose).
For 1996, the original dataset had 916 rows and 935 columns. When I
transpose the matrix, I get 767 rows instead of 935. I thought perhaps this
was because in the original data, the missing 168 entries contain only 0's.
*
* 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/
