运用import过程进行SAS数据导入完全实用教程
1 单个规范格式文件导入。
对单个文件进行导入是我们遇到最多的情况,主要有以下几种:
1.1 对指定分隔符(’|’,’
’,’!’,’ab’等)数据的导入,这里以’!’为例delimiter='!'进行说明:
data _null_;
file 'c:\temp\pipefile.txt';
put"X1!X2!X3!X4";
put "11!22!.! ";
put "111!.!333!apple";
run;
导入程序:
proc import
datafile='c:\temp\pipefile.txt'
out=work.test
dbms=dlm
replace;
delimiter='!';
GUESSINGROWS=2000;
DATAROW=2;
getnames=yes;
run;
注意GUESSINGROWS的值阈为1 到 3276
1.2 对CSV格式的数据进行导入:
data _null_;
file 'c:\temp\csvfile.csv';
put
"Fruit1,Fruit2,Fruit3,Fruit4";
put
"apple,banana,coconut,date";
put
"apricot,berry,crabapple,dewberry";
run;
导入程序:
proc import
datafile='c:\temp\csvfile.csv'
out=work.fruit
dbms=csv
replace;
run;
1.3 对tab分隔数据的导入:
data _null_;
file 'c:\temp\tabfile.txt';
put "cereal" "09"x "eggs" "09"x
"bacon";
put "muffin" "09"x "berries"
"09"x "toast";
run;
proc import
datafile='c:\temp\tabfile.txt'
out=work.breakfast
dbms=tab
replace;
getnames=no;
run;
1.4 对dbf数据库数据进行导入:
proc import
datafile="/myfiles/mydata.dbf"
out=sasuser.mydata
dbms=dbf
replace;
run;
1.5对excel数据进行导入:
PROC IMPORT OUT= hospital1
DATAFILE= " C:\My Documents\Excel Files\Hospital1.xls "
DBMS=EXCEL REPLACE;
SHEET="Sheet1$";
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;
1.6对access数据进行导入:
PROC IMPORT DBMS=ACCESS
TABLE="customers" OUT=sasuser.cust;
DATABASE="c:\demo\customers.mdb";
UID="bob";
PWD="cat"; WGDB="c:\winnt\system32\system.mdb";
RUN;
proc print data=sasuser.cust;
run;
1.7 import过程步中,dbms选项汇总:
Identifier
Input Data
Source
Extension
Host Av