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/
