A list of known problems in this area is in
http://www.stata.com/support/faqs/data/newexcel.html
That may explain what is happening to you.
The issue is really upstream of Stata. A program
like Excel is totally indulgent on what precise layout
you may adopt, so there is no reason to expect Stata
to be able to understand all possible layouts.
Nick
[email protected]
tapes (a.k.a. Tapes)
> I've got such experience when importing data from
> excel to stata (directly copy or using insheet
> command): Sometimes stata can automatically recognize
> variable names from the excel file and leave them in
> variable name row of the stata, but sometimes it turns
> out that all the variable names shift to the value row
> of the stata. In fact, the variable names in both
> cases seem 'normal' and similar to each other. Any
> suggestions about how to ensure stata to keep variable
> names in the right place? Thank you very much.
*
* 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/
