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

Re: st: space trouble in excel to stata conversion

From   Johannes Geyer <>
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–2023 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index