Little SAS Book : A Primer, Third Edition

by Delwiche, Lora D.; Slaughter, Susan J.

• ISBN13: 9781590473337
• ISBN10: 1590473337
• Edition: 3rd
• Format: Paperback
• Copyright: 2003-11-01
• Publisher: SAS INSTITUTE, INCORPORATED

Summary

Getting started with SAS is easy with The Little SAS Book. This friendly, easy-to-read guide gently introduces you to the most commonly used features of SAS software plus a whole lot more! The book has been revised to include concepts of the Output Delivery System; the STYLE= option in the PRINT, REPORT, and TABULATE procedures; ODS HTML, RTF, PRINTER, and OUTPUT destinations; PROC REPORT; more on PROC TABULATE; exporting data; and the colon modifier for informats. You'll find clear and concise explanations of basic SAS concepts (such as DATA and PROC steps), inputting data, modifying and combining data sets, summarizing and presenting data, basic statistical procedures, and debugging SAS programs. Each topic is presented in a self-contained, two-page layout complete with examples and graphics. This format enables new users to get up and running quickly, while the examples allow you to type in the program and see it work!

Author Biography

Lora D. Delwiche brings over 20 years of expertise in working with SAS Susan J. Slaughter discovered SAS software in graduate school, over 20 years ago

Table of Contents

Acknowledgments	ix
Introducing SAS Software	x
About This Book	xi
What's New	xiv
Chapter 1 Getting Started Using SAS® Software
1.1 The SAS Language	2	(2)
1.2 SAS Data Sets	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)
1.8 Reading the SAS Log	16	(2)
1.9 Viewing Your Results in the Output Window	18	(2)
1.10 Creating HTML Output	20	(2)
1.11 SAS Data Libraries	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)
2.8 Selected Informats	44	(2)
2.9 Mixing Input Styles	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)
3.2 Using SAS Functions	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)
3.6 Subsetting Your Data	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
4.1 Using SAS Procedures	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
7.1 Macro Concepts	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)
10.5 Note: Lost Card	260	(2)
10.6 Note: Invalid Data	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
A Where to Go from Here	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)
F Coming to SAS from SQL	302	(7)
Index	309