You are previewing The Little SAS Book for Enterprise Guide 4.2.
O'Reilly logo
The Little SAS Book for Enterprise Guide 4.2

Book Description

Helps you quickly become productive in the SAS Enterprise Guide point-and-click environment. A series of carefully designed tutorials help you master the basics of the tasks you'll want to do most frequently. This edition has been completely rewritten and updated with new features for SAS Enterprise Guide 4.2.

Table of Contents

  1. Copyright
  2. About SAS Enterprise Guide
  3. About This Book
  4. Acknowledgments
  5. Praise from the Experts
    1. TUTORIALS SECTION
    2. Tutorials A
  6. A. Getting Started with SAS Enterprise Guide
    1. Starting SAS Enterprise Guide
    2. SAS Enterprise Guide windows
    3. Basic elements of SAS Enterprise Guide
    4. Entering data
    5. Creating a frequency report
    6. Creating a scatter plot
    7. Adding a note to the project
    8. Saving the project
    9. Tutorials B
  7. B. Creating Reports
    1. Before beginning this tutorial
    2. Starting SAS Enterprise Guide
    3. Opening the Tours data set
    4. Creating a simple report
    5. Changing titles and footnotes
    6. Changing column labels and formatting values
    7. Defining your own formats
    8. Selecting a style for the report
    9. Changing the output format for the report
    10. Completing the tutorial
    11. Tutorial C
  8. C. Working with Data in the Query Builder
    1. Before beginning this tutorial
    2. Starting SAS Enterprise Guide
    3. Opening the Volcanoes SAS data table
    4. Opening the Query Builder
    5. Selecting columns
    6. Creating a new column
    7. Ordering and removing columns
    8. Filtering data
    9. Sorting the data rows
    10. Completing the tutorial
    11. Tutorial D
  9. D. Joining Two Data Tables Together
    1. Before beginning this tutorial
    2. Starting SAS Enterprise Guide
    3. Opening the two data files to be joined
    4. Joining tables
    5. Filtering the data
    6. Selecting which rows to keep
    7. Completing the tutorial
    8. REFERENCE SECTION
    9. Chapter 1
  10. 1. SAS Enterprise Guide Basics
    1. 1.1 SAS Enterprise Guide Windows
      1. Docked windows
      2. Workspace
      3. Menus and tools
      4. Restoring windows
    2. 1.2 Splitting the Resources Pane and Workspace
      1. Splitting the Resources pane
      2. Maximizing the workspace
      3. Splitting the workspace
    3. 1.3 Projects
      1. Project Tree and Process Flow
      2. Showing properties and opening items
      3. Renaming and deleting items
      4. Saving a project
    4. 1.4 Managing Process Flows
      1. Adding new process flows
      2. Moving and copying items
      3. Linking items
      4. Printing process flows
    5. 1.5 Running and Rerunning Tasks
      1. Opening a task
      2. Selecting the data table
      3. Running a task
      4. Rerunning a task
    6. 1.6 Creating and Exporting Task Templates
      1. Creating a task template
      2. Using a task template
      3. Exporting a task template
    7. 1.7 SAS Data Tables
      1. Terminology
      2. Data types and data groups
      3. Numeric versus character
      4. Column names
      5. Moving data between SAS Enterprise Guide and Base SAS
      6. Missing data
      7. Documentation stored in SAS data tables
    8. 1.8 Properties of Data Tables
      1. Opening the Properties window
      2. General page
      3. Columns page
    9. 1.9 Properties of Columns
      1. Setting the update mode
      2. Opening the Properties window
      3. General page
      4. Informats page
      5. Formats page
      6. Results
    10. 1.10 Selected Informats
    11. 1.11 Selected Standard Formats
    12. 1.12 Scheduling Projects to Run at Specific Times
      1. Opening the Schedule window
      2. Setting the run frequency
      3. Setting the date and time
      4. Other settings
      5. Running the project
      6. Viewing the results
    13. 1.13 Editing SAS Programs Generated by a Task
      1. Previewing code generated by a task
      2. Inserting code in a task
      3. Editing code generated by a task
    14. 1.14 Writing and Running Custom SAS Programs
      1. Writing a new SAS program
      2. Opening an existing SAS program
      3. Saving a program in a file
      4. Embedding a program in a project
      5. Running your program
    15. 1.15 Viewing Program and Project Logs
      1. Different types of logs
      2. Viewing a program log
      3. Viewing the Project Log
    16. 1.16 Using the Options Window
      1. Changing the way data are handled
      2. Changing the default titles and footnotes
      3. Changing the default result format and style
      4. Running code automatically
      5. Restoring the window layout
      6. Saving and resetting options
    17. Chapter 2
  11. 2. Bringing Data into a Project
    1. 2.1 Sources of Data
    2. 2.2 Locations for Data
      1. Server List window
      2. Libraries
      3. Files
      4. Other ways to bring data into a project
    3. 2.3 Assigning Libraries with the Assign Project Library Task
      1. Assign Project Library wizard
      2. Rerunning the Assign Project Library task
    4. 2.4 Creating New SAS Data Tables in a Data Grid
      1. Name and location
      2. Column properties
      3. Entering data
    5. 2.5 Editing SAS Data Tables in a Data Grid
      1. Copying a SAS data table
      2. Setting the update mode
      3. Editing data values
      4. Adding or removing a column
      5. Adding or removing rows
    6. 2.6 Inserting Computed Columns in a Data Grid
      1. Inserting the column
      2. Building the expression
      3. Computing columns in a Data Grid versus in a query
    7. 2.7 Importing Microsoft Excel Spreadsheets
      1. Input data
      2. Import Data wizard
      3. Results
    8. 2.8 Importing Delimited Raw Data
      1. Input data
      2. Opening a delimited data file
      3. Import Data wizard
      4. Results
    9. 2.9 Importing Fixed-Column Raw Data
      1. Input data
      2. Opening a fixed-column data file
      3. Import Data wizard
      4. Results
    10. 2.10 Exporting Data
      1. Exporting
      2. Exporting as a step in a project
    11. Chapter 3
  12. 3. Changing the Way Data Values Are Displayed
    1. 3.1 Applying Standard Formats in a Data Grid
      1. Setting the update mode
      2. Opening the Properties window
      3. Selecting formats
      4. Results
    2. 3.2 Applying Standard Formats in a Task
      1. Opening the Properties window
      2. Selecting formats
      3. Results
    3. 3.3 Defining Your Own Character Formats
      1. Create Format options
      2. Defining formats
      3. Using custom formats
    4. 3.4 Defining Your Own Numeric Formats
      1. Create Format options
      2. Defining formats
      3. Using custom formats
    5. 3.5 Applying User-Defined Formats
      1. Opening the Properties window
      2. Using custom formats
      3. Results
    6. Chapter 4
  13. 4. Modifying Data Using the Query Builder
    1. 4.1 Introducing the Query Builder
      1. Opening the Query Builder
      2. Giving the query a name
      3. Changing the output table name
      4. Results
    2. 4.2 Selecting Columns in a Query
      1. Selecting the data
      2. Setting properties for columns
      3. Results
    3. 4.3 Creating Columns Using Mathematical Operators
      1. Creating a new column
      2. Building the expression
      3. Results
    4. 4.4 Creating Columns Using Functions
      1. Creating a new column
      2. Choosing a function
      3. Defining arguments for functions
      4. Results
    5. 4.5 Selected Functions
    6. 4.6 Adding a Grand Total to a Data Table
      1. Summarizing the data
      2. Selecting summary groups
      3. Setting properties for the new column
      4. Adding back the original column
      5. Results
    7. 4.7 Adding Subtotals to a Data Table
      1. Summarizing the data
      2. Selecting groups
      3. Results
    8. 4.8 Creating Summary Data Tables in a Query
      1. Select the summary and group columns
      2. Setting properties for the new columns
      3. Results
    9. 4.9 Recoding Values in a Query
      1. Creating the recoded column
      2. Defining the replacements
      3. Results
    10. 4.10 Changing the Result Type of Queries
      1. Setting the default result type
      2. Setting the result type for a query
      3. Query report
    11. Chapter 5
  14. 5. Sorting and Filtering Data
    1. 5.1 Filtering Data in a Task
      1. Editing the data source
      2. Creating the filter
      3. Results
    2. 5.2 Using the Filter and Sort Task
      1. Selecting variables
      2. Specifying the filter
      3. Sorting the data
      4. Results
    3. 5.3 Sorting Using the Sort Task
      1. Assigning task roles
      2. Sorting options
      3. Results
    4. 5.4 Sorting Data in a Query
      1. Selecting the data
      2. Sorting the data
      3. Results
    5. 5.5 Filtering Data in a Query
      1. Building the filter
      2. Results
    6. 5.6 Creating Compound Filters in a Query
      1. Adding conditions to a filter
      2. Building the Filter
      3. Setting the logic
      4. Results
    7. 5.7 Creating a Filter with Advanced Expressions
      1. Opening the advanced filter window
      2. Building the advanced filter
      3. Results
    8. Chapter 6
  15. 6. Combining Data Tables
    1. 6.1 Methods for Combining Tables
      1. Appending tables
      2. Joining tables
      3. One-to-one match
      4. One-to-many match
      5. Many-to-many match
      6. Inner joins
      7. Left joins
      8. Right joins
      9. Full outer joins
    2. 6.2 Appending Tables
      1. Adding tables
      2. Running the task
      3. Results
    3. 6.3 Joining Tables
      1. Adding tables
      2. Running the query
      3. Results
    4. 6.4 Setting the Properties of a Join
      1. Reopening the Query window
      2. Selecting the type of join
      3. Running the query
      4. Results
    5. Chapter 7
  16. 7. Producing Simple List and Summary Reports
    1. 7.1 Creating Simple List Reports
      1. Assigning task roles
      2. Choosing options
      3. Results
    2. 7.2 Customizing Titles and Footnotes
      1. Titles page
      2. Results
      3. Changing default titles and footnotes
    3. 7.3 Adding Groups to List Reports
      1. Assigning a variable to the grouping task role
      2. Results
      3. Assigning a variable to the identifying label role
      4. Results
    4. 7.4 Adding Totals to List Reports
      1. Assigning a variable to the Total of task role
      2. Results
    5. 7.5 Creating Frequency Reports
      1. Assigning task roles
      2. Choosing statistics
      3. Results
    6. 7.6 Creating Crosstabulations
      1. Assigning task roles
      2. Arranging tables
      3. Choosing cell statistics
      4. Results
    7. 7.7 Creating Simple Summary Reports
      1. Assigning task roles
      2. Choosing statistics
      3. Results
    8. 7.8 Creating Summary Data Sets in a Task
      1. Results page
      2. Save As window
      3. Choosing options
      4. Results
    9. 7.9 Creating Grouped Reports with User-Defined Formats
      1. Opening the Properties window
      2. Using custom formats
      3. Results
    10. Chapter 8
  17. 8. Producing Complex Reports in Summary Tables
    1. 8.1 Creating Summary Tables with Frequencies
      1. Assigning task roles
      2. Arranging your table
      3. Results
    2. 8.2 Adding Statistics to Summary Tables
      1. Assigning task roles
      2. Arranging your table
      3. Choosing statistics
      4. Results
    3. 8.3 Changing Heading Properties in Summary Tables
      1. Heading Properties
      2. Box Area Properties
      3. Results
    4. 8.4 Changing Class Level Headings and Properties in Summary Tables
      1. Applying a format to a classification variable
      2. Class Level Properties
      3. Results
    5. 8.5 Changing Table Properties in Summary Tables
      1. General tab
      2. Format tab
      3. Font tab
      4. Results
    6. 8.6 Changing Data Value Properties in Summary Tables
      1. Format tab
      2. Font tab
      3. Results
    7. Chapter 9
  18. 9. Basic Statistical Analysis
    1. 9.1 Distribution Analysis
      1. Assigning task roles
      2. Distributions and Plots
      3. Choosing statistics
      4. Results
    2. 9.2 Summary Statistics
      1. Assigning task roles
      2. Choosing statistics
      3. Results
    3. 9.3 Table Analysis
      1. Assigning task roles
      2. Creating the table
      3. Choosing statistics
      4. Results
    4. 9.4 Correlations
      1. Assigning task roles
      2. Choosing statistics and plots
      3. Results
    5. 9.5 Linear Regression
      1. Assigning task roles
      2. Choosing statistics
      3. Selecting plots
      4. Results
    6. 9.6 Analysis of Variance
      1. Assigning task roles
      2. Choosing statistics
      3. Comparison of means
      4. Results
    7. Chapter 10
  19. 10. Producing Graphs
    1. 10.1 Bar Charts
      1. Choosing the type of bar chart
      2. Assigning task roles
      3. Customizing a bar chart
      4. Results
    2. 10.2 Pie Charts
      1. Choosing the type of pie chart
      2. Assigning task roles
      3. Other chart options
      4. Results
    3. 10.3 Simple Line Plots
      1. Choosing the type of line plot
      2. Assigning task roles
      3. Other plot options
      4. Results
    4. 10.4 Multiple Line Plots by Group
      1. Choosing the type of line plot
      2. Assigning task roles
      3. Other plot options
      4. Results
    5. 10.5 Scatter Plots
      1. Choosing the type of scatter plot
      2. Assigning task roles
      3. Other plot options
      4. Results
    6. 10.6 Controlling the Axes
      1. Changing the font, size, and style
      2. Setting the major tick marks
      3. Adding minor tick marks
      4. Results
    7. Chapter 11
  20. 11. Changing Result Styles and Formats
    1. 11.1 Changing the Result Format
      1. Setting the default result format
      2. Changing the result format of a task
      3. Results
    2. 11.2 Changing the Result Style
      1. Setting the default result style
      2. Changing the style for results of a task
      3. Changing the style after running a task
      4. Results
    3. 11.3 Customizing Styles Using the Style Manager
      1. Opening the Style Manager
      2. Editing an existing style
      3. Using the new style
    4. 11.4 Combining Results into a Single Document
      1. Selecting Items for the report
      2. Fitting items on a page
      3. Results
    5. 11.5 Adding Text, Images, and Headings to Reports
      1. Inserting text or images
      2. Arranging items in the report layout
      3. Adding headers and footers
      4. Results
    6. 11.6 Exporting Results to a File
      1. Exporting results to a file
      2. Exporting results as a step in the project
      3. Results
    7. Chapter 12
  21. 12. Adding Flexibility with Prompts and Conditions
    1. 12.1 Creating Prompts for Data Values
      1. Naming the prompt
      2. Setting the prompt type and values
    2. 12.2 Using Prompts in Query Filter Conditions
      1. Setting the Filter Condition
      2. Running the query
      3. Results
    3. 12.3 Creating Prompts for Variable Names
      1. Naming the prompt
      2. Setting the prompt type and values
    4. 12.4 Using Prompts in Tasks
      1. Assigning a prompt to a task role
      2. Using prompts in titles
      3. Running the task
      4. Results
    5. 12.5 Using Prompts in SAS Programs
      1. Adding prompts to SAS programs
      2. Setting the properties of the program
      3. Running the SAS Program
      4. Results
    6. 12.6 Creating Prompts for Text Values
      1. Naming the prompt
      2. Setting the prompt type and values
    7. 12.7 Using Prompts in Project Conditions
      1. Adding a condition
      2. Specifying an action
      3. Specifying an Else action
    8. 12.8 Running Projects with Conditions
      1. Condition indicators
      2. Running the project
    9. APPENDIX A
    10. Appendix A
  22. A. Data Used in This Book
    1. Tours Data
      1. Tours.sas7bdat
    2. Tour Dates Data
      1. Tours.sas7bdat
    3. Tour Bookings Data
      1. Bookings.xls
      2. Bookings.sas7bdat
    4. Volcanoes Data
      1. Volcanoes.sas7bdat
    5. Eruptions Data
      1. Eruptions.csv
      2. Eruptions.sas7bdat
    6. Latitude and Longitude Data
      1. Latlong.txt
      2. Latlong.sas7bdat
    7. Portland Flights Data
      1. Portland.sas7bdat
    8. Seattle Flights Data
      1. Seattle.sas7bdat
    9. Northwest Weather Data
      1. NWweather.sas7bdat
    10. On-Time Status of Flights Data
      1. On Time Status.sas7bdat
    11. Advertising Results Data
      1. AdResults.sas7bdat
    12. Ages Data
      1. Ages.sas7bdat