Acknowledgments |
|
ix | |
Introducing SAS Software |
|
x | |
About This Book |
|
xi | |
What's New |
|
xiv | |
Chapter 1 Getting Started Using SAS® Software |
|
|
|
2 | (2) |
|
|
4 | (2) |
|
1.3 The Two Parts of a SAS Program |
|
|
6 | (2) |
|
1.4 The DATA Step's Built-in Loop |
|
|
8 | (2) |
|
1.5 Choosing a Mode for Submitting SAS Programs |
|
|
10 | (2) |
|
1.6 Windows and Commands in the SAS Windowing Environment |
|
|
12 | (2) |
|
1.7 Submitting a Program in the SAS Windowing Environment |
|
|
14 | (2) |
|
|
16 | (2) |
|
1.9 Viewing Your Results in the Output Window |
|
|
18 | (2) |
|
1.10 Creating HTML Output |
|
|
20 | (2) |
|
|
22 | (2) |
|
1.12 Viewing Data Sets with SAS Explorer |
|
|
24 | (2) |
|
1.13 Using SAS System Options |
|
|
26 | (4) |
Chapter 2 Getting Your Data into SAS® |
|
|
2.1 Methods for Getting Your Data into SAS |
|
|
30 | (2) |
|
2.2 Entering Data with the Viewtable Window |
|
|
32 | (2) |
|
2.3 Reading Files with the Import Wizard |
|
|
34 | (2) |
|
2.4 Telling SAS Where to Find Your Raw Data |
|
|
36 | (2) |
|
2.5 Reading Raw Data Separated by Spaces |
|
|
38 | (2) |
|
2.6 Reading Raw Data Arranged in Columns |
|
|
40 | (2) |
|
2.7 Reading Raw Data Not in Standard Format |
|
|
42 | (2) |
|
|
44 | (2) |
|
|
46 | (2) |
|
2.10 Reading Messy Raw Data |
|
|
48 | (2) |
|
2.11 Reading Multiple Lines of Raw Data per Observation |
|
|
50 | (2) |
|
2.12 Reading Multiple Observations per Line of Raw Data |
|
|
52 | (2) |
|
2.13 Reading Part of a Raw Data File |
|
|
54 | (2) |
|
2.14 Controlling Input with Options in the INFILE Statement |
|
|
56 | (2) |
|
2.15 Reading Delimited Files with the DATA Step |
|
|
58 | (2) |
|
2.16 Reading Delimited Files with the IMPORT Procedure |
|
|
60 | (2) |
|
2.17 Reading PC Files with the IMPORT Procedure |
|
|
62 | (2) |
|
2.18 Reading PC Files with DDE |
|
|
64 | (2) |
|
2.19 Temporary versus Permanent SAS Data Sets |
|
|
66 | (2) |
|
2.20 Using Permanent SAS Data Sets with LIBNAME Statements |
|
|
68 | (2) |
|
2.21 Using Permanent SAS Data Sets by Direct Referencing |
|
|
70 | (2) |
|
2.22 Listing the Contents of a SAS Data Set |
|
|
72 | (4) |
Chapter 3 Working with Your Data |
|
|
3.1 Creating and Redefining Variables |
|
|
76 | (2) |
|
|
78 | (2) |
|
3.3 Selected SAS Functions |
|
|
80 | (2) |
|
3.4 Using IF-THEN Statements |
|
|
82 | (2) |
|
3.5 Grouping Observations with IF-THEN/ELSE Statements |
|
|
84 | (2) |
|
|
86 | (2) |
|
3.7 Working with SAS Dates |
|
|
88 | (2) |
|
3.8 Selected Date Informats, Functions, and Formats |
|
|
90 | (2) |
|
3.9 Using the RETAIN and Sum Statements |
|
|
92 | (2) |
|
3.10 Simplifying Programs with Arrays |
|
|
94 | (2) |
|
3.11 Using Shortcuts for Lists of Variable Names |
|
|
96 | (4) |
Chapter 4 Sorting, Printing, and Summarizing Your Data |
|
|
|
100 | (2) |
|
4.2 Subsetting in Procedures with the WHERE Statement |
|
|
102 | (2) |
|
4.3 Sorting Your Data with PROC SORT |
|
|
104 | (2) |
|
4.4 Printing Your Data with PROC PRINT |
|
|
106 | (2) |
|
4.5 Changing the Appearance of Printed Values with Formats |
|
|
108 | (2) |
|
4.6 Selected Standard Formats |
|
|
110 | (2) |
|
4.7 Creating Your Own Formats Using PROC FORMAT |
|
|
112 | (2) |
|
4.8 Writing Simple Custom Reports |
|
|
114 | (2) |
|
4.9 Summarizing Your Data Using PROC MEANS |
|
|
116 | (2) |
|
4.10 Writing Summary Statistics to a SAS Data Set |
|
|
118 | (2) |
|
4.11 Counting Your Data with PROC FREQ |
|
|
120 | (2) |
|
4.12 Producing Tabular Reports with PROC TABULATE |
|
|
122 | (2) |
|
4.13 Adding Statistics to PROC TABULATE Output |
|
|
124 | (2) |
|
4.14 Enhancing the Appearance of PROC TABULATE Output |
|
|
126 | (2) |
|
4.15 Changing Headers in PROC TABULATE Output |
|
|
128 | (2) |
|
4.16 Specifying Multiple Formats for Data Cells in PROC TABULATE Output |
|
|
130 | (2) |
|
4.17 Producing Simple Output with PROC REPORT |
|
|
132 | (2) |
|
4.18 Using DEFINE Statements in PROC REPORT |
|
|
134 | (2) |
|
4.19 Creating Summary Reports with PROC REPORT |
|
|
136 | (2) |
|
4.20 Adding Summary Breaks to PROC REPORT Output |
|
|
138 | (2) |
|
4.21 Adding Statistics to PROC REPORT Output |
|
|
140 | (4) |
Chapter 5 Enhancing Your Output with ODS |
|
|
5.1 Concepts of the Output Delivery System |
|
|
144 | (2) |
|
5.2 Tracing and Selecting Procedure Output |
|
|
146 | (2) |
|
5.3 Creating SAS Data Sets from Procedure Output |
|
|
148 | (2) |
|
5.4 Using ODS Statements to Create HTML Output |
|
|
150 | (2) |
|
5.5 Using ODS Statements to Create RTF Output |
|
|
152 | (2) |
|
5.6 Using ODS Statements to Create PRINTER Output |
|
|
154 | (2) |
|
5.7 Customizing Titles and Footnotes |
|
|
156 | (2) |
|
5.8 Customizing PROC PRINT Output with the STYLE= Option |
|
|
158 | (2) |
|
5.9 Customizing PROC REPORT Output with the STYLE= Option |
|
|
160 | (2) |
|
5.10 Customizing PROC TABULATE Output with the STYLE= Option |
|
|
162 | (2) |
|
5.11 Adding Traffic-Lighting to Your Output |
|
|
164 | (2) |
|
5.12 Selected Style Attributes |
|
|
166 | (4) |
Chapter 6 Modifying and Combining SAS® Data Sets |
|
|
6.1 Modifying a Data Set Using the SET Statement |
|
|
170 | (2) |
|
6.2 Stacking Data Sets Using the SET Statement |
|
|
172 | (2) |
|
6.3 Interleaving Data Sets Using the SET Statement |
|
|
174 | (2) |
|
6.4 Combining Data Sets Using a One-to-One Match Merge |
|
|
176 | (2) |
|
6.5 Combining Data Sets Using a One-to-Many Match Merge |
|
|
178 | (2) |
|
6.6 Merging Summary Statistics with the Original Data |
|
|
180 | (2) |
|
6.7 Combining a Grand Total with the Original Data |
|
|
182 | (2) |
|
6.8 Updating a Master Data Set with Transactions |
|
|
184 | (2) |
|
6.9 Using SAS Data Set Options |
|
|
186 | (2) |
|
6.10 Tracking and Selecting Observations with the IN= Option |
|
|
188 | (2) |
|
6.11 Writing Multiple Data Sets Using the OUTPUT Statement |
|
|
190 | (2) |
|
6.12 Making Several Observations from One Using the OUTPUT Statement |
|
|
192 | (2) |
|
6.13 Changing Observations to Variables Using PROC TRANSPOSE |
|
|
194 | (2) |
|
6.14 Using SAS Automatic Variables |
|
|
196 | (4) |
Chapter 7 Writing Flexible Code with the SAS® Macro Facility |
|
|
|
200 | (2) |
|
7.2 Substituting Text with Macro Variables |
|
|
202 | (2) |
|
7.3 Creating Modular Code with Macros |
|
|
204 | (2) |
|
7.4 Adding Parameters to Macros |
|
|
206 | (2) |
|
7.5 Writing Macros with Conditional Logic |
|
|
208 | (2) |
|
7.6 Writing Data-Driven Programs with CALL SYMPUT |
|
|
210 | (2) |
|
7.7 Debugging Macro Errors |
|
|
212 | (4) |
Chapter 8 Using Basic Statistical Procedures |
|
|
8.1 Examining the Distribution of Data with PROC UNIVARIATE |
|
|
216 | (2) |
|
8.2 Producing Statistics with PROC MEANS |
|
|
218 | (2) |
|
8.3 Testing Categorical Data with PROC FREQ |
|
|
220 | (2) |
|
8.4 Examining Correlations with PROC CORR |
|
|
222 | (2) |
|
8.5 Using PROC REG for Simple Regression Analysis |
|
|
224 | (2) |
|
8.6 Reading the Output of PROC REG |
|
|
226 | (2) |
|
8.7 Using PROC ANOVA for One-Way Analysis of Variance |
|
|
228 | (2) |
|
8.8 Reading the Output of PROC ANOVA |
|
|
230 | (2) |
|
8.9 Graphical Interfaces for Statistical Analysis |
|
|
232 | (4) |
Chapter 9 Exporting Your Data |
|
|
9.1 Methods for Exporting Your Data |
|
|
236 | (2) |
|
9.2 Writing Files Using the Export Wizard |
|
|
238 | (2) |
|
9.3 Writing Delimited Files with the EXPORT Procedure |
|
|
240 | (2) |
|
9.4 Writing PC Files with the EXPORT Procedure |
|
|
242 | (2) |
|
9.5 Writing Raw Data Files with the DATA Step |
|
|
244 | (2) |
|
9.6 Writing Delimited and HTML Files using ODS |
|
|
246 | (2) |
|
9.7 Sharing SAS Data Sets with Other Types of Computers |
|
|
248 | (4) |
Chapter 10 Debugging Your SAS® Programs |
|
|
10.1 Writing SAS Programs That Work |
|
|
252 | (2) |
|
10.2 Fixing Programs That Don't Work |
|
|
254 | (2) |
|
10.3 Searching for the Missing Semicolon |
|
|
256 | (2) |
|
10.4 Note: INPUT Statement Reached Past the End of the Line |
|
|
258 | (2) |
|
|
260 | (2) |
|
|
262 | (2) |
|
10.7 Note: Missing Values Were Generated |
|
|
264 | (2) |
|
10.8 Note: Numeric Values Have Been Converted to Character (or Vice Versa) |
|
|
266 | (2) |
|
10.9 DATA Step Produces Wrong Results but No Error Message |
|
|
268 | (2) |
|
10.10 The DATA Step Debugger |
|
|
270 | (2) |
|
10.11 Error: Invalid Option, Error: The Option Is Not Recognized, or Error: Statement Is Not Valid |
|
|
272 | (2) |
|
10.12 Note: Variable Is Uninitialized or Error: Variable Not Found |
|
|
274 | (2) |
|
10.13 SAS Truncates a Character Variable |
|
|
276 | (2) |
|
10.14 SAS Stops in the Middle of a Job |
|
|
278 | (2) |
|
10.15 SAS Runs Out of Memory or Disk Space |
|
|
280 | (4) |
Appendices |
|
|
|
284 | (2) |
|
B Getting Help from SAS Technical Support |
|
|
286 | (2) |
|
C An Overview of SAS Products |
|
|
288 | (3) |
|
D Coming to SAS from SPSS |
|
|
291 | (7) |
|
E Coming to SAS from a Programming Language |
|
|
298 | (4) |
|
|
302 | (7) |
Index |
|
309 | |