Statalist The Stata Listserver


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

Re: st: importing data from excel


From   keto04 <keto04@skynet.be>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: importing data from excel
Date   Wed, 19 Jul 2006 13:05:51 +0200

Hello Julia,
Try to adapt your excell file before importing by replacing all comma's by points. Easy to do by using the 'find' button under edit and then choose replace. Normally the problem should be solved. Good luck!

Julia Spies schreef:

Hello,

after having imported data from Excel, I noticed that for some variables Stata cutted the decimal places and considered these variables as two seperate variables.
E.g. Var1: 15,25 --> Var1: 15, Var2: 25
Strangely, this does not happen to all comma-containing variables (although they all have the same format in Excel). Anyone a clue why this happens and what can be done about it?

Regards,
Julia

P.S.: In case this is an Excel-specific problem, apologies for posting the issue here!
*
*   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/



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