作者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/m.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