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

st: RE: Re: insheet Q


From   "Vimalanand S. Prabhu" <[email protected]>
To   <[email protected]>
Subject   st: RE: Re: insheet Q
Date   Wed, 14 May 2003 13:49:09 -0400

Hi,

One of the easiest way to transfer data from excel is to first save as a
*.csv file (comma seperated -- we have that facility in excel) and then
insheet...

insheet using file.csv, comma

cheers,

Prabhu



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

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