Stata12 直接从excel复制然后paste导入数据要谨慎（软件版本问题 已解决）

相似文件 换一批

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

我刚才测试了下 是软件版本问题 请下载 https://bbs.pinggu.org/thread-1151347-1-1.html 8-24更新的版本

Stata12

Stata在导入数据时，可以先复制excel中的数据，然后打开stata中的Data Editor, 然后右键 paste即可

在stata11及以前是版本是没有问题，但是使用stata12导入时则会出现错误，如下

Excel数据：

Paste后Stata数据：

但是对于同样一个excel数据文件，选择stata中file---import---Excelspreadshhet则导入不会出现问题，原因不知道为什么

由于我使用过copy-----paste导入数据导致出现了匪夷所思的结果，当时想不通 check数据才发现是数据不对，所以大家这样导入数据请谨慎

如果有哪位高手知道原因，请告诉我下 谢谢了

我不知道是不是因为我Stata12（从论坛下载）是盗版的问题  我所用的数据集为 stata.xls

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏1 回帖

关键词：stata12 paste Stata EXCEL 软件版本 Stata 数据导入 excel

这个问题见
https://bbs.pinggu.org/thread-1156977-1-1.html

dxystata 发表于 2011-8-26 15:10
这个问题见
https://bbs.pinggu.org/thread-1156977-1-1.html

不好意思 刚才大致找了下 没有发现

一直在用stata10...

这个Bug在升级更新中已经修复。

修正了就好啊
由于stata12不是真正的sn

所以有stata11的就先用stata11，不要着急用最新的

其实stata12的亮点之一excel导入导出功能完全可由odbc来实现。

jzhyue 发表于 2011-8-26 20:21
这个Bug在升级更新中已经修复。

jzhyue兄所说的修复是指修复后复制没有问题？

dxystata 发表于 2011-8-26 21:31
jzhyue兄所说的修复是指修复后复制没有问题？

目前对stata12还还没有正式使用。没有试过这个功能，只是因为看到了如下信息：(蓝色部分）
-------- update 24aug2011 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1.  blogit did not allow option vce(cluster clustvar).  This has been fixed.
2.  Business calendars with month or weekday names containing capital letters would fail to load.  This has been fixed.
3.  marginsplot now recognizes margins results in e() when r() no longer contains results from margins.  margins will post its results to e() when option post is used.
4.  Mata's optimize() with the Nelder-Mead technique and constraints would error-out with a Mata trace log.  This has been fixed.
5.  query now displays the setting coeftabresults as an output setting.  This setting controls whether coefficient table results are stored in r().
6.  roctab with option detail produced unaligned tables when the classification variable had long value labels.  These labels are now abbreviated if needed, and a new option, nolabel, has
been added to suppress displaying the value labels.
7.  sspace, when time-series operators were combined with the e. error operator on the dependent variable in an obs_efeq equation, produced an error message.  This has been fixed.
8.  svy ivregress reported an invalid operator error when factor-variables notation was used in the list of instrumental variables (varlist_iv) but not in the list of exogenous variables
(varlist1).  This has been fixed.
9.  When pasting data into the Data Editor, sequential delimiters were treated as one delimiter, causing missing cells to be omitted.  This has been fixed.
10.  (Windows) Updating Stata over a network share failed with error r(695), leaving the Stata installation unchanged.  This has been fixed.
11.  (Mac) When resizing the main Stata window, the Results view will now always be the main view that gets resized regardless of its location in the main Stata window.
12.  (Mac) The keyboard shortcut for "Do to Bottom" for the Do-file Editor has been changed to Ctrl-Cmd-D because the previous keyboard shortcut conflicted with the system keyboard shortcut
for hiding/showing the Dock.
13.  (Mac) If tabbed windowing for the Do-file Editor is turned off and there are multiple Do-file Editor windows, Stata could be confused as to which Do-file Editor is active and perform menu
and toolbar operations on the wrong window.  This has been fixed.
14.  (Mac) Translating SMCL to PDF has been reenabled.
15.  (Mac) Translating SMCL to PS could cause Stata to crash.  This has been fixed.
16.  (Unix) Shift-clicking objects in the SEM Builder would not properly enable/disable items in the Object > Align menu.  This has been fixed.

jzhyue 发表于 2011-8-26 22:47
目前对stata12还还没有正式使用。没有试过这个功能，只是因为看到了如下信息：(蓝色部分）
-------- upd ...

9.  When pasting data into the Data Editor, sequential delimiters were treated as one delimiter, causing missing cells to be omitted.  This has been fixed.

在那里可以看到？