Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

RE: st: Problems imputting data

From   "Miguel Angel Duran" <>
To   <>
Subject   RE: st: Problems imputting data
Date   Wed, 8 May 2013 10:28:00 +0200

Thanks, Phil and Reut, for your help. Nevertheless, my version is Stata 10,
so although -import excel- does not seem to be available. I have also tried
to save the Excel file as a .csv file (comma delimited); then, -insheet-
just recognizes one variable (ie, all the variables are put together).

By the way, I am trying to import about 20 files. Some of them have been
imported without problems. In other cases, I have been able to import some
observations up to a certain number and then copy+paste the rest. In other
cases copy+paste does not work, or the observations not imported are not the
last ones.

Thank you in advance again.


-----Mensaje original-----
[] En nombre de Phil Schumm
Enviado el: martes, 07 de mayo de 2013 16:21
Asunto: Re: st: Problems imputting data

On May 7, 2013, at 7:08 AM, Miguel Angel Duran wrote:
> Hi, Statalisters. I am trying to import data into Stata. I have used two
methods. First, I have tried to import from a .txt file using -insheet-.
Second, I have tried to copy and paste from an Excel file on the data
editor. Nevertheless, in both cases, although the original file has 8303
observations, Stata just gets about a third of them (and not the first
third). Using the second method Stata informs me that "You attempted to
paste one or more string values into numeric variables. The contents of
these cells, if any, are unchanged".
> Will anyone please help me to know what is going on and how I can solve

Assuming you are using Stata 12, you should use the -import excel- command.
Not only is this easier, but it will avoid some of the problems you can
encounter with the methods you describe above.  Try that first, and if you
are still having problems, let us know.

-- Phil

*   For searches and help try:

*   For searches and help try:

© Copyright 1996–2017 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index