NOTE: The infile 'f:\ia\data.txt' is:
File Name=f:\ia\data.txt,
RECFM=V,LRECL=256
NOTE: Invalid data for year in line 1 1-64.
NOTE: Invalid data for us in line 2 1-67.
NOTE: Invalid data for canada in line 3 1-63.
NOTE: Invalid data for australia in line 4 1-67.
NOTE: Invalid data for japan in line 5 1-67.
NOTE: Invalid data for france in line 6 1-67.
NOTE: Invalid data for germany in line 7 1-67.
NOTE: Invalid data for italy in line 8 1-67.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+-
8 CHAR .1.9.6.6...3...8...3...4...1...6...1...4...1...6...0...3...3...7... 67
ZONE 0303030300030203000302030003020300030203000302030003020300030203000
NUMR 0109060609030E0809030E0409010E0609010E0409010E0609000E0309030E070D0
year=. us=. canada=. australia=. japan=. france=. germany=. italy=. _ERROR_=1 _N_=1
NOTE: Invalid data for year in line 9 1-67.
NOTE: Invalid data for us in line 10 1-67.
NOTE: Invalid data for canada in line 11 1-67.
NOTE: Invalid data for australia in line 12 1-67.
NOTE: Invalid data for japan in line 13 1-67.
NOTE: Invalid data for france in line 14 1-67.
NOTE: Invalid data for germany in line 15 1-67.
NOTE: Invalid data for italy in line 16 1-67.
16 CHAR .1.9.7.4...5...6...5...3...2...7...1...4...2...9...1...6...3...1... 67
ZONE 0303030300030203000302030003020300030203000302030003020300030203000
NUMR 0109070409050E0609050E0309020E0709010E0409020E0909010E0609030E010D0
year=. us=. canada=. australia=. japan=. france=. germany=. italy=. _ERROR_=1 _N_=2
NOTE: Invalid data for year in line 17 1-67.
NOTE: Invalid data for us in line 18 1-63.
NOTE: Invalid data for canada in line 19 1-63.
NOTE: Invalid data for australia in line 20 1-67.
NOTE: Invalid data for japan in line 21 1-67.
NOTE: Invalid data for france in line 22 1-63.
NOTE: Invalid data for germany in line 23 1-63.
NOTE: Invalid data for italy in line 24 1-65.
24 CHAR .1.9.8.2...9...7...1.1...7...2...2...4...8...3...5...6...5...4... 65
ZONE 03030303000302030003030003020300030203000302030003020300030203000
NUMR 0109080209090E0709010109070E0209020E0409080E0309050E0609050E040D0
year=. us=. canada=. australia=. japan=. france=. germany=. italy=. _ERROR_=1 _N_=3
NOTE: Invalid data for year in line 25 1-67.
NOTE: Invalid data for us in line 26 1-63.
NOTE: Invalid data for canada in line 27 1-67.
NOTE: Invalid data for australia in line 28 1-65.
NOTE: Invalid data for japan in line 29 1-69.
NOTE: Invalid data for france in line 30 1-69.
NOTE: Invalid data for germany in line 31 1-67.
NOTE: Invalid data for italy in line 32 1-59.
32 CHAR .1.9.9.0...5...6...8...1...6...9...2...1...9...1...5...7... 59
ZONE 03030303000302030003020300030203000302030003020300030003000
NUMR 0109090009050E0609080E0109060E0909020E0109090E01090509070D0
year=. us=. canada=. australia=. japan=. france=. germany=. italy=. _ERROR_=1 _N_=4
NOTE: Invalid data for year in line 33 1-69.
NOTE: Invalid data for us in line 34 1-73.
NOTE: Invalid data for canada in line 35 1-75.
NOTE: Invalid data for australia in line 36 1-73.
NOTE: Invalid data for japan in line 37 1-67.
NOTE: Invalid data for france in line 38 1-71.
NOTE: Invalid data for germany in line 39 1-71.
NOTE: Invalid data for italy in line 40 1-67.
40 CHAR .1.9.9.8...4...5...8...3...8...4...1...1.1...8...7...5...1.2...3... 67
ZONE 0303030300030203000302030003000302030003030203000302030003030203000
NUMR 0109090809040E0509080E03090809040E010901010E0809070E050901020E030D0
year=. us=. canada=. australia=. japan=. france=. germany=. italy=. _ERROR_=1 _N_=5
NOTE: Invalid data for year in line 41 1-1.
NOTE: LOST CARD.
year=. us=. canada=. australia=. japan=. france=. germany=. italy=. _ERROR_=1 _N_=6
NOTE: 41 records were read from the infile 'f:\ia\data.txt'.
The minimum record length was 1.
The maximum record length was 75.
NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
NOTE: The data set WORK.C has 5 observations and 8 variables.
NOTE: DATA statement used (Total process time):
也尝试过在input那行用
input year 1-4 us 6-9 canada 11-14 australia 16-19 japan 21-23 france 25-28 germany 30-32 italy 34-37;
log显示是:
NOTE: Invalid data for year in line 14 1-4.
NOTE: Invalid data for us in line 14 6-9.
NOTE: Invalid data for canada in line 14 11-14.
NOTE: Invalid data for australia in line 14 16-19.
NOTE: Invalid data for japan in line 14 21-23.
NOTE: Invalid data for france in line 14 25-28.
NOTE: Invalid data for germany in line 14 30-32.
NOTE: Invalid data for italy in line 14 34-37.
14 CHAR .1.9.7.2...5...6...6...2...2...6...1...4...2...9...0...7...3...8... 67
ZONE 0303030300030203000302030003020300030203000302030003020300030203000
NUMR 0109070209050E0609060E0209020E0609010E0409020E0909000E0709030E080D0
year=. us=. canada=. australia=. japan=. france=. germany=. italy=. _ERROR_=1 _N_=14
NOTE: Invalid data for year in line 15 1-4.
NOTE: Invalid data for us in line 15 6-9.
NOTE: Invalid data for canada in line 15 11-14.
NOTE: Invalid data for australia in line 15 16-19.
NOTE: Invalid data for japan in line 15 21-23.
NOTE: Invalid data for france in line 15 25-28.
NOTE: Invalid data for germany in line 15 30-32.
NOTE: Invalid data for italy in line 15 34-37.
15 CHAR .1.9.7.3...4...9...5...5...2...3...1...3...2...8...0...7...3...7... 67
ZONE 0303030300030203000302030003020300030203000302030003020300030203000
NUMR 0109070309040E0909050E0509020E0309010E0309020E0809000E0709030E070D0
year=. us=. canada=. australia=. japan=. france=. germany=. italy=. _ERROR_=1 _N_=15
NOTE: Invalid data for year in line 16 1-4.
NOTE: Invalid data for us in line 16 6-9.
NOTE: Invalid data for canada in line 16 11-14.
NOTE: Invalid data for australia in line 16 16-19.
NOTE: Invalid data for japan in line 16 21-23.
NOTE: Invalid data for france in line 16 25-28.
NOTE: Invalid data for germany in line 16 30-32.
NOTE: Invalid data for italy in line 16 34-37.
16 CHAR .1.9.7.4...5...6...5...3...2...7...1...4...2...9...1...6...3...1... 67
ZONE 0303030300030203000302030003020300030203000302030003020300030203000
NUMR 0109070409050E0609050E0309020E0709010E0409020E0909010E0609030E010D0
year=. us=. canada=. australia=. japan=. france=. germany=. italy=. _ERROR_=1 _N_=16
NOTE: Invalid data for year in line 17 1-4.
NOTE: Invalid data for us in line 17 6-9.
NOTE: Invalid data for canada in line 17 11-14.
NOTE: Invalid data for australia in line 17 16-19.
NOTE: Invalid data for japan in line 17 21-23.
NOTE: Invalid data for france in line 17 25-28.
NOTE: Invalid data for germany in line 17 30-32.
NOTE: Invalid data for italy in line 17 34-37.
17 CHAR .1.9.7.5...8...5...6...9...4...9...1...9...4...2...3...4...3...4... 67
ZONE 0303030300030203000302030003020300030203000302030003020300030203000
NUMR 0109070509080E0509060E0909040E0909010E0909040E0209030E0409030E040D0
year=. us=. canada=. australia=. japan=. france=. germany=. italy=. _ERROR_=1 _N_=17
NOTE: Invalid data for year in line 18 1-4.
NOTE: Invalid data for us in line 18 6-9.
NOTE: Invalid data for canada in line 18 11-14.
NOTE: Invalid data for australia in line 18 16-19.
NOTE: Invalid data for japan in line 18 21-23.
NOTE: Invalid data for france in line 18 25-28.
NOTE: Invalid data for germany in line 18 30-32.
NOTE: Invalid data for italy in line 18 34-37.
18 CHAR .1.9.7.6...7...7...7...2...4...8...2...4...6...3...4...3...9... 63
ZONE 030303030003020300030203000302030003000302030003020300030203000
NUMR 0109070609070E0709070E0209040E08090209040E0609030E0409030E090D0
year=. us=. canada=. australia=. japan=. france=. germany=. italy=. _ERROR_=1 _N_=18
NOTE: Invalid data for year in line 19 1-4.
NOTE: Invalid data for us in line 19 6-9.
NOTE: Invalid data for canada in line 19 11-14.
NOTE: Invalid data for australia in line 19 16-19.
NOTE: Invalid data for japan in line 19 21-23.
NOTE: Invalid data for france in line 19 25-28.
NOTE: Invalid data for germany in line 19 30-32.
NOTE: Invalid data for italy in line 19 34-37.
19 CHAR .1.9.7.7...7...1...8...1...5...6...2...5...2...3...4...4...1... 63
ZONE 030303030003020300030203000302030003000302030003020300030203000
NUMR 0109070709070E0109080E0109050E06090209050E0209030E0409040E010D0
year=. us=. canada=. australia=. japan=. france=. germany=. italy=. _ERROR_=1 _N_=19
NOTE: Invalid data for year in line 20 1-4.
NOTE: Invalid data for us in line 20 6-9.
NOTE: Invalid data for canada in line 20 11-14.
NOTE: Invalid data for australia in line 20 16-19.
NOTE: Invalid data for japan in line 20 21-23.
NOTE: Invalid data for france in line 20 25-28.
NOTE: Invalid data for germany in line 20 30-32.
NOTE: Invalid data for italy in line 20 34-37.
ERROR: Limit set by ERRORS= option reached. Further errors of this type will not be printed.
20 CHAR .1.9.7.8...6...1...8...4...6...3...2...3...5...4...3...3...4...1... 67
ZONE 0303030300030203000302030003020300030203000302030003020300030203000
NUMR 0109070809060E0109080E0409060E0309020E0309050E0409030E0309040E010D0
year=. us=. canada=. australia=. japan=. france=. germany=. italy=. _ERROR_=1 _N_=20
NOTE: 41 records were read from the infile 'f:\ia\data.txt'.
The minimum record length was 1.
The maximum record length was 75.
NOTE: SAS went to a new line when INPUT statement reached past the end of a line.
NOTE: The data set WORK.D has 40 observations and 8 variables.
data example2;
infile'd:\sas\example2.txt';
input year us canada australia japan france germany italy;
run;
proc print;
run;
NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) 9.1 (TS1M3)
Licensed to Demo SID, Site 0047162208.
NOTE: This session is executing on the XP_HOME platform.
NOTE: SAS initialization used:
real time 5.34 seconds
cpu time 1.04 seconds
1 data example2;
2 infile'd:\sas\example2.txt';
3 input year us canada australia japan france germany italy;
4 run;
NOTE: The infile 'd:\sas\example2.txt' is:
File Name=d:\sas\example2.txt,
RECFM=V,LRECL=256
NOTE: 40 records were read from the infile 'd:\sas\example2.txt'.
The minimum record length was 28.
The maximum record length was 36.
NOTE: The data set WORK.EXAMPLE2 has 40 observations and 8 variables.
NOTE: DATA statement used (Total process time):
real time 0.28 seconds
cpu time 0.03 seconds
5 proc print;
6 run;
NOTE: There were 40 observations read from the data set WORK.EXAMPLE2.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.12 seconds
cpu time 0.00 seconds
Obs year us canada australia japan france germany italy
1 1959 5.5 5.6 2.1 2.3 1.6 2.0 4.8
2 1960 5.5 6.5 1.6 1.7 1.5 1.1 3.7
3 1961 6.7 6.7 3.0 1.5 1.2 0.6 3.2
4 1962 5.5 5.5 2.9 1.3 1.4 0.6 2.8
5 1963 5.7 5.2 2.3 1.3 1.6 0.5 2.4
6 1964 5.2 4.4 1.4 1.2 1.2 0.4 2.7
7 1965 4.5 3.6 1.3 1.2 1.6 0.3 3.5
8 1966 3.8 3.4 1.6 1.4 1.6 0.3 3.7
9 1967 3.8 3.8 1.9 1.3 2.1 1.3 3.4
10 1968 3.6 4.5 1.8 1.2 2.7 1.1 3.5
11 1969 3.5 4.4 1.8 1.1 2.3 0.6 3.5
。。。。。。。。。。。。。。。。。。。。。。。。。。。。作者: shiyiming 时间: 2008-7-3 17:26 标题: Re: 请问怎样用input导入txt格式的数据(急,在线等) 这个问题还真没看出什么问题,最多你把那些整数后面加上.0 以便和其他的数据保持一致。
你写的代码是
data a;
infile 'f:\sas\data.txt';
input year us canada australia japan france germany italy;
run;
log显示是:
14 data c;
15 infile 'f:\ia\data.txt';
16 input year us canada australia japan france germany italy;
17 run;
这里[color=#FF0000:rxjd8hay]为什么目录成'f:\ia\data.txt'这个了[/color:rxjd8hay],没弄明白。。。
而且[color=#FF0000:rxjd8hay]生成的表名也变成了C[/color:rxjd8hay],真是不可思议。。。大家看看这个是什么原因?作者: shiyiming 时间: 2008-7-3 22:34 标题: Re: 请问怎样用input导入txt格式的数据(急,在线等) 如果我写的代码可以运行的话,那难道是那个txt文件里数据输入全角半角的问题?
因为我看它数据之间的间隔很大
那这样的话怎么办呢?
另:谢谢热心的大家:)作者: shiyiming 时间: 2008-7-4 14:36 标题: Re: 请问怎样用input导入txt格式的数据(急,在线等) 回答楼上的,我是把数据复制到我自己的计算机里的文件夹下,所以infile路径改了啊!另外,我生成的表取了个名字啊,所以就取了一个C作为名字啦!这些不影响程序的运行啊!另外,我是直接从上面复制过去的,运行没有任何问题,不知道楼上的是什么原因了!作者: shiyiming 时间: 2008-7-4 15:09 标题: Re: 请问怎样用input导入txt格式的数据(急,在线等) 当然这个问题还可能是你txt文件的问题,txt里面有个转化成什么格式的,你再试试,上次我遇到的也使这个问题,你看着空格很长,实际上并不是那样的。作者: shiyiming 时间: 2008-7-4 15:40 标题: Re: 请问怎样用input导入txt格式的数据(急,在线等) 我用的是SAS9.1.3版本。
data a;
infile "d:\lecsas\f1.txt";
input Year US Can Austr Japan Fran Germa Italy;
run;
你的文本我copy到了d:\lecsas\f1.txt。
运行log如下
191 data a;
192 infile "d:\lecsas\f1.txt";
193 input Year US Can Austr Japan Fran Germa Italy;
194 run;