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

[Arun Rajamohan <arajamoh@uwo.ca>]

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/