Statalist The Stata Listserver


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

Re: st: importing data from excel


From   Ronán Conroy <rconroy@rcsi.ie>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: importing data from excel
Date   Wed, 19 Jul 2006 12:10:48 +0100

On 19 Iúil 2006, at 12:05, keto04 wrote:

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!
This is simply the way Excel represents numbers. You should either change Excel to represent decimals as periods, not commas, or tell Stata



. set dp {comma|period} [, permanently]



=========
Ronán Conroy
Royal College of Surgeons in Ireland
rconroy@rcsi.ie
+353 (0) 1 402 2431
+353 (0) 87 799 97 95
www.flickr.com/photos/ronanconroy




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