Teaching Plan

First week:


 * SAS environment introduction


 * Import Data-using Excel File(Example No.1-height and weight):


 * Simple programming: Proc Means-Class Statement; Proc Sort-By Statement, OUT=option, OUTPUT OUT; Proc Reg, Proc Print

Questions:

1. How to calculate the average age, weight and height of the whole population?

2. How many observations are inside the data?

3. How to calculate the female's and male's average age, weight and height?

(Using Class or By Statement)

4. What are differences between By Statement and Class statement?

5. How to avoid overwriting your initial data set?

(OUT=option)

6. How to create an ouput SAS data set that contains only the mean of the outcome we got before?

(OUTPUT OUT=SAS-data-set)


 * Export the summarized outcome


 * Example No.2


 * Introduce useful resources on-line: Wiki, SAS on-line documentation

Second Week:


 * Import Data-using text File(Example No.3 No.4)


 * Infile and Input statements-Distinguish the column input and list input


 * Format data-Format Procedure


 * Simple programing:Proc FREQ, Proc Report, Proc REG


 * Quick-Quiz

Examples:

Fitness Excel Spreadsheet example

Height and Weight Excel Spreadsheet example

column input example

list input example

Proc Freq Example

User:Ywang10/Work