Statalist


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

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


From   "Yun Liu" <liuyun3@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: copying and pasting data from stata to excel
Date   Sat, 29 Sep 2007 20:13:10 -0400

Thank you! But I am trying to find a convenient way to copy a small
part of a huge database and prefer not to generate a new file each
time. Anyway, it's no big deal. Thanks.

On 9/29/07, Carter Rees <carterrees@gmail.com> wrote:
> 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/
>
*
*   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