[程式] sas匯入excel成功卻無法讀取內容

看板Statistics作者 (笑笑)時間5年前 (2019/03/06 19:34), 5年前編輯推噓1(106)
留言7則, 2人參與, 5年前最新討論串1/1
各位大大好,我在使用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
如果匯進來後不打開直接對table進行proc print是否可以
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
該是你用到了一個兩三年前的舊版SAS,裡面有一個bug,會
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
換用支援unicode那個開sas試試?
03/07 20:43, 7F
文章代碼(AID): #1SVx1ZdB (Statistics)