Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: why -odbc- made error?


From   gjhxmu@sina.com
To   statalist<statalist@hsphsun2.harvard.edu>
Subject   st: why -odbc- made error?
Date   Fri, 31 Jul 2009 00:16:08 +0800

Dear statalists,

When I type,
odbc load,dsn("Excel Files;DBQ=xx.xls") table("1998$")
list

The result window of stata shows as follows,


     +---------------------------------------------+
     |      code   indname   x   y   z   a   b   c |
     |---------------------------------------------|
  1. | 000877.SZ    徐永平   .   .   .   .         |
  2. | 600811.SH    关国亮   9   7   1   .         |
  3. | 001696.SZ    徐怀忠   5   3   1   3         |
  4. | 600811.SH      安英   9   7   1   .         |
  5. | 000877.SZ      危波   7   5   1   .         |
     |---------------------------------------------|
  6. | 600811.SH    刘庆余   .   .   .   .         |
  7. | 000877.SZ      张民   .   .   .   .         |
  8. | 000877.SZ    李炳柱   .   .   .   .         |
  9. | 000877.SZ    赵戈飞   .   .   .   .         |
 10. | 600817.SH    曹文涛   7   3   1   .         |
     +---------------------------------------------+

However, in fact my data is as follows,

     +---------------------------------------------+
     |      code   indname   x   y   z   a   b   c |
     |---------------------------------------------|
  1. | 000877.SZ    徐永平   .   .   .   .   .   . |
  2. | 600811.SH    关国亮   9   7   1   .   .   . |
  3. | 001696.SZ    徐怀忠   5   3   1   3   .   . |
  4. | 600811.SH      安英   9   7   1   .   .   . |
  5. | 000877.SZ      危波   7   5   1   .   .   . |
     |---------------------------------------------|
  6. | 600811.SH    刘庆余   .   .   .   .   .   . |
  7. | 000877.SZ      张民   .   .   .   .   .   . |
  8. | 000877.SZ    李炳柱   .   .   .   .   .   . |
  9. | 000877.SZ    赵戈飞   .   .   .   .   .   1 |
 10. | 600817.SH    曹文涛   7   3   1   .   .   . |
     +---------------------------------------------+

Namely, there is something wrong with variable c.
Could anyone tell me why?

Thank you a lot!


Sincerely,



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index