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