Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, is already up and running.

[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 <>
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–2016 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index