SAS Programming for Enterprise Guide Users Book

Foreword     xi
Acknowledgments     xiii
Why Do I Need to Write Code?     1
Introduction     2
A Brief History of SAS     2
SAS: A Complete Programming Language     2
SAS Enterprise Guide: A Graphical User Interface for SAS     4
So How Does SAS Enterprise Guide Work?     5
Examples of Enhancing the Generated Code     8
Examples of Writing Your Own Code     11
Summary     12
Understanding Coding with SAS Enterprise Guide     13
Introduction     14
The Structure of a SAS Program     14
Writing Your Own Code: The Code Node     14
Using and Customizing the Code Window     20
The Code Node in Process Flow Diagrams     24
Understanding Generated Code     25
Complementing the Generated Code     29
Adding Code to the SAS Enterprise Guide Start-up File     30
Adding Code before or after a Task or Code     31
Inserting Code into a Task     32
Using Generated Code as a Template     35
Summary     36
Exercises     36
Getting Started     37
Introduction     38
Getting Ready to Face the World     38
We Know Where You Live     39
Formats and Functions     40
A Final Word on Options     41
Query-Free Filtering     41
Do It Once-Use It Often     46
Using Macro Variables     46
Using Macro Functions     55
ODS: The Output Delivery System     58
What Is ODS All About?     58
Making Your Output Go Where You Want     59
Summary     62
Exercises     63
Data Manipulation Part 1: Queries     65
Introduction     66
What Is SQL?     66
Basic Queries: What SAS Enterprise Guide Does Already     68
The Filter and Query Task     68
The Delete Data Sets and Formats Task     74
The Append Data Task     74
Indexes: Creation and Usage     75
Index Creation     76
Index Usage     78
Good Index, Bad Index     80
Updating and Validating Data     80
Deleting Rows     81
Inserting Rows     82
Updating     83
Integrity Checks     84
Advanced SQL Queries      88
Summary     88
Where to Look for More Information     89
Exercises     90
Data Manipulation Part 2: DATA Step and Functions     91
Introduction     91
DATA Step Basics     92
Creating Multiple Tables     94
When Position Matters     96
SAS Functions     103
Summary     104
Where to Look for More Information     104
Exercises     105
Seeing Data Differently     107
Introduction     108
Basic Formats: The Create Formats Task     108
Reviewing Existing Formats     112
Creating Picture Formats     113
Formatting Numbers     113
Formatting Dates and Times     116
Multilabel Formats     117
Using Formats as Look-up Tables     120
Creating Informats     122
Summary     123
Where to Look for More Information     123
Exercises     124
Enhancing Report Output     125
Introduction     126
More ODS     126
Improving Titles     134
Improving BY Lines     135
Page Numbers      137
Basic Formatting     138
Adding Hyperlinks     138
One-Stop Reporting     140
Hyperlinks Revisited     150
Trafficlighting     152
Documents, The ODS Waiting Room     161
Combining Output     161
Varying Output     163
Summary     167
Where to Look for More Information     167
Exercises     168
Graphical Output     169
Introduction     169
SAS Enterprise Guide Graphical Output     170
Enhancing SAS Enterprise Guide Graphs     171
More Linking     172
Exploding Pies     177
Detail Pies     181
Extra SAS Graphical Output     186
Summary     188
Where to Look for More Information     188
Exercises     189
Macros: Reusable Programming     191
Introduction     191
What Is a Macro?     192
Converting a Program to a Macro     192
Converting a Task to a Macro     196
Including Macros     197
The Biggest Exploding Pie     198
Summary     202
Where to Look for More Information     202
Exercises     202
Directory of Procedures Supported by SAS Enterprise Guide     203
Directory of Procedures     204
Task Cross-Reference     231
Category Cross-Reference     234
Selected Additional SAS Procedures     241
Data Used in This Book     247
Solutions to Exercises     263
Index     269