Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

RE: st: space trouble in excel to stata conversion


From   Johannes Geyer <JGeyer@diw.de>
To   statalist@hsphsun2.harvard.edu
Subject   RE: st: space trouble in excel to stata conversion
Date   Wed, 1 Oct 2008 16:01:48 +0200

> That is a solution for Stata->Excel, but Ashim asked about Excel->Stata. 
I
> tried to replicate his problem, and it did not happen to me... Anything
> special about that string variable that we should know about, Ashim? 
Have
> you tried to -insheet- instead of pasting?


Right! I missed that.  I would try - insheet-  as Martin suggests;  -odbc- 
may also help

h odbc

Johannes





> 
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Johannes 
Geyer
> Sent: Wednesday, October 01, 2008 3:41 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: Re: st: space trouble in excel to stata conversion
> 
> "here is what I do, I copy and paste a string variable from excel to
> stata ( ie. a column of observations from excel to stata). For some
> strange reason there is a SPACE after each observation which refuses
> to go away even after I use the -trim- command.
> Has anyone experienced this ? Please tell me if I can read about this 
> somewhere."
> 
> I don't know - you could do the following and avoid that problem:
> 
> *********************
> sysuse auto
> xmlsave make using FILENAME, replace doctype(excel)
> *********************
> 
> Johannes
> 
> 
> 
> 
> ----------------------
> Johannes Geyer
> Deutsches Institut für Wirtschaftsforschung (DIW Berlin)
> German Institute for Economic Research 
> Department of Public Economics
> DIW Berlin
> Mohrenstraße 58
> 10117 Berlin
> Tel: +49-30-89789-258
> 
> 
> 
> 
> 
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/
> 
> 
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/


*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   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