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,
