input data into sas

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

hello everybody
when i am input data into sas, using infile, there is a problem always comes up.  i really  need you help. thanks a lot.
after i run this program.
DATA yahoo;
INFILE 'D:\AGE.XLS';
  INPUT OBS ID HEIGHT WEIGHT GENDER $ AGE;
RUN;

in the log book, a mistake is found like this
NOTE: The infile 'D:\AGE.XLS' is:
      File Name=D:\AGE.XLS,
      RECFM=V,LRECL=256

NOTE: Invalid data for OBS in line 1 1-6.(what's this meaning)
NOTE: LOST CARD.
OBS=. ID=. HEIGHT=. WEIGHT=. GENDER=  AGE=. _ERROR_=1 _N_=1
NOTE: 1 record was read from the infile 'D:\AGE.XLS'.
      The minimum record length was 6.
      The maximum record length was 6.
NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
NOTE: The data set WORK.HSDOD has 0 observations and 6 variables.
NOTE: DATA statement used:
      real time           0.10 seconds
      cpu time            0.10 seconds
many thanks

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：Input Data int put observations meaning mistake problem always yahoo

Maybe OBS cannot be a variable name.

我觉得obs大概就是_n_，所以，大概不必作为一个输入变量。
另外，如果想将xls数据输入到sas内：可以用sas系统菜单内的file->import data直接按步输入就可以了。这样输入数据会很简单，也不会出错！

thanks everyone, I am in Australia right now, if you guys need any help, just let me know. cheers.

正在看这部分，你应该把你要导入的源数据贴上来看看吧。