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

Re: st: space trouble in excel to stata conversion

From   Johannes Geyer <[email protected]>
To   [email protected]
Subject   Re: st: space trouble in excel to stata conversion
Date   Wed, 1 Oct 2008 15:41:03 +0200

"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 

I don't know - you could do the following and avoid that problem:

sysuse auto
xmlsave make using FILENAME, replace doctype(excel)


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:

© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index