4 读入数据.pptVIP

读入数据 Presented by 经济实验教学中心 商务数据挖掘中心 Week 2 Topic - Reading in data Programs 1 and 2 in course notes Chapter 12:A-F,I,J (C S) Chapter 13:A-D,G (C S) Chapter 2 (Little SAS Book) Handout - Homework (1) C S Available at bookstore Summary of Ways of Reading in Data You may not have a choice - data may come to you with a certain format List directed input - data must be separated by a delimiter; must read in all variables. Use informat statement for special data. Column input - data in fixed columns;must know where each variable starts and ends; can read in selected variables Pointers and Informats - alternative to column input; most flexible; must be used for special data SOME INFILE OPTIONS OBS - limits number of observations read FIRSTOBS - start reading from this obs. MISSOVER and PAD - used to read in data with short records LRECL - needed when you have data with long records * Raw Data Read in Data Process Data (Create new variables) Output Data (Create SAS Dataset) Analyze Data Using Statistical Procedures Data Step PROCs Program 1 * List Directed Input: Reading data values separated by spaces.; DATA bp; INFILE DATALINES; INPUT clinic $ dbp6 sbp6 dbpbl sbpbl; DATALINES; C 84 138 93 143 D 89 150 91 140 A 78 116 100 162 A . . 86 155 C 81 145 86 140 ; RUN ; TITLE Data Separated by Spaces; PROC PRINT DATA=bp; RUN; Obs clinic dbp6 sbp6 dbpbl sbpbl 1 C 84 138 93 143 2 D 89 150 91 140 3 A 78 116 100 162 4 A . . 86 155 5 C 81 145 86 140 PARTIAL SASLOG 1 DATA bp; 2 INFILE DATALINES; 3 INPUT clinic $ dbp6 sbp6 dbpbl sbpbl; 4 DATALINES; NOTE: The data set WORK.BP has 5 observations and 5 variables. NOTE: DATA statement used: real time 0.39 seconds cpu time 0.03 seconds * List Directed Input: Reading data values separated by commas; DATA bp;