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

st: Re: insheet Q


From   "Ginevra Biino" <[email protected]>
To   <[email protected]>
Subject   st: Re: insheet Q
Date   Wed, 14 May 2003 16:43:24 +0200

Have you checked if your decimal separator is a . (It have to be a . and not
a , (comma).

Dott. Ginevra Biino
CNR - IGP Alghero (SS)
SharDNA s.p.a.
P.zza Deffenu, 4
09125 Cagliari
Tel  070 4606118
Fax 070 4606151
E-mail:  [email protected]

----- Original Message -----
From: "Clara Soh" <[email protected]>
To: <[email protected]>
Sent: Wednesday, May 14, 2003 4:02 PM
Subject: st: insheet Q


> hi statalist,
>
> I'm having problems importing data into Stata.  My data is in excel,
> (saved it as a *.raw file text format, tab delilimited).  when i use
> insheet to import the data, most of the data get imported correctly, but
> a few observations get dropped or changed.  Insheet is pretty
> straightforward, and i can't figure out what is going wrong.  I have
> about 30,000 observations, which is well under the 66,000 limit that
> excel can handle, but it's too many to go through the data by hand to
> manually correct the observations that are dropped.  And some of the
> values are imported, but changed.
>
> i tried reimporting the data, but which particular values are changed
> pretty much random each time, so i can't predict where i'll need to fix
> the data.
>
> does anyone know if this is a bug, or if there is something special
> that i need to do?
> thanks
> clara
> *
> *   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/
>

*
*   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