SAS 9 Study Guide Preparing for the Base Programming Certification Exam for SAS 9

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

ISBN: 9780470164983 | 0470164980
Cover: Paperback
Copyright: 7/27/2007

Buy New

Print on Demand: 2-4 Weeks. This item cannot be cancelled or returned.

$112.37

Currently, the only SAS Base Certification Exam study guide on the market is published by theÂ SAS Institute, Inc. SAS Study Guide presents an alternative aid that isÂ written from the viewpoint of a SAS certified, but not SAS affiliated, author. Each study topic is givenÂ its own chapter of focus, providingÂ both a conceptual and practical approach to each area of focus, as every explanation is followed by an example. A breakdown of key facts is provided at the end of each chapter, as well as practice questions that are presented in the same format as they appear on the actual certification exam.Â The author provides the answers to these practice questions, along with tips for remembering and applying the necessary Base SAS skills.

Preface	p. xi
Introduction	p. 1
Accessing Data	p. 5
Using FORMATTED, LIST, and COLUMN input to read raw data files	p. 5
LIST input	p. 6
COLUMN input	p. 9
FORMATTED input	p. 10
NAMED input	p. 11
Using INFILE statement options to control processing when reading raw data files	p. 12
MISSOVER	p. 12
PAD	p. 13
TRUNCOVER	p. 14
Using various components of an INPUT statement	p. 14
Column pointer	p. 14
Line pointer	p. 16
Accessing existing SAS data sets with DATA step statements	p. 17
Combining SAS data sets using DATA step statements	p. 18
Contactenating	p. 18
Interleaving	p. 19
One-to-one reading	p. 21
One-to-merging	p. 22
Match-merging	p. 23
Updating datasets	p. 26
Chapter summary	p. 29
Two-minute drill	p. 30
Assessment exam	p. 30
Assessment exam answers	p. 31
Practice exam	p. 32
Practice exam answers	p. 32
Problems	p. 51
Problem solutions	p. 52
Creating Data Structures	p. 55
Creating temporary and permanent SAS datasets	p. 55
Two-level names	p. 55
One-level names	p. 56
Explaining how the DATA step is compiled and executed	p. 56
Compilation phase	p. 56
Execution phase	p. 57
DATA step boundary and type	p. 58
When variable values are set to "missing" automatically	p. 58
Using the DATA step to export data to standard and comma-delimited raw data file	p. 61
Creating an external file with column-aligned data	p. 61
Creating and manipulating the SAS date values	p. 62
Processing time data	p. 63
Processing datetime values	p. 64
Understanding the role of a BY statement in the DATA step	p. 65
Understanding the BY group	p. 65
How the DATA step identifies the BY group	p. 65
Controlling which variables and observations in a SAS dataset are processed	p. 66
Differences between IF and WHERE statements	p. 68
Incorrect use of IF statement	p. 68
When as an alternative to IF-THEN/ELSE coding	p. 68
Chapter summary	p. 70
Two-minute drill	p. 71
Assessment exam	p. 73
Assessment exam answers	p. 73
Practice exam	p. 78
Practice exam answers
Problems	p. 79
Problem solutions	p. 80
Managing Data	p. 85
Investigating SAS data libraries using Base SAS utility procedures	p. 85
PROC DATASETS	p. 85
PROC CONTENTS	p. 89
PROC SORT	p. 91
PROC COPY	p. 91
PROC FORMAT
Using SAS procedures to investigate and evaluate the quality of data	p. 94
PROC FREQ	p. 94
PROC MEANS	p. 96
PROC SUMMARY	p. 101
Sorting observations in a SAS dataset	p. 102
BY statement	p. 102
Other options	p. 103
Modifying variable attributes using options and statements in the DATA step	p. 104
Conditionally executing SAS statements	p. 107
WHERE statement and comparison with IF statement	p. 107
IF-THEN/ELSE statement	p. 110
SELECT statement	p. 111
Using assignment statements in the DATA step	p. 112
Accumulating subtotals and totals using DATA step statements	p. 112
SUM statement	p. 112
SUM function	p. 114
Using SAS functions to manipulate character data, numeric data, and SAS date values	p. 114
Using SAS functions to convert character data to numeric data and vice versa	p. 119
Processing data using DO Loops	p. 119
DO	p. 120
Iterative DO	p. 120
DO UNTIL	p. 123
DO WHILE	p. 123
Processing data using SAS ARRAYs	p. 124
Chapter summary	p. 126
Two-minute drill	p. 127
Assessment exam	p. 131
Assessment exam answers	p. 132
Practice exam	p. 134
Practice exam answers	p. 139
Problems	p. 141
Problem solutions	p. 142
Generating Reports	p. 147
Generating list reports using the PRINT and REPORT procedures	p. 147
PRINT procedure	p. 147
REPORT procedure	p. 152
Generating summary reports and frequency tables using Base SAS procedures	p. 157
PROC TABULATE	p. 157
Enhancing reports through the use of titles, footnotes, labels, SAS formats, user-defined formats, and SAS system reporting options	p. 176
TITLE	p. 176
FOOTNOTE	p. 176
LABEL	p. 177
FORMAT	p. 177
SAS reporting options	p. 178
Generating HTML reports using ODS statements	p. 178
The ODS statement	p. 179
Other literature on ODS	p. 180
Chapter summary	p. 180
Two-minute drill	p. 181
Assessment exam	p. 183
Assessment exam answers	p. 184
Practice exam	p. 186
Practice exam answers	p. 189
Problems	p. 191
Problems solutions	p. 192
Handling Errors	p. 195
Recognizing and correcting syntax errors	p. 195
Identifying and correcting semantic errors	p. 198
Examining and resolve execution-time errors	p. 200
Identifying and correcing data errors
Examining and resolving macro-related errors	p. 205
Identifying and resolving programming logic errors	p. 205
DATA step debugger	p. 207
PUT statement	p. 208
Chapter summary	p. 211
Two-minute drill	p. 212
Assessment exam	p. 213
Assessment exam answers	p. 213
Practice exam	p. 215
Practice exam answers	p. 221
Problems	p. 223
Problem solutions	p. 229
Index	p. 231
Table of Contents provided by Ingram. All Rights Reserved.

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

SAS 9 Study Guide Preparing for the Base Programming Certification Exam for SAS 9

Summary

Author Biography

Table of Contents

Supplemental Materials