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: pasting excel worsheet with missing values in Stata 12 - Bug?

From   Neil Shephard <[email protected]>
To   [email protected]
Subject   Re: st: pasting excel worsheet with missing values in Stata 12 - Bug?
Date   Tue, 23 Aug 2011 13:23:39 +0100

I'd advise against this approach of copying and pasting.

Instead I'd recommend saving your Excel file as ASCII Comma-Separated
Variables (.csv) via File -> Save As and then using -insheet- to read
in the resulting file.

It avoids these problems and if you write your -insheet- (and
associated -label-ing commands) in a Do-file **.do) you can easily
repeat the importing of data subsequent labelling and any
manipulations you may wish to make, and of course subsequent analyses
very easily.

There are various resources out there on working in this way (see and the Stata NetCourse are
particularly useful.


"To consult the statistician after an experiment is finished is often
merely to ask him to conduct a post mortem examination. He can perhaps
say what the experiment died of." ~ R.A. Fisher, Presidential Address
to the First Indian Statistical Congress, 1938

Neil Shephard
Clinical Trials Research Unit /
NIHR Research Design Service for Yorkshire & the Humber
University of Sheffield
*   For searches and help try:

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