Introduction SAS Base Certificate

Introduction SAS Base Certificate

Introduction to SAS and SAS Fundamental Concepts

1. Overview of the SAS System

2. What Can SAS Do?

3. Components of the SAS Language

4. SAS Display Manager System

5. Basic Structure of SAS

6. Preliminary Concepts and Rules

7. SAS Resources

Accessing Data and Creating Data Structures

SAS Expression and Functions

1. Overview of Operators in SAS

2. Infix Operators in SAS

3. SAS expression & Conditional expression (WHERE and IF)

4. Numeric functions

5. SAS Time and Date

6. Character functions

7. Global Statements

Overview of Multiple Data Sets

1. Concatenating data set using Set statement

2. Interleaving several datasets

3. Modifying (creating) data set

4. Concatenating data set using PROC APPEND

5. Merging datasets

6. Updating dataset

7. PROC EXPORT/IMPORT

8. PROC CONTENTS

Managing Data

1. Conditionally IF-THEN-ELSE execute SAS statements

2. SORT observations in a SAS data set

3. KEEP, DROP, DELETE, RENAME, RETAIN, BY, FILE, PUT and OUTPUT Statements

4. PROC FORMAT

5. SAS DO-LOOPS

6. SAS Array

Generating Reports

1. Generating reports using the PRINT procedure

2. Generating frequency tables using PROC FREQ procedure

3. Generating report using MEANS procedure

4. Generating report using REPORT procedure

5. Enhancing report through the use of labels, SAS format, titles, footnotes and SAS System reporting options

6. Introduction to ODS

SAS CO-OP

Part I ON SITE

Project I

Difference of Profits for Items among Four Retail Stores

Background

The data for quantity and unit price for each of items from four retail stores in December 2002 were collected. These items were DVD, VCR, HP and Epson Printer, TV stand and PC desk. The objective of this analysis is to compare the differences of profits.

Statistical Analysis Plan-SAP

Building Customized Report with PROC REPORT procedure
Summarizing descriptive statistics for continuous variables
Comparing the differences of profits among four retail stores using PROC GLM procedure
Comparing the differences of profits for same items (such as DVD, VCR, PC desk) among retail stores using PROC GLM procedure
Comparing the differences of profits for TV Stand, Printers between two stores with PROC TTEST procedure

Required Base SAS Skill

Data cleaning
Data manipulation, combination
PROC Format
PROC SORT, PRINT, MEANS, FREQ, UNIVARIATE, REPORT Procedures
PROC TTEST and PROC GLM

Project II Analysis of Total Sales of Desk top PC and LCD

Background

As contract agreement requested, these records of business transaction from January 1, 2005 through March 31, 2005 were provided for you. The objective of analytical plan is to obtain total sale values for each product, each brand and so forth, further compare whether the average sales are significantly different among the different brands of desktop PC and LCD monitor during the first quarter in 2005.

Statistical Analysis Plan-SAP
-To summarize the total sales for each item among the different brands of desktop PC and of LCD.
-To summarize the total sales for each of different brands of desktop PC and of LCD.
-To report to us with the highest and lowest sales for each desktop PC and each LCD.
-To present which of the retail would be the best purchaser for the different brands of desktop PC and of LCD.
-To compare the difference of average sales across the different brands of desktop PC and of LCD on the basis of statistical inferences.
-To make comments and suggestions.
Analytical Report
Analytical report must present the approaches to be taken in making conclusions on these data.

Required SAS Skills
Data Checking and Validity
Data Manipulation using SAS Functions and Conditional Statements
Data Processing using SAS Statements and DO LOOPS
Data Combination using Set and Merge
Data Analysis using MEANS, FREQ, T-TEST, ANOVA

Project III Assessment of ESL Support Program

Background

Data were provided by an elementary school in our neighborhood. This project plans to evaluate whether there is relationship between the ESL recommendation and gender and reading score. As planned, students living in Canada less than 5 years are strongly recommended for ESL program. The purpose of this specific project is to develop the model to assess ESL program for improving reading score of students.

Statistical Analytical Plan

To produce the frequency of gender and gender by ESL recommendation.
To test the difference of reading score between having ESL program and without.
To develop the model and assess the model.
To present the reporting including evaluation of the model, the outputs of interpretation.

Required Skills

Statistical knowledge
Data manipulation
PROC TTEST, MEANS, FREQ
Modeling
Writing in English

Benefits

To fully understand the working principle of modeling
To summarize the data
To assess comprehensibly the results
To present completely analytical reporting.

Project VI Rates in Health Database

Background

Health database contained all deaths occurring in town. Each person who died is represented by one line in the data file. The variable AGE gives the age at death. Based on health database and census data, all of rates need to be calculated.

Purpose

To produce the Age-adjusted rate which is a summary measure that eliminates the effect of the underlying age distribution of the population.

Statistical Analysis Plan

Crude Rate
Age Specific Rate
Age-adjusted Rate

Required SAS Skills

Data converted

Data manipulation

Data merge

PROC SORT, FREQ, SQL et al

Part II AT Home

Project I Physical Fitness Study using Linear Regression Model

Background

These measurements on Physical Fitness were made on men. The variables are Age(Years), Weight (kg), Oxygen intake rate (ml per kg body weight per minute), time to run 1.5 miles (minutes), heart rate while resting, heart rate while running (same time Oxygen rate measured), and maximum heart rate recorded while running.

Aerobic fitness (measured by the ability to consume oxygen) is fit to some simple exercise tests. The goal is to develop an equation to predict fitness based on the exercise

tests rather than on expensive and cumbersome oxygen consumption measurements.

Statistical Analysis Plan-SAP

Summarizing descriptive statistics for continuous variables
Testing assumptions
Determining correlations among variables
Testing for multi-collinearity
Selecting models with different methods
Creating model
Testing the fit of model

Required Base SAS Skill

PROC SORT, PRINT, MEANS, UNIVARITE, PLOT Procedures
PROC REG

Project II Low Infant Birth Weight Risk Factor Study using Logistic Regression Model

Background

Low birth weight, defined as birth weight less than 2500 grams, is an outcome that has been of concern to physicians for years. This is due to the fact that infant mortality rates and birth defect rates are very high for low birth weight babies. The data containing information for several variables come from births to women seen in the obstetrics clinic. The goal of analysis is to determine whether these variables are risk factors in the clinic population.

Statistical Analysis Plan-SAP

Summarizing descriptive statistics for continuous and categorical variables
Determining whether mothers who smoke during pregnancy are higher risk fro having a low weight baby using PROC FREQ procedure
Determining whether teenage mothers are at higher risk for having a low weight baby that other mothers
Determining whether race is at higher risk for having a low weight
Determining odds ratio of having a low weight infant for smokers relative to nonsmokers using PROC LOGISTIC procedure
Determining confounding factor and interaction factor
Selecting models with different methods
Testing the model

Required Base SAS Skill

Data manipulation
PROC Format, PROC SORT, PRINT, MEANS, FREQ Procedures
PROC LOGISTIC

III 10 Real Problems & Solutions

10 problems will be provided for you. You can use own SAS skills to solve at home. Your hands-on skills will be definitely enhanced.

(Let someone contact you)

Last update:. Visits -- | Web site design and hosting by WECAN.ca CMS