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   Arun Rajamohan <arajamoh@uwo.ca>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: copying and pasting data from stata to excel
Date   Sat, 29 Sep 2007 21:12:43 -0400

You can do something else, if it is possible at all in your case.
try help mvencode

you can as the help file would say convert all missing values to say 999
mvencode _all, mv(999)

reissuing the command would reinstate the missing values.

In excel you can search and replace.

Of course as I said earlier, all this depends on your data.

And as I notice from your previous mails you do not want .csv or .xml.

-A


On 29-Sep-07, at 8:13 PM, Yun Liu wrote:

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/
Arun Rajamohan PhD
Department of Biology
Room 360, Biological & Geological Sciences Building
1151 Richmond Street North
The University of Western Ontario
London, ON N6A 5B7 CANADA

Office: + 1-519-661-2111 ext 80582
Office Fax: + 1-519-661-3935




*
*   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