PROC SQL Beyond the Basics Using SAS 2nd Edition by Kirk Paul Lafler ISBN 1612907342 9781612907345

PROC SQL Beyond the Basics Using SAS 2nd Edition by Kirk Paul Lafler – Ebook PDF Instant Download/Delivery: 1612907342, 9781612907345
Full download PROC SQL Beyond the Basics Using SAS 2nd Edition after payment

Product details:

ISBN 10: 1612907342 
ISBN 13: 9781612907345
Author: Kirk Paul Lafler

Kirk Lafler’s PROC SQL: Beyond the Basics Using SAS, Second Edition, offers a step-by-step example-driven guide that helps readers master the language of PROC SQL. Packed with analysis and examples illustrating an assortment of PROC SQL options, statements, and clauses, this book can be approached in a number of ways. Users can read it cover-to-cover or selectively by chapter; they can use the extensive index to find content of interest or refer to the helpful “Summary” that precede each chapter to look for help on a specific topic.

The second edition explores new and powerful features in SAS 9.3, and includes such topics as adding data to a table with a SET clause; bulk loading data from Microsoft Excel; distinguishing between DATA step merges and PROC SQL joins; rules for designing indexes; cardinality and index selectivity; and demystifying join algorithms. It also features an expanded discussion of CASE expressions, and new sections on complex query applications, and grouping and performance. Delving into the workings of PROC SQL with greater analysis and discussion, PROC SQL: Beyond the Basic Using SAS, Second Edition, examines a broad range of topics and provides greater detail about this powerful database language

PROC SQL Beyond the Basics Using SAS 2nd Table of contents:

Part 1: Getting Started

• Chapter 1: An Overview of PROC SQL
  • What Is PROC SQL?
  • Why Use PROC SQL?
  • How Does PROC SQL Work?
  • Basic Syntax of PROC SQL
  • Common PROC SQL Statements
  • Accessing Data with PROC SQL
  • Outputting Results from PROC SQL
  • Error Handling in PROC SQL
  • Best Practices for PROC SQL
• Chapter 2: Essential SQL Concepts
  • Relational Database Model Basics
  • Tables, Columns, and Rows
  • Primary and Foreign Keys
  • Data Types in SQL
  • Null Values
  • Set Operations
  • SQL Standards and Variations

Part 2: Data Retrieval and Manipulation

• Chapter 3: Selecting and Filtering Data
  • The SELECT Statement
  • Selecting All Columns
  • Selecting Specific Columns
  • Using Column Aliases
  • The WHERE Clause for Filtering
  • Comparison Operators
  • Logical Operators (AND, OR, NOT)
  • IN and NOT IN Operators
  • BETWEEN and NOT BETWEEN Operators
  • LIKE and NOT LIKE Operators for Pattern Matching
  • IS NULL and IS NOT NULL Operators
• Chapter 4: Sorting and Grouping Data
  • The ORDER BY Clause for Sorting
  • Sorting by Multiple Columns
  • Ascending and Descending Order
  • The GROUP BY Clause for Summarization
  • Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
  • The HAVING Clause for Filtering Groups
  • Distinction Between WHERE and HAVING
• Chapter 5: Combining Data: Joins
  • Understanding Joins
  • INNER JOIN
  • LEFT JOIN (LEFT OUTER JOIN)
  • RIGHT JOIN (RIGHT OUTER JOIN)
  • FULL JOIN (FULL OUTER JOIN)
  • Self-Joins
  • Multiple Joins
  • Using Aliases in Joins
• Chapter 6: Combining Data: Set Operators
  • UNION and UNION ALL
  • INTERSECT
  • EXCEPT (MINUS)
  • Rules for Using Set Operators
  • Order of Operations with Set Operators
• Chapter 7: Creating and Modifying Tables
  • The CREATE TABLE Statement
  • Creating Tables from Existing Tables
  • The INSERT Statement for Adding Rows
  • The UPDATE Statement for Modifying Rows
  • The DELETE Statement for Deleting Rows
  • The ALTER TABLE Statement for Modifying Table Structure
  • The DROP TABLE Statement for Deleting Tables
  • TRUNCATE TABLE

Part 3: Advanced PROC SQL Techniques

• Chapter 8: Subqueries and Common Table Expressions (CTEs)
  • Introduction to Subqueries
  • Types of Subqueries (Scalar, Row, Table)
  • Subqueries in WHERE, FROM, and SELECT Clauses
  • Correlated Subqueries
  • Introduction to Common Table Expressions (WITH Clause)
  • Recursive CTEs
  • Advantages of Using CTEs
• Chapter 9: Advanced Functions and Expressions
  • Numeric Functions
  • Character Functions
  • Date and Time Functions
  • Conditional Logic with CASE Expressions
  • COALESCE Function
  • NULLIF Function
  • User-Defined Formats in PROC SQL
• Chapter 10: Macro Variables and PROC SQL
  • Creating Macro Variables from PROC SQL
  • Using Macro Variables in PROC SQL
  • Dynamic SQL Generation
  • PUT and INPUT Functions with Macro Variables
  • Debugging Macro Variables in PROC SQL
• Chapter 11: Pass-Through Facility and DBMS Access
  • Understanding the SQL Pass-Through Facility
  • Connecting to External Databases (ODBC, OLE DB)
  • Using the CONNECT, SELECT, and DISCONNECT Statements
  • Troubleshooting Pass-Through Connections
  • Performance Considerations for Pass-Through
• Chapter 12: Dictionary Tables and Views
  • Introduction to SAS Dictionary Tables
  • Querying Dictionary Tables (e.g., DICTIONARY.TABLES, DICTIONARY.COLUMNS)
  • Creating and Using PROC SQL Views
  • Advantages and Limitations of Views
  • Updating Data Through Views

Part 4: Performance, Efficiency, and Best Practices

• Chapter 13: Optimizing PROC SQL Performance
  • Understanding SAS Optimizers
  • Indexing Strategies
  • Using SAS Options for Performance Tuning (e.g., MEMSIZE, SORTSIZE)
  • Avoiding Common Performance Pitfalls
  • Monitoring Performance with the MSGLEVEL Option
  • Comparing PROC SQL to DATA Step Performance
• Chapter 14: Error Handling and Debugging
  • Common PROC SQL Errors
  • Using the OPTIONS ERRORABEND and ERRORCHECK
  • Debugging Techniques
  • Using the PROC SQL UNDO_POLICY Option
  • Interpreting SAS Log Messages
• Chapter 15: Advanced Topics and Tips
  • Using SAS Formats and Informats in PROC SQL
  • Applying Data Set Options in PROC SQL
  • Creating and Using Indexes with PROC SQL
  • Advanced BY-Group Processing
  • When to Use PROC SQL vs. DATA Step
  • Hybrid Approaches (PROC SQL and DATA Step Combined)
• Chapter 16: Best Practices for Writing Efficient and Maintainable PROC SQL Code
  • Code Readability and Documentation
  • Naming Conventions
  • Modular Programming
  • Testing and Validation
  • Version Control
  • Security Considerations

People also search for PROC SQL Beyond the Basics Using SAS 2nd:

proc sql beyond the basics using sas
    
proc sql beyond the basics using sas pdf
    
proc sql beyond the basics using sas third edition
    
using proc sql in sas
    
proc sql between sas

 

Tags: Kirk Paul Lafler, PROC, SQL