Data Transformation - OU数据转换-欧.ppt

Data Transformation Data cleaning Importing Data Reading data from external formats Libname/Infile/Input for text form data Proc Import for Excel/Access data ODBC for external database data Importing an Excel Spreadsheet PROC IMPORT OUT= WORK.Fall2007 DATAFILE= L:\DataWarehousing07f\CourseDatabase\Fall2007.xls DBMS=EXCEL REPLACE; SHEET=Fall 07$; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; Import an Access Table PROC IMPORT OUT= WORK.OrderLine DATATABLE= OrderLin DBMS=ACCESS REPLACE; DATABASE=I:\DataWarehousing07f\WholesaleProducts.mdb; SCANMEMO=YES; USEDATE=NO; SCANTIME=YES; RUN; ? Good Practice Check the metadata for a dataset PROC CONTENTS DATA= OrderLine; RUN; Print a few records PROC PRINT DATA= OrderLine (OBS= 10); RUN; Saving SAS Datasets LIBNAME course L:\DataWarehousing07f\CourseDatabase; Data course.Spring2008; set spring2008; run; Note: the name associated with the libname command (“course”) must be 8 characters or less. LIBNAME / INFILE / INPUT for character data LIBNAME identifies the location or folder where the data file is stored INFILE specifies the libname to use for reading external data. INPUT reads text format data SET reads SAS data INFILE with INPUT for character data files DATA Fitness; INFILE L:\DataWarehousing07f\TransformationSAS\SAS1.txt; INPUT NAME $ WEIGHT WAIST PULSE CHINS SITUPS JUMPS; run; Creating Derived Attributes Generating new attributes for a table. SAS creates attributes when they are referred to in a data step. The metadata depends on the context of the code. LENGTH statements FORMAT statements FORMATS and INFORMATS PUT INPUT PUT and INPUT Functions TextOutput = PUT(variable, format) Note: the result of a put function