Tewodaj wants to translate Excel data including numeric variables with
more that 10 digits. I don't have DBMS/COPY, but with Stat/Transfer this
works:
In Excel, highlight the column and select Format > Numbers. Now select text format. Stat/Transfer translates this to a string variable in Stata; I guess DBMS/COPY does the same.
If the long numbers are identification numbers, it might be wise to keep them as strings; then precision is not a problem. Otherwise:
. generate double xnumber = real(xstring)
Hope this helps
Svend
________________________________________________________
Svend Juul
Institut for Folkesundhed, Afdeling for Epidemiologi
(Institute of Public Health, Department of Epidemiology)
Vennelyst Boulevard 6
DK-8000 Aarhus C, Denmark
Phone, work: +45 8942 6090
Phone, home: +45 8693 7796
Fax: +45 8613 1580
E-mail: [email protected]
_________________________________________________________
*
* 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/
