 |
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
Re: st: RE: copying and pasting data from stata to excel
in my previous mail,
"reissuing the command would reinstate the missing values."
should read
"issuing the command "mvdecode _all, mv(999)" would reinstate the
missing values."
Sorry about that
-A
On 29-Sep-07, at 9:12 PM, Arun Rajamohan 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/
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/