我导入一个CSV的文件
1 PROC IMPORT OUT= work.Factors
2 DATAFILE= "E:\
3 f.csv"
4 DBMS=CSV REPLACE;
5 GETNAMES=YES;
6 DATAROW=2;
7 RUN;
,可是LOG里面出来的语句我看了下,变成这样
data JPMINCH.FACTORS ;
17 %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
18 infile 'E:\f.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
19 informat year best32. ;
20 informat month best32. ;
21 informat premiumre $1. ;
22 informat regap $1. ;
23 informat premiumstd $1. ;
24 informat stdgap $1. ;
25 informat premiumtime $1. ;
26 informat timegap $1. ;
27 format year best12. ;
28 format month best12. ;
29 format premiumre $1. ;
30 format regap $1. ;
31 format premiumstd $1. ;
32 format stdgap $1. ;
33 format premiumtime $1. ;
34 format timegap $1. ;
35 input
36 year
37 month
38 premiumre $
39 regap $
40 premiumstd $
41 stdgap $
42 premiumtime $
43 timegap $
44 ;
45 if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */
46 run;
话说,为何默认的导入会自动把我的那些变量设成长度为1呢?CSV里面的格式是和year,month这些变量一样的呀,从来没遇到过这种情况,请教各位大大