PBHL 5753 – Application of Microcomputers in Data

Management and Analysis Resource Page

Zoran Bursac, Ph.D., M.P.H.

Wednesday 1-4 PM

COPH Computer Lab Room 1230

PBHL 5753 Application of Microcomputers to Data Management and Analysis (F): Brief overview of software packages commonly used for data management and analysis that include Excel, Access, SPSS and Stata, followed by primary focus on use of SAS software in data management and recoding techniques. These include working with SAS libraries, inputting raw data, reading and writing from external files, using logical structures, using numerical and character functions, working with dates and using arrays. Course focuses on programming techniques with limited use of analytical procedures. Class activities include lecture/discussion and intensive programming work using SAS.

Prerequisite: Prior completion or concurrent enrollment in Biostatistics I is recommended.

You can order a copy of SAS Learning Edition (LE) at support.sas.com/rnd/le/

Required course materials:

Access to SAS or personal copy of SAS LE. Microsoft Office (Excel and Access).

Cody R. The SAS Workbook, SAS Publishing.

Cody R. Learning SAS by Example: A Programmer’s Guide. SAS Publishing.

Other resources:

Cody R, Smith JK. Applied Statistics and the SAS Programming Language, Prentice Hall, 1997.

Delwiche LD, Slaughter SJ. The Little SAS Book: A Primer, SAS Publishing, 1998.

Cody R, Pass R. SAS Programming by Example, SAS Publishing.

FREE SAS v8 and v9 OnlineDocs! Register and use at support.sas.com/documentation/onlinedoc/.

Course handouts, data sets and lecture examples

SYLLABUS

Class data sets (ZIP)

Learning SAS by Example – Cody Materials (ZIP)

SAS Intro lecture and programs; libraries, export, import (ZIP)

Inputting raw data with no missing values (ZIP)

Inputting raw data with missing values (ZIP)

Cody CH3 examples INFILE statement (ZIP)

HW Assignment: Cody CH3 - 2,3,4 (Correction: repeat example 3),6,8,10

SAS BASE PROCEDURES AND ODS (ZIP) NEW EXAMPLES 9-27-06

HW Assignment: Cody CH16 – 1,2; CH17 – 1, then run all pair-wise two-way tables for gender, blood type and age group with a chi-square test; CH19 – 5,6 (Run PROC UNIVARIATE on the same variables as in CH16#1; then follow the directions in #5 and #6 to complete the assignment). In addition write ODS statements that will send the output from first four problems to HTML, RTF and/or PDF files.

Logical structures (ZIP)

Combining SAS data (ZIP)

Numerical functions (ZIP)

Character functions (ZIP)

Working with dates (ZIP)

Using ARRAYS (ZIP)

Dealing with longitudinal data (CH 9 and 10 solutions)

Formatting and labeling variables

SAS SG Procedures