Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: copying and pasting data from stata to excel


From   "Carter Rees" <carterrees@gmail.com>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: copying and pasting data from stata to excel
Date   Sat, 29 Sep 2007 18:41:08 -0400

See help -outsheet-

Carter

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Yun Liu
Sent: Saturday, September 29, 2007 6:31 PM
To: statalist@hsphsun2.harvard.edu
Subject: st: copying and pasting data from stata to excel

Dear Stata users,

When I copy data from stata browser and then paste them in an excel
spreadsheet, the missing data are not treated correctly. For example,
in stata I have:
var1       var2          var3
1           .               3

After I paste them to excel, they become:
var1       var2          var3
1           3

How to deal with it? Thank you!

Yun
*
*   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index