lecture04读和操作数据集并创建详细的报告.ppt

Lecture 4 Reading and Manipulating SAS? Data Sets and Creating Detailed Reports 4、读和操作数据集并创建详细的报告 Section 4.1 Introduction University of Central Florida wants to analyze their applicants’ SAT score and age. Scenario The university must write the relevant data to a SAS data set so that it can be processed further determine the minimum, maximum, and average age and SAT score of applicants assign each applicant a decision (acceptable, unacceptable, and undecided) based on SAT score continued... Scenario determine the number of applicants with acceptable, unacceptable, and undecided status determine the minimum, maximum, and average SAT score for each group of applicants create an enhanced report that lists all of the applicants. Calculating Summary Statistics for All Applicants Creating a New Variable Using Conditional Processing Calculating Summary Statistics for Each Type of Applicants Creating an Enhanced List Report Section 4.2 Creating a SAS Data Set Objectives Create a SAS data set using another SAS data set as input. Read and create permanent SAS data sets. Select variables to store in a SAS data set. Reading a SAS Data Set In order to create a SAS data set using a SAS data set as input, you must start a DATA step and name the SAS data set being created (DATA statement) identify the input SAS data set (SET statement). Reading a SAS Data Set General form of a DATA step: DATA SAS-data-set; SET SAS-data-set; additional SAS statementsRUN; Example: data work.revised; set work.rawdat; run; Reading a SAS Data Set By default, the SET statement reads all of the observations from the input SAS data set all of the variables from the input SAS data set. Selecting Variables to Store in a SAS Data Set You can use a DROP= or KEEP= data set option in a DATA statement to control what variables are written to the new SAS data set. General form of the DROP= and KEEP= data set options: Selecting Variables to St