作者ulala (笑笑)
看板Statistics
标题[程式] sas汇入excel成功却无法读取内容
时间Wed Mar 6 19:34:56 2019
各位大大好，我在使用sas汇入excel资料时遇到一个状况，系统显示资料建立成功（Test
1),但点取他在viewtable上却完全空白，日志显示有错误
但我尝试过汇入自己建立的资料夹、确认过存取路径无中文，还是找不出问题QQ
所以想请教有高手能替我解惑吗？
//
NOTE: 已顺利建立 WORK.TEST1 资料集。
NOTE: The data set WORK.TEST1 has 3470 observations and 80 variables.
ERROR: No such object.
Parameters passed to method _SETCOLUMNCONFORMTHRESHOLD:
1 rc = 70
Program returning prematurely at line 2337
AF Program: SASHELP.FSP.DATAVIEW.SCL
*** Line 2200: [ERROR: #114] Unable to perform requested function
Parameters passed to method _LOADVIEWER:
Program returning prematurely at line 2200
AF Program: SASHELP.FSP.DATAVIEW.SCL
*** Line 1304: [ERROR: #114] Unable to perform requested function
Parameters passed to method _SETVIEW:
1 (Character Literal) = 'TABLE'
Program returning prematurely at line 1304
AF Program: SASHELP.FSP.DATAVIEW.SCL
*** Line 662: [ERROR: #114] Unable to perform requested function
Parameters passed to method _OPENTABLE:
1 table = 'Work.Test1'
2 mode = ''
3 access = ''
Program returning prematurely at line 662
AF Program: SASHELP.FSP.DATAVIEW.SCL
*** Line 486: [ERROR: #114] Unable to perform requested function
ERROR: Call to _SETUP_ failed. Unable to send event SETUP to obj1.
Parameters passed to method _SENDEVENT:
1 (Character Literal) = 'SETUP'
2 command_list = 9795
Program returning prematurely at line 486
AF Program: SASHELP.FSP.VTFRAME.SCL
*** Line 108: [ERROR: #114] Unable to perform requested function
Parameters passed to method CMDARGS:
Program returning prematurely at line 108
AF Program: SASHELP.FSP.VTFRAME.SCL
ERROR: No such object.
Parameters passed to method _GETATTRIBUTES:
1 templ = 10833
Program returning prematurely at line 2251
AF Program: SASHELP.FSP.DATAVIEW.SCL
*** Line 881: [ERROR: #114] Unable to perform requested function
Parameters passed to method _SETVIEW:
1 (Character Literal) = 'TABLE'
Program returning prematurely at line 881
AF Program: SASHELP.FSP.DATAVIEW.SCL
*** Line 496: [ERROR: #114] Unable to perform requested function
Parameters passed to method _NEWTABLE:
Program returning prematurely at line 496
AF Program: SASHELP.FSP.DATAVIEW.SCL
ERROR: Region fill failure, operation aborted.
ERROR: Unable to send _POSTINIT_ method. See LOG window.
//
非常谢谢你们！
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 39.8.169.162
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/Statistics/M.1551872099.A.9CB.html
※ 编辑: ulala (39.8.169.162), 03/06/2019 19:40:02
1F：推 west1996: 如果汇进来後不打开直接对table进行proc print是否可以03/06 20:43
2F：→ west1996: 正常印出正确的内容？03/06 20:44
3F：→ west1996: 如果可以对资料正常分析，只有打开资料时出现问题，那应03/06 20:45
4F：→ west1996: 该是你用到了一个两三年前的旧版SAS，里面有一个bug，会03/06 20:46
5F：→ west1996: 导致中文版介面无法点开资料看，只需要安装补丁程式就可03/06 20:47
6F：→ west1996: 以修复03/06 20:47
W大您好，我的sas版本是最新的9.4版，所以可能不是旧版的问题QQ
但我单纯在sas中key data是可以储存跟浏览的，就只有汇入excel无法读取...
※ 编辑: ulala (39.8.169.162), 03/06/2019 22:26:03
7F：→ jupit: 换用支援unicode那个开sas试试? 03/07 20:43