book

The Little SAS Book, 6th Edition

Name: The Little SAS Book, 6th Edition
ISBN: 9781642953435

by Lora D. Delwiche, Susan J. Slaughter

October 2019

Beginner

364 pages

9h 59m

English

SAS Institute

Read now

Unlock full access

Acknowledgments
Introducing SAS Software
About This Book
About These Authors
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 Method for Running SAS1.6 Reading the SAS Log1.7 Using SAS System Options
Chapter 2 Accessing Your Data
2.1 Methods for Getting Your Data into SAS2.2 SAS Data Libraries and Data Sets2.3 Listing the Contents of a SAS Data Set2.4 Reading Excel Files with the IMPORT Procedure2.5 Accessing Excel Files Using the XLSX LIBNAME Engine2.6 Reading Delimited Files with the IMPORT Procedure2.7 Telling SAS Where to Find Your Raw Data2.8 Reading Raw Data Separated by Spaces2.9 Reading Raw Data Arranged in Columns2.10 Reading Raw Data Not in Standard Format2.11 Selected Informats2.12 Mixing Input Styles2.13 Reading Messy Raw Data2.14 Reading Multiple Lines of Raw Data per Observation2.15 Reading Multiple Observations per Line of Raw Data2.16 Reading Part of a Raw Data File2.17 Controlling Input with Options in the INFILE Statement2.18 Reading Delimited Files with the DATA Step
Chapter 3 Working with Your Data
3.1 Using the DATA Step to Modify Data3.2 Creating and Modifying Variables3.3 Using SAS Functions3.4 Selected SAS Character Functions3.5 Selected SAS Numeric Functions3.6 Using IF-THEN and DO Statements3.7 Grouping Observations with IF-THEN/ELSE Statements3.8 Subsetting Your Data in a DATA Step3.9 Subsetting Your Data Using PROC SQL3.10 Writing Multiple Data Sets Using OUTPUT Statements3.11 Making Several Observations from One Using OUTPUT Statements3.12 Using Iterative DO, DO WHILE, and DO UNTIL Statements3.13 Working with SAS Dates3.14 Selected Date Informats, Functions, and Formats3.15 Using RETAIN and Sum Statements 3.16 Simplifying Programs with Arrays3.17 Using Shortcuts for Lists of Variable Names3.18 Using Variable Names with Special Characters
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 DataValues with Formats4.7 Selected Standard Formats4.8 Creating Your Own Formats with PROC FORMAT4.9 Writing a Report to a Text File4.10 Summarizing Your Data Using PROC MEANS4.11 Writing Summary Statistics to a SAS Data Set4.12 Producing One-Way Frequencies with PROC FREQ4.13 Producing Crosstabulations with PROC FREQ4.14 Grouping Data with User-Defined Formats4.15 Producing Tabular Reports with PROC TABULATE4.16 Adding Statistics to PROC TABULATE Output4.17 Enhancing the Appearance of PROC TABULATE Output4.18 Changing Headers in PROC TABULATE Output4.19 Producing Simple Output with PROC REPORT4.20 Using DEFINE Statements in PROC REPORT4.21 Creating Summary Reports with PROC REPORT4.22 Adding Summary Breaks to PROC REPORT Output4.23 Adding Statistics to PROC REPORT Output4.24 Adding Computed Variables to PROC REPORT Output
Chapter 5 Enhancing Your Output with ODS
5.1 Concepts of the Output Delivery System5.2 Creating HTML Output5.3 Creating RTF Output5.4 Creating PDF Output5.5 Creating Text Output5.6 Customizing Titles and Footnotes5.7 Customizing PROC PRINT with the STYLE= Option5.8 Customizing PROC REPORT with the STYLE= Option5.9 Customizing PROC TABULATE with the STYLE= Option5.10 Adding Trafficlighting to Your Output5.11 Selected Style Attributes5.12 Tracing and Selecting Procedure Output5.13 Creating SAS Data Sets from Procedure Output
Chapter 6 Modifying and Combining SAS Data Sets
6.1 Stacking Data Sets Using the SET Statement6.2 Interleaving Data Sets Using the SET Statement6.3 Combining Data Sets Using a One-to-One Match Merge6.4 Combining Data Sets Using a One-to-Many Match Merge6.5 Using PROC SQL to Join Data Sets6.6 Merging Summary Statistics with the Original Data6.7 Combining a Grand Total with the Original Data6.8 Adding Summary Statistics to Data Using PROC SQL6.9 Updating a Master Data Set with Transactions6.10 Using SAS Data Set Options6.11 Tracking and Selecting Observations with the IN= Option6.12 Selecting Observations with the WHERE= Option6.13 Changing Observations to Variables Using PROC TRANSPOSE6.14 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 Macros 7.5 Adding Parameters to Macros7.6 Writing Macros with Conditional Logic7.7 Using %DO Loops in Macros7.8 Writing Data-Driven Programs with CALL SYMPUTX7.9 Writing Data-Driven Programs with PROC SQL7.10 Debugging Macro Errors
Chapter 8 Visualizing Your Data
8.1 Concepts of ODS Graphics8.2 Creating Bar Charts with PROC SGPLOT8.3 Creating Histograms and Density Curves with PROC SGPLOT8.4 Creating Box Plots with PROC SGPLOT8.5 Creating Scatter Plots with PROC SGPLOT8.6 Creating Series Plots with PROC SGPLOT8.7 Creating Fitted Curves with PROC SGPLOT8.8 Controlling Axes and Reference Lines in PROC SGPLOT8.9 Controlling Legends and Insets in PROC SGPLOT8.10 Customizing Graph Attributes in PROC SGPLOT8.11 Creating Paneled Graphs with PROC SGPANEL8.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 Delimited Files with the EXPORT Procedure10.3 Writing Delimited Files Using ODS10.4 Writing Microsoft Excel Files with the EXPORT Procedure10.5 Writing Microsoft Excel Files Using ODS10.6 Writing Raw Data Files with the DATA Step
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 Saving Memory or Disk Space
Index

Content preview from The Little SAS Book, 6th Edition

CHAPTER 10

Exporting Your Data

10.1 Methods for Exporting Your Data

In our ever increasingly complex world, people often need to transfer data from one application to another. Fortunately, SAS gives you many options for doing this. The types of files that you can create and the methods available for creating those files depend on how you run SAS, what operating environment you are using, and whether you have SAS/ACCESS software.

Methods for exporting data to other applications fall into these general categories:

♦ creating delimited or text files that the other software can read

♦ creating files in formats like HTML or XML that the other software ...

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

Publisher Resources

ISBN: 9781642953435

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

The Little SAS Book, 6th Edition

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.