Thank you, Arun. It helps!
On 9/29/07, Arun Rajamohan <[email protected]> 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 <[email protected]> wrote:
> >> See help -outsheet-
> >>
> >> Carter
> >>
> >> -----Original Message-----
> >> From: [email protected]
> >> [mailto:[email protected]] On Behalf Of Yun Liu
> >> Sent: Saturday, September 29, 2007 6:31 PM
> >> To: [email protected]
> >> 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/
