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 at the end of May, and its replacement, statalist.org 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   Ricardo Ovaldia <ovaldia@yahoo.com>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: pasting excel worsheet with missing values in Stata 12 - Bug?
Date   Tue, 23 Aug 2011 05:51:24 -0700 (PDT)

 
Thank you neel,
 
I routinely use -insheet- or -import- to read excel data into Stata.
In this case, this was such a small dataset that I chose to simply cut-and-paste it.
What is disturbing is that  Stata 11 and Stata 12 handle this cut-and-paste differently.
 
Ricardo

Ricardo Ovaldia, MS
Statistician 
Oklahoma City, OK


----- Original Message -----
From: Neil Shephard <n.shephard@sheffield.ac.uk>
To: statalist@hsphsun2.harvard.edu
Cc: 
Sent: Tuesday, August 23, 2011 7:23 AM
Subject: Re: st: pasting excel worsheet with missing values in Stata 12 - Bug?

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
http://stata-press.com/books/) and the Stata NetCourse are
particularly useful.

Neil



-- 
"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:
*  http://www.stata.com/help.cgi?searchhttp://www.stata.com/support/statalist/faqhttp://www.ats.ucla.edu/stat/stata/


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index