2024年4月26日发(作者:)
运用import过程进行SAS数据导入完全实用教程
1 单个规范格式文件导入。
1.1 对指定分隔符(’|’,’ ’,’!’,’ab’等)数据的导入,这里以’!’为例delimiter='!'
进行说明:
data _null_;
file 'c:';
put"X1!X2!X3!X4";
put "11!22!.! ";
put "111!.!333!apple";
run;
proc import
datafile='c:'
out=
dbms=dlm
replace;
delimiter='!';
GUESSINGROWS=2000;
DATAROW=2;
getnames=yes;
run;
注意GUESSINGROWS的值阈为1 到 3276
1.2 对CSV格式的数据进行导入:
data _null_;
file 'c:';
put "Fruit1,Fruit2,Fruit3,Fruit4";
put "apple,banana,coconut,date";
put "apricot,berry,crabapple,dewberry";
run;
proc import
datafile='c:'
out=
dbms=csv
replace;
run;
1.3 对tab分隔数据的导入:
data _null_;
file 'c:';
put "cereal" "09"x "eggs" "09"x "bacon";
put "muffin" "09"x "berries" "09"x "toast";
run;
proc import
datafile='c:'
out=ast
dbms=tab
发布评论