book

The Little SAS® Book: A Primer

Name: The Little SAS® Book: A Primer
ISBN: 9781612903439

by Lora D. Delwiche, Susan J. Slaughter

October 2012

Beginner

376 pages

10h 19m

English

SAS Institute

Read now

Unlock full access

Cover Page
Title Page
Copyright Page
Contents
Acknowledgments
Introducing SAS Software
About this Book
What's New
Chapter 1 - Getting Started Using SAS Software
1.1 - The SAS Language1.2 - SAS Data Sets1.3 - DATA and PROC Steps1.4 - The DATA Step's Built-in Loop1.5 - Choosing a Mode for Submitting SAS Programs1.6 - Windows and Commands in the SAS Windowing Environment1.7 - Submitting a Program in the SAS Windowing Environment1.8 - Reading the SAS Log1.9 - Viewing your Results1.10 - SAS Data Libraries1.11 - Viewing Data Sets in the Viewtable Window1.12 - Viewing the Properties of Data Sets with SAS Explorer1.13 - Using SAS System Options
Chapter 2 - Getting your Data into SAS
2.1 - Methods for Getting your Data into SAS2.2 - Entering Data with the Viewtable Window2.3 - Reading Files with the Import Wizard2.4 - Telling SAS where to Find your Raw Data2.5 - Reading Raw Data Separated by Spaces2.6 - Reading Raw Data Arranged in Columns2.7 - Reading Raw Data Not in Standard Format2.8 - Selected Informats2.9 - Mixing Input Styles2.10 - Reading Messy Raw Data2.11 - Reading Multiple Lines of Raw Data per Observation2.12 - Reading Multiple Observations per Line of Raw Data2.13 - Reading Part of a Raw Data File2.14 - Controlling Input with Options in the INFILE Statement2.15 - Reading Delimited Files with the DATA Step2.16 - Reading Delimited Files with the IMPORT Procedure2.17 - Reading Excel Files with the IMPORT Procedure2.18 - Temporary versus Permanent SAS Data Sets2.19 - Using Permanent SAS Data Sets with LIBNAME Statements2.20 - Using Permanent SAS Data Sets by Direct Referencing2.21 - Listing the Contents of a SAS Data Set

Chapter 3 - Working with your Data
3.1 - Creating and Redefining Variables3.2 - Using SAS Functions3.3 - Selected SAS Character Functions3.4 - Selected SAS Numeric Functions3.5 - Using IF-THEN Statements3.6 - Grouping Observations with IF-THEN/ELSE Statements3.7 - Subsetting your Data3.8 - Working with SAS Dates3.9 - Selected Date Informats, Functions, and Formats3.10 - Using the RETAIN and Sum Statements3.11 - Simplifying Programs with Arrays3.12 - Using Shortcuts for Lists of Variable Names
Chapter 4 - Sorting, Printing, and Summarizing your Data
4.1 - Using SAS Procedures4.2 - Subsetting in Procedures with the WHERE Statement4.3 - Sorting your Data with PROC SORT4.4 - Changing the Sort Order for Character Data4.5 - Printing your Data with PROC PRINT4.6 - Changing the Appearance of Printed Values with Formats4.7 - Selected Standard Formats4.8 - Creating your Own Formats Using PROC FORMAT4.9 - Writing Simple Custom Reports4.10 - Summarizing your Data Using PROC MEANS4.11 - Writing Summary Statistics to a SAS Data Set4.12 - Counting your Data with PROC FREQ4.13 - Producing Tabular Reports with PROC TABULATE4.14 - Adding Statistics to PROC TABULATE Output4.15 - Enhancing the Appearance of PROC TABULATE Output4.16 - Changing Headers in PROC TABULATE Output4.17 - Specifying Multiple Formats for Data Cells in PROC TABULATE Output4.18 - Producing Simple Output with PROC REPORT4.19 - Using DEFINE Statements in PROC REPORT4.20 - Creating Summary Reports with PROC REPORT4.21 - Adding Summary Breaks to PROC REPORT Output4.22 - Adding Statistics to PROC REPORT Output4.23 - Adding Computed Variables to PROC REPORT Output4.24 - Grouping Data in Procedures with User-Defined Formats
Chapter 5 - Enhancing your Output with ODS
5.1 - Concepts of the Output Delivery System5.2 - Tracing and Selecting Procedure Output5.3 - Creating SAS Data Sets from Procedure Output5.4 - Creating Text Output5.5 - Creating HTML Output5.6 - Creating RTF Output5.7 - Creating PDF Output5.8 - Customizing Titles and Footnotes5.9 - Customizing PROC PRINT with the STYLE= Option5.10 - Customizing PROC REPORT with the STYLE= Option5.11 - Customizing PROC TABULATE with the STYLE= Option5.12 - Adding Traffic-Lighting to your Output5.13 - Selected Style Attributes
Chapter 6 - Modifying and Combining SAS Data Sets
6.1 - Modifying a Data Set Using the SET Statement6.2 - Stacking Data Sets Using the SET Statement6.3 - Interleaving Data Sets Using the SET Statement6.4 - Combining Data Sets Using a One-to-One Match Merge6.5 - Combining Data Sets Using a One-to-Many Match Merge6.6 - Merging Summary Statistics with the Original Data6.7 - Combining a Grand Total with the Original Data6.8 - Updating a Master Data Set with Transactions6.9 - Writing Multiple Data Sets Using the OUTPUT Statement6.10 - Making Several Observations from One Using the OUTPUT Statement6.11 - Using SAS Data Set Options6.12 - Tracking and Selecting Observations with the IN= Option6.13 - Selecting Observations with the WHERE= Option6.14 - Changing Observations to Variables Using PROC TRANSPOSE6.15 - Using SAS Automatic Variables
Chapter 7 - Writing Flexible Code with the SAS Macro Facility
7.1 - Macro Concepts7.2 - Substituting Text with Macro Variables7.3 - Concatenating Macro Variables with Other Text7.4 - Creating Modular Code with Macros7.5 - Adding Parameters to Macros7.6 - Writing Macros with Conditional Logic7.7 - Writing Data-Driven Programs with CALL SYMPUT7.8 - Debugging Macro Errors
Chapter 8 - Visualizing your Data
8.1 - Concepts of ODS Graphics8.2 - Creating Bar Charts8.3 - Creating Histograms and Density Curves8.4 - Creating Box Plots8.5 - Creating Scatter Plots8.6 - Creating Series Plots8.7 - Creating Fitted Curves8.8 - Controlling Axes and Reference Lines8.9 - Controlling Legends and Insets8.10 - Customizing Graph Attributes8.11 - Creating Paneled Graphs8.12 - Specifying Image Properties and Saving Graphics Output
Chapter 9 - Using Basic Statistical Procedures
9.1 - Examining the Distribution of Data with PROC UNIVARIATE9.2 - Creating Statistical Graphics with PROC UNIVARIATE9.3 - Producing Statistics with PROC MEANS9.4 - Testing Means with PROC TTEST9.5 - Creating Statistical Graphics with PROC TTEST9.6 - Testing Categorical Data with PROC FREQ9.7 - Creating Statistical Graphics with PROC FREQ9.8 - Examining Correlations with PROC CORR9.9 - Creating Statistical Graphics with PROC CORR9.10 - Using PROC REG for Simple Regression Analysis9.11 - Creating Statistical Graphics with PROC REG9.12 - Using PROC ANOVA for One-Way Analysis of Variance9.13 - Reading the Output of PROC ANOVA
Chapter 10 - Exporting your Data
10.1 - Methods for Exporting your Data10.2 - Writing Files Using the Export Wizard10.3 - Writing Delimited Files with the EXPORT Procedure10.4 - Writing Microsoft Excel Files with the EXPORT Procedure10.5 - Writing Raw Data Files with the DATA Step10.6 - Writing Delimited and HTML Files Using ODS
Chapter 11 - Debugging your SAS Programs
11.1 - Writing SAS Programs that Work11.2 - Fixing Programs That Don't Work11.3 - Searching for the Missing Semicolon11.4 - Note: INPUT Statement Reached Past the End of a Line11.5 - Note: Lost Card11.6 - Note: Invalid Data11.7 - Note: Missing Values were Generated11.8 - Note: Numeric Values have Been Converted to Character (or Vice Versa)11.9 - DATA Step Produces Wrong Results but No Error Message11.10 - Error: Invalid Option, Error: The Option is Not Recognized, or Error: Statement is Not Valid11.11 - Note: Variable Is Uninitialized or Error: Variable Not Found11.12 - SAS Truncates a Character Variable11.13 - SAS Stops in the Middle of a Program11.14 - SAS Runs Out of Memory or Disk Space
Appendix Coming to SAS from SQL
Index
Accelerate Your SAS Knowledge with SAS Books

Content preview from The Little SAS® Book: A Primer

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

The Little SAS® Book: A Primer, Third Edition

Publisher Resources

ISBN: 9781612903439

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

The Little SAS® Book: A Primer

by Lora D. Delwiche, Susan J. Slaughter

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.