Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: excel to stata / variable names shift to the value row


From   Ernest Berkhout <Ernest.Berkhout@seo.nl>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: excel to stata / variable names shift to the value row
Date   Mon, 28 Feb 2005 12:08:03 +0100

At 11:51 28/02/2005, Ronán Conroy wrote:

You can force -insheet- to read the first line of the incoming file as names, using the -names- option. I cannot figure out why, on some occasions, Stata treats the first row as data, but let's face it, it does a pretty good job at guessing whether there are names there or not. Safest thing is to give the -names- option explicitly unless you can vouch for Stata's behaviour in advance.
It happens mostly to me when the first column is a string variable. If the first row in a column is a string, it can be (A) a variable name OR (B) the first value of a string variable. If the second row is a string as well, then option (B) might probably be the most plausible for Stata.
When the first variable is not a stringvariable i never encounter the problem mentioned...





Ernest Berkhout
SEO Amsterdam Economics
University of Amsterdam
******************************************************
For information on flexwork & research: www.tempworkresearch.nl ******************************************************
Room 3.08
Roetersstraat 29
1018 WB Amsterdam
The Netherlands

tel.:+ 31 20 525 1657
fax:+ 31 20 525 1686
http://www.seo.nl
===========================
A statistician: someone who insists
on being certain about uncertainty
===========================

*
* 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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index