The Little SAS Book for Enterprise Guide 4.1

Description

Learning to use SAS Enterprise Guide has never been easier! With The Little SAS Book for Enterprise Guide 4.1, Susan Slaughter and Lora Delwiche help you quickly become familiar with the SAS Enterprise Guide point-and-click environment. A series of carefully designed tutorials help you master the basics of the tasks you will want to do most frequently. The reference section of the book expands on the tutorial topics, focusing on specific features. If you are new to SAS or new to SAS Enterprise Guide, this book will be an invaluable tool on your way to becoming an expert.

 

Table of Contents

About SAS Enterprise Guide    ix

About This Book    xi

Acknowledgments    xiii

Tutorials Section    1

 

Tutorial A   Getting Started with SAS Enterprise Guide    3

             Starting SAS Enterprise Guide   3

             SAS Enterprise Guide windows    4

             Basic elements of SAS Enterprise Guide    5

             Entering data    6

             Creating a list report    18

             Producing a frequency report    29

             Creating a scatter plot    32

             Adding a note to the project    35

             Saving the project    36

Tutorial B  Reading Data from Files    39

             Before beginning this tutorial   39

             Starting SAS Enterprise Guide    39

             Opening a SAS data set from your local computer    41

             Opening a SAS data set stored in a SAS library    44

             Opening a Microsoft Excel file    49

             Completing the tutorial    64

Tutorial C  Creating Reports    65

             Before beginning this tutorial    65

             Starting SAS Enterprise Guide    65

             Opening the Tours data set    66

             Creating a simple report    67

             Changing titles and footnotes   70

             Changing column labels and formatting values   75

             Defining your own formats    81

             Creating a grouped report    91

             Selecting a style for the report    94

             Completing the tutorial    99

Tutorial D  Working with Data in the Query Builder    101

             Before beginning this tutorial    101

             Starting SAS Enterprise Guide   101

             Opening the Volcanoes SAS data table   102

             Opening the Query Builder    104

             Selecting columns    106

             Creating a new column    108

             Ordering and removing columns    119

             Filtering data    121

             Sorting the data rows    129

             Completing the tutorial    133

Tutorial E    Joining Two Data Files Together    135

             Before beginning this tutorial   135

             Starting SAS Enterprise Guide    135

             Opening the two data files to be joined    136

             Joining tables    138

             Filtering the data    146

             Modifying the type of join    150

             Completing the tutorial    155

Reference Section    157

Chapter 1       SAS Enterprise Guide Basics    159

                1.1    SAS Enterprise Guide Windows    160

                1.2    Projects    162

                1.3    Managing Process Flows    164

                1.4    Maximizing and Splitting the Workspace    166

                1.5    Running and Rerunning Tasks    168

                1.6    SAS Data Tables    170

                1.7    Properties of Data Tables    172

                1.8    Properties of Columns    174

                1.9    Selected Informats    176

                1.10  Selected Standard Formats    178

                1.11  Scheduling Projects to Run at Specific Times    180

                1.12  Viewing and Editing SAS Code Generated by a Task    182

                1.13  Writing and Running Custom SAS Code    184

                1.14  Using SAS Enterprise Guide Help   186

                1.15  Using the Options Window   188

Chapter 2       Bringing Data into a Project    191

                2.1    Sources of Data    192

                2.2    Locations for Data    194

                2.3    Creating SAS Data Libraries with SAS Enterprise Guide Explorer    196

                2.4    Creating SAS Data Libraries with the Assign Library Task    198

                2.5    Opening SAS Data Tables    200

                2.6    Editing Values in SAS Data Tables    202

                2.7    Inserting Rows in SAS Data Tables    204

                2.8    Inserting Columns in SAS Data Tables    206

                2.9    Sorting Data Tables    208

                2.10  Creating New Data Tables    210

                2.11  Using Microsoft Excel Spreadsheets As Is    212

                2.12  Opening Microsoft Excel Spreadsheets as SAS Data Sets    214

                2.13  Reading Delimited Raw Data    216

                2.14  Reading Formatted Data    218

                2.15  Reading Fixed-Width Raw Data    220

                2.16  Exporting Data    222

Chapter 3       Changing the Way Data Values Are Displayed    225

                3.1    Applying Standard Formats in a Data Grid    226

                3.2    Applying Standard Formats in a Task    228

                3.3    Defining Your Own Character Formats    230

                3.4    Defining Your Own Numeric Formats    232

                3.5    Applying User-Defined Formats    234

Chapter 4       Modifying Data Using the Query Builder    237

                4.1    Selecting Columns in a Query    238

                4.2    Sorting Data in a Query    240

                4.3    Creating Columns Using Mathematical Operators in the
                         Expression Editor    242

                4.4    Creating Columns Using Functions in the Expression Editor    244

                4.5    Selected Functions    246

                4.6    Adding a Grand Total to a Data Table    248

                4.7    Adding Subtotals to a Data Table    250

                4.8    Creating Summary Data Tables in a Query    252

                4.9    Filtering Data    254

                4.10  Creating Compound Filters    256

                4.11  Filtering Based on Grouped Data    258

                4.12  Recoding Values in a Query    260

                4.13  Changing the Result Type of Queries    262

Chapter 5       Combining Data Tables    265

                5.1    Appending Tables    266

                5.2    Joining Tables    268

                5.3    Modifying a Join    270

Chapter 6       Producing Simple Lists and Reports    273

                6.1    Creating Simple Lists of Data    274

                6.2    Customizing Titles and Footnotes    276

                6.3    Adding Groups to Lists of Data    278

                6.4    Adding Totals to Lists of Data    280

                6.5    Creating Frequency Reports    282

                6.6    Creating Crosstabulations    284

                6.7    Creating Simple Summary Reports    286

                6.8    Creating Summary Data Sets in a Task    288

Chapter 7       Producing Complex Reports in Summary Tables    291

                7.1    Creating Summary Tables with Frequencies    292

                7.2    Adding Statistics to Summary Tables    294

                7.3    Changing Heading Properties in Summary Tables    296

                7.4    Changing Class Level Headings and Properties in
                         Summary Tables    298

                7.5    Changing Table Properties in Summary Tables    300

                7.6    Changing Data Value Properties in Summary Tables    302

Chapter 8       Basic Statistical Analysis    305

                8.1    Distribution Analysis    306

                8.2    Summary Statistics    308

                8.3    Table Analysis    310

                8.4    Correlations   312

                8.5    Linear Regression    314

                8.6    Analysis of Variance   316

Chapter 9       Producing Graphs    319

                9.1    Bar Charts    320

                9.2    Pie Charts    322

                9.3    Simple Line Plots    324

                9.4    Multiple Line Plots   326

                9.5    Scatter Plots    328

                9.6    Selecting the Graph Output Format   330

Chapter 10      Changing Output Styles and Types    333

                10.1   Changing the Output Format    334

                10.2   Changing the Output Style    336

                10.3   Customizing Output Styles Using the Style Manager    338

                10.4   Combining Results into a Single HTML Document   340

                10.5   Creating a Customized Report    342

Chapter 11      Adding Flexibility with Parameters    345

                11.1   Creating Parameters for Data Values    346

                11.2   Using Parameters in Filter Conditions    348

                11.3   Creating Parameters for Variable Names    350

                11.4   Using Parameters in Tasks   352

                11.5   Using Parameters in SAS Code    354

Appendix    357

 A   Data Used in This Book    359

Index    377