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