The Little SAS Book

A Primer

Authors: Lora D. Delwiche, Susan J. Slaughter

Publisher: SAS Press

This popular book makes it easy to get started at SAS programming by covering over 100 topics every SAS programmer needs to know about. A strict two-pages-per-topic format ensures that you get just the right amount of information — enough to complete a task or solve a problem, but not so much that it could be confusing or overwhelming. Careful writing and editing and well-chosen examples make The Little SAS Book an easy book to read, even if you’ve never looked at SAS before.

UPDATED BY GLOBAL STATEMENTS BOOKS ON MARCH 31, 2014

Editions

5 Paperback/E-book (2012)

4 Paperback (2008)

3 Paperback (2003)

2 Revised Paperback (2002)

2 Paperback (1998)

UPDATED BY GLOBAL STATEMENTS BOOKS ON MARCH 31, 2014

SAS Versions

2nd edition: SAS 8

Revised 2nd edition: SAS 9.0

3rd edition: SAS 9.1

4th edition: SAS 9.2

5th edition: SAS 9.3

UPDATED BY GLOBAL STATEMENTS BOOKS ON MARCH 31, 2014

5

Year: 2012

ISBN (Paperback): 978-1-61290-343-9

ISBN (Epub): 978-1-61290-400-9

ISBN (Kindle): 978-1-61290-945-5

ISBN (PDF): 978-1-61290-013-4

Pages (paperback, PDF): 376

Publisher’s list price (paperback): 54.95

Contents

• Introducing SAS Software
• About This Book
• What’s New
• 1.1. The SAS Language
• 1.2. SAS Data Sets
• 1.3. DATA and PROC Steps
• 1.4. The DATA Step’s Built-in Loop
• 1.5. Choosing a Mode for Submitting SAS Programs
• 1.6. Windows and Commands in the SAS Windowing Environment
• 1.7. Submitting a Program in the SAS Windowing Environment
• 1.8. Reading the SAS Log
• 1.9. Viewing Your Results
• 1.10. SAS Data Libraries
• 1.11. Viewing Data Sets in the Viewtable Window
• 1.12. Viewing the Properties of Data Sets with SAS Explorer
• 1.13. Using SAS System Options
• 2.1. Methods for Getting Your Data into SAS
• 2.2. Entering Data with the Viewtable Window
• 2.3. Reading Files with the Import Wizard
• 2.4. Telling SAS Where to Find Your Raw Data
• 2.5. Reading Raw Data Separated by Spaces
• 2.6. Reading Raw Data Arranged in Columns
• 2.7. Reading Raw Data Not in Standard Format
• 2.8. Selected Informats
• 2.9. Mixing Input Styles
• 2.10. Reading Messy Raw Data
• 2.11. Reading Multiple Lines of Raw Data per Observation
• 2.12. Reading Multiple Observations per Line of Raw Data
• 2.13. Reading Part of a Raw Data File
• 2.14. Controlling Input with Options in the INFILE Statement
• 2.15. Reading Delimited Files with the DATA Step
• 2.16. Reading Delimited Files with the IMPORT Procedure
• 2.17. Reading Excel Files with the IMPORT Procedure
• 2.18. Temporary versus Permanent SAS Data Sets
• 2.19. Using Permanent SAS Data Sets with LIBNAME Statements
• 2.20. Using Permanent SAS Data Sets by Direct Referencing
• 2.21. Listing the Contents of a SAS Data Set
• 3.1. Creating and Redefining Variables
• 3.2. Using SAS Functions
• 3.3. Selected SAS Character Functions
• 3.4. Selected SAS Numeric Functions
• 3.5. Using IF-THEN Statements
• 3.6. Grouping Observations with IF-THEN/ELSE Statements
• 3.7. Subsetting Your Data
• 3.8. Working with SAS Dates
• 3.9. Selected Date Informats, Functions, and Formats
• 3.10. Using the RETAIN and Sum Statements
• 3.11. Simplifying Programs with Arrays
• 3.12. Using Shortcuts for Lists of Variable Names
• 4.1. Using SAS Procedures
• 4.2. Subsetting in Procedures with the WHERE Statement
• 4.3. Sorting Your Data with PROC SORT
• 4.4. Changing the Sort Order for Character Data
• 4.5. Printing Your Data with PROC PRINT
• 4.6. Changing the Appearance of Printed Values with Formats
• 4.7. Selected Standard Formats
• 4.8. Creating Your Own Formats Using PROC FORMAT
• 4.9. Writing Simple Custom Reports
• 4.10. Summarizing Your Data Using PROC MEANS
• 4.11. Writing Summary Statistics to a SAS Data Set
• 4.12. Counting Your Data with PROC FREQ
• 4.13. Producing Tabular Reports with PROC TABULATE
• 4.14. Adding Statistics to PROC TABULATE Output
• 4.15. Enhancing the Appearance of PROC TABULATE Output
• 4.16. Changing Headers in PROC TABULATE Output
• 4.17. Specifying Multiple Formats for Data Cells in PROC TABULATE Output
• 4.18. Producing Simple Output with PROC REPORT
• 4.19. Using DEFINE Statements in PROC REPORT
• 4.20. Creating Summary Reports with PROC REPORT
• 4.21. Adding Summary Breaks to PROC REPORT Output
• 4.22. Adding Statistics to PROC REPORT Output
• 4.23. Adding Computed Variables to PROC REPORT Output
• 4.24. Grouping Data in Procedures with User-Defined Formats
• 5.1. Concepts of the Output Delivery System
• 5.2. Tracing and Selecting Procedure Output
• 5.3. Creating SAS Data Sets from Procedure Output
• 5.4. Creating Text Output
• 5.5. Creating HTML Output
• 5.6. Creating RTF Output
• 5.7. Creating PDF Output
• 5.8. Customizing Titles and Footnotes
• 5.9. Customizing PROC PRINT Output with the STYLE= Option
• 5.10. Customizing PROC REPORT Output with the STYLE= Option
• 5.11. Customizing PROC TABULATE Output with the STYLE= Option
• 5.12. Adding Traffic-Lighting to Your Output
• 5.13. Selected Style Attributes
• 6.1. Modifying a Data Set Using the SET Statement
• 6.2. Stacking Data Sets Using the SET Statement
• 6.3. Interleaving Data Sets Using the SET Statement
• 6.4. Combining Data Sets Using a One-to-One Match Merge
• 6.5. Combining Data Sets Using a One-to-Many Match Merge
• 6.6. Merging Summary Statistics with the Original Data
• 6.7. Combining a Grand Total with the Original Data
• 6.8. Updating a Master Data Set with Transactions
• 6.9. Writing Multiple Data Sets Using the OUTPUT Statement
• 6.10. Making Several Observations from One Using the OUTPUT Statement
• 6.11. Using SAS Data Set Options
• 6.12. Tracking and Selecting Observations with the IN= Option
• 6.13. Selecting Observations with the WHERE= Option
• 6.14. Changing Observations to Variables Using PROC TRANSPOSE
• 6.15. Using SAS Automatic Variables
• 7.1. Macro Concepts
• 7.2. Substituting Text with Macro Variables
• 7.3. Concatenating Macro Variables with Other Text
• 7.4. Creating Modular Code with Macros
• 7.5. Adding Parameters to Macros
• 7.6. Writing Macros with Conditional Logic
• 7.7. Writing Data-Driven Programs with CALL SYMPUT
• 7.8. Debugging Macro Errors
• 8.1. Concepts of ODS Graphics
• 8.2. Creating Bar Charts
• 8.3. Creating Histograms and Density Curves
• 8.4. Creating Box Plots
• 8.5. Creating Scatter Plots
• 8.6. Creating Series Plots
• 8.7. Creating Fitted Curves
• 8.8. Controlling Axes and Reference Lines
• 8.9. Controlling Legends and Insets
• 8.10. Customizing Graph Attributes
• 8.11. Creating Paneled Graphs
• 8.12. Specifying Image Properties and Saving Graphics Output
• 9.1. Examining the Distribution of Data with PROC UNIVARIATE
• 9.2. Creating Statistical Graphics with PROC UNIVARIATE
• 9.3. Producing Statistics with PROC MEANS
• 9.4. Testing Means with PROC TTEST
• 9.5. Creating Statistical Graphics with PROC TTEST
• 9.6. Testing Categorical Data with PROC FREQ
• 9.7. Creating Statistical Graphics with PROC FREQ
• 9.8. Examining Correlations with PROC CORR
• 9.9. Creating Statistical Graphics with PROC CORR
• 9.10. Using PROC REG for Simple Regression Analysis
• 9.11. Creating Statistical Graphics with PROC REG
• 9.12. Using PROC ANOVA for One-Way Analysis of Variance
• 9.13. Reading the Output of PROC ANOVA
• 10.1. Methods for Exporting Your Data
• 10.2. Writing Files Using the Export Wizard
• 10.3. Writing Delimited Files with the EXPORT Procedure
• 10.4. Writing Microsoft Excel Files with the EXPORT Procedure
• 10.5. Writing Raw Data Files with the DATA Step
• 10.6. Writing Delimited and HTML Files using ODS
• 11.1. Writing SAS Programs That Work
• 11.2. Fixing Programs That Don’t Work
• 11.3. Searching for the Missing Semicolon
• 11.4. Note: INPUT Statement Reached Past the End of the Line
• 11.5. Note: Lost Card
• 11.6. Note: Invalid Data
• 11.7. Note: Missing Values Were Generated
• 11.8. Note: Numeric Values Have Been Converted to Character (or Vice Versa)
• 11.9. DATA Step Produces Wrong Results but No Error Message
• 11.10. Error: Invalid Option, Error: The Option Is Not Recognized, or Error: Statement Is Not Valid
• 11.11. Note: Variable Is Uninitialized or Error: Variable Not Found
• 11.12. SAS Truncates a Character Variable
• 11.13. SAS Stops in the Middle of a Program
• 11.14. SAS Runs Out of Memory or Disk Space
• Appendix. Coming to SAS from SQL
• Index

POSTED BY GLOBAL STATEMENTS BOOKS ON MARCH 31, 2014

4 Paperback

Year: 2008

ISBN: 978-1-59994-725-9

Pages: 374

Publisher’s list price: 49.95

Contents

• Introducing SAS Software
• About This Book
• What’s New
• 1.1. The SAS Language
• 1.2. SAS Data Sets
• 1.3. The Two Parts of a SAS Program
• 1.4. The DATA Step’s Built-in Loop
• 1.5. Choosing a Mode for Submitting SAS Programs
• 1.6. Windows and Commands in the SAS Windowing Environment
• 1.7. Submitting a Program in the SAS Windowing Environment
• 1.8. Reading the SAS Log
• 1.9. Viewing Your Results in the Output Window
• 1.10. Creating HTML Output
• 1.11. SAS Data Libraries
• 1.12. Viewing Data Sets in the Viewtable Window
• 1.13. Viewing the Properties of Data Sets with SAS Explorer
• 1.13. Using SAS System Options
• 2.1. Methods for Getting Your Data into SAS
• 2.2. Entering Data with the Viewtable Window
• 2.3. Reading Files with the Import Wizard
• 2.4. Telling SAS Where to Find Your Raw Data
• 2.5. Reading Raw Data Separated by Spaces
• 2.6. Reading Raw Data Arranged in Columns
• 2.7. Reading Raw Data Not in Standard Format
• 2.8. Selected Informats
• 2.9. Mixing Input Styles
• 2.10. Reading Messy Raw Data
• 2.11. Reading Multiple Lines of Raw Data per Observation
• 2.12. Reading Multiple Observations per Line of Raw Data
• 2.13. Reading Part of a Raw Data File
• 2.14. Controlling Input with Options in the INFILE Statement
• 2.15. Reading Delimited Files with the DATA Step
• 2.16. Reading Delimited Files with the IMPORT Procedure
• 2.17. Reading PC Files with the IMPORT Procedure
• 2.18. Reading PC Files with DDE
• 2.19. Temporary versus Permanent SAS Data Sets
• 2.20. Using Permanent SAS Data Sets with LIBNAME Statements
• 2.21. Using Permanent SAS Data Sets by Direct Referencing
• 2.22. Listing the Contents of a SAS Data Set
• 3.1. Creating and Redefining Variables
• 3.2. Using SAS Functions
• 3.3. Selected SAS Character Functions
• 3.4. Selected SAS Numeric Functions
• 3.5. Using IF-THEN Statements
• 3.6. Grouping Observations with IF-THEN/ELSE Statements
• 3.7. Subsetting Your Data
• 3.8. Working with SAS Dates
• 3.9. Selected Date Informats, Functions, and Formats
• 3.10. Using the RETAIN and Sum Statements
• 3.11. Simplifying Programs with Arrays
• 3.12. Using Shortcuts for Lists of Variable Names
• 4.1. Using SAS Procedures
• 4.2. Subsetting in Procedures with the WHERE Statement
• 4.3. Sorting Your Data with PROC SORT
• 4.4. Printing Your Data with PROC PRINT
• 4.5. Changing the Appearance of Printed Values with Formats
• 4.6. Selected Standard Formats
• 4.7. Creating Your Own Formats Using PROC FORMAT
• 4.8. Writing Simple Custom Reports
• 4.9. Summarizing Your Data Using PROC MEANS
• 4.10. Writing Summary Statistics to a SAS Data Set
• 4.11. Counting Your Data with PROC FREQ
• 4.12. Producing Tabular Reports with PROC TABULATE
• 4.13. Adding Statistics to PROC TABULATE Output
• 4.14. Enhancing the Appearance of PROC TABULATE Output
• 4.15. Changing Headers in PROC TABULATE Output
• 4.16. Specifying Multiple Formats for Data Cells in PROC TABULATE Output
• 4.17. Producing Simple Output with PROC REPORT
• 4.18. Using DEFINE Statements in PROC REPORT
• 4.19. Creating Summary Reports with PROC REPORT
• 4.20. Adding Summary Breaks to PROC REPORT Output
• 4.21. Adding Statistics to PROC REPORT Output
• 4.22. Adding Computed Variables to PROC REPORT Output
• 4.23. Grouping Data in Procedures with User-Defined Formats
• 5.1. Concepts of the Output Delivery System
• 5.2. Tracing and Selecting Procedure Output
• 5.3. Creating SAS Data Sets from Procedure Output
• 5.4. Using ODS Statements to Create HTML Output
• 5.5. Using ODS Statements to Create RTF Output
• 5.6. Using ODS Statements to Create PRINTER Output
• 5.7. Customizing Titles and Footnotes
• 5.8. Customizing PROC PRINT Output with the STYLE= Option
• 5.9. Customizing PROC REPORT Output with the STYLE= Option
• 5.10. Customizing PROC TABULATE Output with the STYLE= Option
• 5.11. Adding Traffic-Lighting to Your Output
• 5.12. Selected Style Attributes
• 6.1. Modifying a Data Set Using the SET Statement
• 6.2. Stacking Data Sets Using the SET Statement
• 6.3. Interleaving Data Sets Using the SET Statement
• 6.4. Combining Data Sets Using a One-to-One Match Merge
• 6.5. Combining Data Sets Using a One-to-Many Match Merge
• 6.6. Merging Summary Statistics with the Original Data
• 6.7. Combining a Grand Total with the Original Data
• 6.8. Updating a Master Data Set with Transactions
• 6.9. Writing Multiple Data Sets Using the OUTPUT Statement
• 6.10. Making Several Observations from One Using the OUTPUT Statement
• 6.11. Using SAS Data Set Options
• 6.12. Tracking and Selecting Observations with the IN= Option
• 6.13. Selecting Observations with the WHERE= Option
• 6.14. Changing Observations to Variables Using PROC TRANSPOSE
• 6.15. Using SAS Automatic Variables
• 7.1. Macro Concepts
• 7.2. Substituting Text with Macro Variables
• 7.3. Creating Modular Code with Macros
• 7.4. Adding Parameters to Macros
• 7.5. Writing Macros with Conditional Logic
• 7.6. Writing Data-Driven Programs with CALL SYMPUT
• 7.7. Debugging Macro Errors
• 8.1. Concepts of ODS Graphics
• 8.2. Creating Bar Charts with PROC SGPLOT
• 8.3. Creating Histograms and Box Plots with PROC SGPLOT
• 8.4. Creating Scatter Plots with PROC SGPLOT
• 8.5. Creating Series Plots with PROC SGPLOT
• 8.6. Creating Fitted Curves with PROC SGPLOT
• 8.7. Examining the Distribution of Data with PROC UNIVARIATE
• 8.8. Creating Statistical Graphics with PROC UNIVARIATE
• 8.9. Producing Statistics with PROC MEANS
• 8.10. Testing Categorical Data with PROC FREQ
• 8.11. Creating Statistical Graphics with PROC FREQ
• 8.12. Examining Correlations with PROC CORR
• 8.13. Creating Statistical Graphics with PROC CORR
• 8.14. Using PROC REG for Simple Regression Analysis
• 8.15. Creating Statistical Graphics with PROC REG
• 8.16. Using PROC ANOVA for One-Way Analysis of Variance
• 8.17. Reading the Output of PROC ANOVA
• 9.1. Methods for Exporting Your Data
• 9.2. Writing Files Using the Export Wizard
• 9.3. Writing Delimited Files with the EXPORT Procedure
• 9.4. Writing PC Files with the EXPORT Procedure
• 9.5. Writing Raw Data Files with the DATA Step
• 9.6. Writing Delimited and HTML Files using ODS
• 9.7. Sharing SAS Data Sets with Other Types of Computers
• 10.1. Writing SAS Programs That Work
• 10.2. Fixing Programs That Don’t Work
• 10.3. Searching for the Missing Semicolon
• 10.4. Note: INPUT Statement Reached Past the End of the Line
• 10.5. Note: Lost Card
• 10.6. Note: Invalid Data
• 10.7. Note: Missing Values Were Generated
• 10.8. Note: Numeric Values Have Been Converted to Character (or Vice Versa)
• 10.9. DATA Step Produces Wrong Results but No Error Message
• 10.10. The DATA Step Debugger
• 10.11. Error: Invalid Option, Error: The Option Is Not Recognized, or Error: Statement Is Not Valid
• 10.12. Note: Variable Is Uninitialized or Error: Variable Not Found
• 10.13. SAS Truncates a Character Variable
• 10.14. SAS Stops in the Middle of a Job
• 10.15. SAS Runs Out of Memory or Disk Space
• Appendix A. Where to Go from Here
• Appendix B. Coming to SAS from SPSS
• Appendix C. Coming to SAS from a Programming Language
• Appendix D. Coming to SAS from SQL
• Index

POSTED BY GLOBAL STATEMENTS BOOKS ON AUGUST 23, 2008

3 Paperback

Year: 2003

ISBN: 1-59047-333-7

Pages: 346

Publisher’s list price: 46.95

Contents

• 1.1. The SAS Language
• 1.2. SAS Data Sets
• 1.3. The Two Parts of a SAS Program
• 1.4. The DATA Step’s Built-in Loop
• 1.5. Choosing a Mode for Submitting SAS Programs
• 1.6. Windows and Commands in the SAS Windowing Environment
• 1.7. Submitting a Program in the SAS Windowing Environment
• 1.8. Reading the SAS Log
• 1.9. Viewing Your Results in the Output Window
• 1.10. Creating HTML Output
• 1.11. SAS Data Libraries
• 1.12. Viewing Data Sets with SAS Explorer
• 1.13. Using SAS System Options
• 2.1. Methods for Getting Your Data into SAS
• 2.2. Entering Data with the Viewtable Window
• 2.3. Reading Files with the Import Wizard
• 2.4. Telling SAS Where to Find Your Raw Data
• 2.5. Reading Raw Data Separated by Spaces
• 2.6. Reading Raw Data Arranged in Columns
• 2.7. Reading Raw Data Not in Standard Format
• 2.8. Selected Informats
• 2.9. Mixing Input Styles
• 2.10. Reading Messy Raw Data
• 2.11. Reading Multiple Lines of Raw Data per Observation
• 2.12. Reading Multiple Observations per Line of Raw Data
• 2.13. Reading Part of a Raw Data File
• 2.14. Controlling Input with Options in the INFILE Statement
• 2.15. Reading Delimited Files with the DATA Step
• 2.16. Reading Delimited Files with the IMPORT Procedure
• 2.17. Reading PC Files with the IMPORT Procedure
• 2.18. Reading PC Files with DDE
• 2.19. Temporary versus Permanent SAS Data Sets
• 2.20. Using Permanent SAS Data Sets with LIBNAME Statements
• 2.21. Using Permanent SAS Data Sets by Direct Referencing
• 2.22. Listing the Contents of a SAS Data Set
• 3.1. Creating and Redefining Variables
• 3.2. Using SAS Functions
• 3.3. Selected SAS Functions
• 3.4. Using IF-THEN Statements
• 3.5. Grouping Observations with IF-THEN/ELSE Statements
• 3.6. Subsetting Your Data
• 3.7. Working with SAS Dates
• 3.8. Selected Date Informats, Functions, and Formats
• 3.9. Using the RETAIN and Sum Statements
• 3.10. Simplifying Programs with Arrays
• 3.11. Using Shortcuts for Lists of Variable Names
• 4.1. Using SAS Procedures
• 4.2. Subsetting in Procedures with the WHERE Statement
• 4.3. Sorting Your Data with PROC SORT
• 4.4. Printing Your Data with PROC PRINT
• 4.5. Changing the Appearance of Printed Values with Formats
• 4.6. Selected Standard Formats
• 4.7. Creating Your Own Formats Using PROC FORMAT
• 4.8. Writing Simple Custom Reports
• 4.9. Summarizing Your Data Using PROC MEANS
• 4.10. Writing Summary Statistics to a SAS Data Set
• 4.11. Counting Your Data with PROC FREQ
• 4.12. Producing Tabular Reports with PROC TABULATE
• 4.13. Adding Statistics to PROC TABULATE Output
• 4.14. Enhancing the Appearance of PROC TABULATE Output
• 4.15. Changing Headers in PROC TABULATE Output
• 4.16. Specifying Multiple Formats for Data Cells in PROC TABULATE Output
• 4.17. Producing Simple Output with PROC REPORT
• 4.18. Using DEFINE Statements in PROC REPORT
• 4.19. Creating Summary Reports with PROC REPORT
• 4.20. Adding Summary Breaks to PROC REPORT Output
• 4.21. Adding Statistics to PROC REPORT Output
• 5.1. Concepts of the Output Delivery System
• 5.2. Tracing and Selecting Procedure Output
• 5.3. Creating SAS Data Sets from Procedure Output
• 5.4. Using ODS Statements to Create HTML Output
• 5.5. Using ODS Statements to Create RTF Output
• 5.6. Using ODS Statements to Create PRINTER Output
• 5.7. Customizing Titles and Footnotes
• 5.8. Customizing PROC PRINT Output with the STYLE= Option
• 5.9. Customizing PROC REPORT Output with the STYLE= Option
• 5.10. Customizing PROC TABULATE Output with the STYLE= Option
• 5.11. Adding Traffic-Lighting to Your Output
• 5.12. Selected Style Attributes
• 6.1. Modifying a Data Set Using the SET Statement
• 6.2. Stacking Data Sets Using the SET Statement
• 6.3. Interleaving Data Sets Using the SET Statement
• 6.4. Combining Data Sets Using a One-to-One Match Merge
• 6.5. Combining Data Sets Using a One-to-Many Match Merge
• 6.6. Merging Summary Statistics with the Original Data
• 6.7. Combining a Grand Total with the Original Data
• 6.8. Updating a Master Data Set with Transactions
• 6.9. Using SAS Data Set Options
• 6.10. Tracking and Selecting Observations with the IN= Option
• 6.11. Writing Multiple Data Sets Using the OUTPUT Statement
• 6.12. Making Several Observations from One Using the OUTPUT Statement
• 6.13. Changing Observations to Variables Using PROC TRANSPOSE
• 6.14. Using SAS Automatic Variables
• 7.1. Macro Concepts
• 7.2. Substituting Text with Macro Variables
• 7.3. Creating Modular Code with Macros
• 7.4. Adding Parameters to Macros
• 7.5. Writing Macros with Conditional Logic
• 7.6. Writing Data-Driven Programs with CALL SYMPUT
• 7.7. Debugging Macro Errors
• 8.1. Examining the Distribution of Data with PROC UNIVARIATE
• 8.2. Producing Statistics with PROC MEANS
• 8.3. Testing Categorical Data with PROC FREQ
• 8.4. Examining Correlations with PROC CORR
• 8.5. Using PROC REG for Simple Regression Analysis
• 8.6. Reading the Output of PROC REG
• 8.7. Using PROC ANOVA for One-Way Analysis of Variance
• 8.8. Reading the Output of PROC ANOVA
• 8.9. Graphical Interfaces for Statistical Analysis
• 9.1. Methods for Exporting Your Data
• 9.2. Writing Files Using the Export Wizard
• 9.3. Writing Delimited Files with the EXPORT Procedure
• 9.4. Writing PC Files with the EXPORT Procedure
• 9.5. Writing Raw Data Files with the DATA Step
• 9.6. Writing Delimited and HTML Files using ODS
• 9.7. Sharing SAS Data Sets with Other Types of Computers
• 10.1. Writing SAS Programs That Work
• 10.2. Fixing Programs That Don’t Work
• 10.3. Searching for the Missing Semicolon
• 10.4. Note: INPUT Statement Reached Past the End of the Line
• 10.5. Note: Lost Card
• 10.6. Note: Invalid Data
• 10.7. Note: Missing Values Were Generated
• 10.8. Note: Numeric Values Have Been Converted to Character (or Vice Versa)
• 10.9. DATA Step Produces Wrong Results but No Error Message
• 10.10. The DATA Step Debugger
• 10.11. Error: Invalid Option, Error: The Option Is Not Recognized, or Error: Statement Is Not Valid
• 10.12. Note: Variable Is Uninitialized or Error: Variable Not Found
• 10.13. SAS Truncates a Character Variable
• 10.14. SAS Stops in the Middle of a Job
• 10.15. SAS Runs Out of Memory or Disk Space
• Appendix A. Where to Go from Here
• Appendix B. Getting Help from SAS Technical Support
• Appendix C. An Overview of SAS Products
• Appendix D. Coming to SAS from SPSS
• Appendix E. Coming to SAS from a Programming Language
• Appendix F. Coming to SAS from SQL
• Index

From the back cover

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! Topics basic SAS concepts, such as the DATA step and the PROC step, and basic statistical procedures. You’ll find clear and concise explanations of

• inputting data
• modifying and combining data sets
• summarizing and presenting data
• debugging SAS programs

This book has been revised to include

• a new section on PROC REPORT
• more on PROC TABULATE
• ODS (Output Delivery System) concepts
• ODS HTML, RTF, PRINTER, and OUTPUT destinations
• the STYLE= option in PROC PRINT, PROC REPORT, and PROC TABULATE
• exporting data
• the colon modifier for informats

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!

POSTED BY GLOBAL STATEMENTS BOOKS ON SEPTEMBER 19, 2007

2 Revised Paperback

Year: 2002

ISBN: 1-59047-333-7

Pages: 303

Publisher’s list price: 30.95

Contents

• 1.1. The SAS Language
• 1.2. SAS Data Sets
• 1.3. The Two Parts of a SAS Program
• 1.4. The DATA Step’s Built-in Loop
• 1.5. Choosing a Mode for Submitting SAS Programs
• 1.6. Windows and Commands in the SAS Windowing Environment
• 1.7. Submitting a Program in the SAS Windowing Environment
• 1.8. Reading the SAS Log
• 1.9. Viewing Your Results in the Output Window
• 1.10. Creating HTML Output
• 1.11. Using SAS System Options
• 2.1. Methods for Getting Your Data into the SAS System
• 2.2. Telling SAS Where to Find Your Raw Data
• 2.3. Reading Raw Data Separated by Spaces
• 2.4. Reading Raw Data Arranged in Columns
• 2.5. Reading Raw Data Not in Standard Format
• 2.6. Selected Informats
• 2.7. Mixing Input Styles
• 2.8. Reading Messy Raw Data
• 2.9. Listing the Contents of a SAS Data Set
• 2.10. Temporary versus Permanent SAS Data Sets
• 2.11. Using LIBNAME Statements with Permanent SAS Data Sets
• 2.12. Entering Data with the Viewtable Window
• 2.13. Reading Multiple Lines of Raw Data per Observation
• 2.14. Reading Multiple Observations per Line of Raw Data
• 2.15. Reading Part of a Raw Data File
• 2.16. Controlling Input with Options in the INFILE Statement
• 2.17. Reading Delimited Files with the DATA Step
• 2.18. Reading Delimited Files with the IMPORT Procedure
• 2.19. Reading PC Files with DDE
• 2.20. Reading PC Files with the IMPORT Procedure
• 2.21. Writing Delimited Files with the EXPORT Procedure
• 2.22. Writing Raw Data Files with the DATA Step
• 3.1. Creating and Redefining Variables
• 3.2. Using SAS Functions
• 3.3. Selected SAS Functions
• 3.4. Using IF-THEN Statements
• 3.5. Grouping Observations with IF-THEN/ELSE Statements
• 3.6. Subsetting Your Data
• 3.7. Working with SAS Dates
• 3.8. Selected Date Informats, Functions, and Formats
• 3.9. Using the RETAIN and Sum Statements
• 3.10. Simplifying Programs with Arrays
• 3.11. Using Shortcuts for Lists of Variable Names
• 4.1. Using SAS Procedures
• 4.2. Subsetting in Procedures with the WHERE Statement
• 4.3. Sorting Your Data with PROC SORT
• 4.4. Printing Your Data with PROC PRINT
• 4.5. Changing the Appearance of Printed Values with Formats
• 4.6. Selected Standard Formats
• 4.7. Creating Your Own Formats Using PROC FORMAT
• 4.8. Writing Simple Custom Reports
• 4.9. Summarizing Your Data Using PROC MEANS
• 4.10. Writing Summary Statistics to a SAS Data Set
• 4.11. Counting Your Data with PROC FREQ
• 4.12. Producing Tabular Reports with PROC TABULATE
• 4.13. Adding Statistics to PROC TABULATE Output
• 4.14. Enhancing the Appearance of PROC TABULATE Output
• 4.15. Changing Headers in PROC TABULATE Output
• 4.16. Specifying Multiple Formats for Data Cells in PROC TABULATE Output
• 4.17. Visualizing Your Data with PROC PLOT
• 4.18. Creating SAS Data Sets from Procedure Output
• 5.1. Concepts of the Output Delivery System
• 5.2. Using ODS Statements to Create HTML Output
• 5.3. Using ODS Statements to Create RTF Output
• 5.4. Using ODS Statements to Create PRINTER Output
• 5.5. Customizing Titles and Footnotes
• 5.6. Customizing PROC PRINT Output with the STYLE= Option
• 5.7. Customizing PROC TABULATE Output with the STYLE= Option
• 5.8. Adding Traffic Lighting to Your Output
• 5.9. Selected Style Attributes
• 6.1. Modifying a Data Set Using the SET Statement
• 6.2. Stacking Data Sets Using the SET Statement
• 6.3. Interleaving Data Sets Using the SET Statement
• 6.4. Combining Data Sets Using a One-to-One Match Merge
• 6.5. Combining Data Sets Using a One-to-Many Match Merge
• 6.6. Merging Summary Statistics with the Original Data
• 6.7. Combining a Grand Total with the Original Data
• 6.8. Updating a Master Data Set with Transactions
• 6.9. Using SAS Data Set Options
• 6.10. Tracking and Selecting Observations with the IN= Option
• 6.11. Writing Multiple Data Sets Using the OUTPUT Statement
• 6.12. Making Several Observations from One Using the OUTPUT Statement
• 6.13. Changing Observations to Variables Using PROC TRANSPOSE
• 6.14. Using SAS Automatic Variables
• 7.1. Macro Concepts
• 7.2. Substituting Text with Macro Variables
• 7.3. Creating Modular Code with Macros
• 7.4. Adding Parameters to Macros
• 7.5. Writing Macros with Conditional Logic
• 7.6. Writing Data-Driven Programs with CALL SYMPUT
• 7.7. Debugging Macro Errors
• 8.1. Examining the Distribution of Data with PROC UNIVARIATE
• 8.2. Producing Statistics with PROC MEANS
• 8.3. Testing Categorical Data with PROC FREQ
• 8.4. Examining Correlations with PROC CORR
• 8.5. Using PROC REG for Simple Regression Analysis
• 8.6. Reading the Output of PROC REG
• 8.7. Using PROC ANOVA for One-Way Analysis of Variance
• 8.8. Reading the Output of PROC ANOVA
• 8.9. Introducing the Analyst Application
• 9.1. Writing SAS Programs That Work
• 9.2. Fixing Programs That Don’t Work
• 9.3. Searching for the Missing Semicolon
• 9.4. Note: INPUT Statement Reached Past the End of the Line
• 9.5. Note: Lost Card
• 9.6. Note: Invalid Data
• 9.7. Note: Missing Values Were Generated
• 9.8. Note: Numeric Values Have Been Converted to Character (or Vice Versa)
• 9.9. DATA Step Produces Wrong Results but No Error Message
• 9.10. The DATA Step Debugger
• 9.11. Error: Invalid Option, Error: The Option Is Not Recognized, or Error: Statement Is Not Valid
• 9.12. Note: Variable Is Uninitialized or Error: Variable Not Found
• 9.13. SAS Truncates a Character Variable
• 9.14. SAS Stops in the Middle of a Job
• 9.15. SAS Runs Out of Memory or Disk Space
• Appendix A. Where to Go from Here
• Appendix B. Getting Help from SAS Institute Technical Support
• Appendix C. An Overview of SAS Products
• Appendix D. Coming to SAS from SPSS
• Appendix E. Coming to SAS from a Programming Language
• Appendix F. Coming to SAS from SQL
• Index

From the back cover

Want to learn SAS software but don’t know where to start?

This friendly, easy-to-read guide gently introduces you to the most commonly used features of SAS software plus a whole lot more! Topics range from fundamental concepts of the SAS language to using basic statistical procedures and debugging programs.

The book has been revised to include

• ODS (Output Delivery System) destinations
• the STYLE= option in PROC PRINT and PROC TABULATE
• the colon modifier for informats
• more on PROC TABULATE.

You’ll find clear and concise explanations of

• inputting data
• modifying and combining data sets
• summarizing and presenting data
• understanding basic SAS concepts (such as DATA and PROC steps)
• making a smooth transition to the SAS language from other programming languages
• using the SAS macro language.

Each topic is presented in a self-contained two-page layout complete with examples and graphics. This formats enables new users to get up and running quickly, while the examples allow you to type in the program and see it work!

POSTED BY GLOBAL STATEMENTS BOOKS ON SEPTEMBER 19, 2007

2 Paperback

Year: 1998

ISBN: 1-58025-239-7

Pages: 237

Publisher’s list price: 27.95

POSTED BY GLOBAL STATEMENTS BOOKS ON SEPTEMBER 19, 2007