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 21:31:25 -0400

Thank you, Arun. It helps!

On 9/29/07, Arun Rajamohan <arajamoh@uwo.ca> wrote:
> 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/
>
*
*   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