Statalist The Stata Listserver


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

Re: st: xpose problems


From   "Austin Nichols" <[email protected]>
To   [email protected]
Subject   Re: st: xpose problems
Date   Thu, 1 Jun 2006 11:13:13 -0400

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



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