[程式] sas匯入excel成功卻無法讀取內容
各位大大好,我在使用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://www.ptt.cc/bbs/Statistics/M.1551872099.A.9CB.html
※ 編輯: ulala (39.8.169.162), 03/06/2019 19:40:02
推
03/06 20:43,
5年前
, 1F
03/06 20:43, 1F
→
03/06 20:44,
5年前
, 2F
03/06 20:44, 2F
→
03/06 20:45,
5年前
, 3F
03/06 20:45, 3F
→
03/06 20:46,
5年前
, 4F
03/06 20:46, 4F
→
03/06 20:47,
5年前
, 5F
03/06 20:47, 5F
→
03/06 20:47,
5年前
, 6F
03/06 20:47, 6F
W大您好,我的sas版本是最新的9.4版,所以可能不是舊版的問題QQ
但我單純在sas中key data是可以儲存跟瀏覽的,就只有匯入excel無法讀取...
※ 編輯: ulala (39.8.169.162), 03/06/2019 22:26:03
→
03/07 20:43,
5年前
, 7F
03/07 20:43, 7F