资源描述:
《sas import导入大全》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、运用import过程进行SAS数据导入完全实用教程 1单个规范格式文件导入。1.1对指定分隔符(’
2、’,’’,’!’,’ab’等)数据的导入,这里以’!’为例delimiter='!'进行说明:data_null_; file'c:temppipefile.txt'; put"X1!X2!X3!X4"; put"11!22!.!"; put"111!.!333!apple";run;procimport datafile='c:temppipefile.txt' out=work.test dbms=dlm replace;de
3、limiter='!';GUESSINGROWS=2000;DATAROW=2; getnames=yes;run;注意GUESSINGROWS的值阈为1到32761.2对CSV格式的数据进行导入:data_null_; file'c:tempcsvfile.csv'; put"Fruit1,Fruit2,Fruit3,Fruit4"; put"apple,banana,coconut,date"; put"apricot,berry,crabapple,dewberry";run;procimport datafile='c:t
4、empcsvfile.csv' out=work.fruit dbms=csv replace;run; 1.3对tab分隔数据的导入:data_null_; file'c:temptabfile.txt'; put"cereal""09"x"eggs""09"x"bacon"; put"muffin""09"x"berries""09"x"toast";run;procimport datafile='c:temptabfile.txt' out=work.breakfast dbms=tab replace; getnam
5、es=no;run; 1.4对dbf数据库数据进行导入:procimportdatafile="/myfiles/mydata.dbf" out=sasuser.mydata dbms=dbf replace;run; 1.5对excel数据进行导入:PROCIMPORTOUT=hospital1 DATAFILE="C:MyDocumentsExcelFilesHospital1.xls" DBMS=EXCELREPL
6、ACE; SHEET="Sheet1$"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES;RUN; 1.6对access数据进行导入:PROCIMPORTDBMS=ACCESSTABLE="customers"OUT=sasuser.cust; DATABASE="c:democustomers.mdb"; UID="bob"; PWD="cat";
7、 WGDB="c:winntsystem32system.mdb"; RUN;procprintdata=sasuser.cust;run; 1.7import过程步中,dbms选项汇总: IdentifierInputDataSourceExtensionHostAvailabilityACCESSMicrosoftAccess2000or2002table.mdbMicrosoftWindows*ACCESS97MicrosoftAccess97table.mdbMicrosoftWindows*ACCESS2000Micr
8、osoftAccess2000table.mdbMicrosoftWindows*ACCESS2002MicrosoftAccess2002table.mdbMicrosoftWindows*ACCESSCSMicrosoftAccesstable.mdbUNIXCSVdelimitedfile(comma-separatedvalues).csvOpenVMSAlpha,UNIX,MicrosoftWindowsDBFdBASE5.0,IV,III+,andIIIfiles.dbfUNIX,MicrosoftWindowsDLMdel
9、imitedfile(defaultdelimiterisablank).*OpenVMSAlpha,UNIX,MicrosoftWindowsEXCELExcel2000or2002spreadsheet