作者azimuth ()
看板Statistics
標題[問題] sas infile問題
時間Sat Apr 26 00:16:53 2008
小弟目前在練習infile及var語法
但不知為啥就是一直不行
先說明要infile的檔案,位於D:\SAS_folder\My SAS Files\9.1\TRY中
叫做grade.sas7bdat
打算從此檔中挑特定變數並print出來
所有語法如下:
=====================語法分隔線=========================
OPTION NOCENTER NODATE;
TITLE "PROC PRINT with options_VAR";
LIBNAME IAN 'D:\SAS_folder\My SAS Files\9.1\TRY';
DATA IAN.VAR_GRADE;
INFILE 'D:\SAS_folder\My SAS Files\9.1\TRY\grade.sas7bdat';
INPUT ID NAME$ SEX$ STAND PRETEST FIRST SECOND FINAL;
LABEL
ID="id"
NAME="name"
SEX="gender"
STAND="status"
PRETEST="pre_scores"
FIRST="1st_scores"
SECOND="2nd_scores"
FINAL="3rd_scores"
;
PROC PRINT DATA=IAN.VAR_GRADE;
VAR NAME FIRST--FINAL;
RUN;
========================================================
就在執行後卻出現var_grade檔中沒有任何資料點
為什麼會這樣呢? 請教高手
看一下log說明,我覺得有問題地方在於:
----------------------log說明---------------------------
NOTE: The infile 'D:\SAS_folder\My SAS Files\9.1\TRY\grade.sas7bdat' is:
File Name=D:\SAS_folder\My SAS Files\9.1\TRY\grade.sas7bdat,
RECFM=V,LRECL=256
NOTE: Invalid data for ID in line 1 1-87.
NOTE: Invalid data for STAND in line 1 165-185.
NOTE: Invalid data for PRETEST in line 1 187-193.
NOTE: Invalid data for FIRST in line 1 195-201.
NOTE: Invalid data for SECOND in line 1 203-256.
NOTE: LOST CARD.
NOTE: Invalid data errors for file ''D:\SAS_folder\My SAS
Files\9.1\TRY\grade.sas7bdat'' occurred outside the printed
range.
NOTE: Increase available buffer lines with the INFILE n= option.
ID=. NAME=FILEGRAD SEX=DATA STAND=. PRETEST=. FIRST=. SECOND=. FINAL=.
_ERROR_=1 _N_=1
--------------------------------------------------------
請幫我解答 謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.115.165.112
1F：推 tew:infile 讀的是外部檔 也就是讀非sas7bdat的檔案 04/26 01:05
2F：→ kingbee:有幾種資料讀取語法先釐清 infile import libname 04/28 14:32