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
n.j.cox@durham.ac.uk
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/
