Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: double precision after DBMSCopying from excel to stata


From   TEWODAJ MOGUES <tmogues@students.wisc.edu>
To   Stata _ <statalist@hsphsun2.harvard.edu>
Subject   st: double precision after DBMSCopying from excel to stata
Date   Sat, 03 Sep 2005 06:34:15 -0400

Hi Statalist,
I've seen many permutations of the precision question in this list's 
archives, but didn't see anone asking this question which I have: How 
can I make sure that when import a file into stata from excel via dbms 
copy, i don't run into precision problems for numbers with more than 10 
digits. Here is the menu of things I tried, to no avail:
1) before DMBSCopying, in stata I typed -set type double, permanently-, 
and then went ahead and imported the files,
2) Once imported, I tried -set type double, permanently-, - gen double 
newvar = oldvar, etc. etc., but I didn't manage to get the numbers to 
show up correctly. 

DO I essentially have to give up on DMBSCopying the excel files into 
stata? Must I resort to another way (e.g. roundaboutly, first tranfer 
the xcel data to a text file, then insheet or infile that into stata? 
I'm afraid I only have the Stata 7 manual in which I didn't find this 
treatment.

Thanks,
Tewodaj

~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~
Tewodaj Mogues
Dept. of Agricultural and Applied Economics
University of Wisconsin - Madison
427 Lorch St. #317, Taylor Hall
Madison, WI 53706
*
*   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