Statalist


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

Re: st: space trouble in excel to stata conversion


From   "Ashim Kapoor" <ashimkapoor@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: space trouble in excel to stata conversion
Date   Wed, 1 Oct 2008 19:53:42 +0530

Thank you. I will try that and get back to you.

Ashim.

On Wed, Oct 1, 2008 at 7:31 PM, Johannes Geyer <JGeyer@diw.de> wrote:
>> 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/
>

*
*   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