作者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