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   tapes <tapesonly@yahoo.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: excel to stata / variable names shift to the value row
Date   Thu, 3 Mar 2005 19:37:20 -0800 (PST)

Thank you all very much. And I tried both methods
(insheet...,name; change first variable to numeric
one)in a case on hand, they worked great! 

tapes


--- Ernest Berkhout <Ernest.Berkhout@seo.nl> wrote:
> 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/
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
*
*   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