search:
Search support.sas.com
KNOWLEDGE BASE
System Requirements
Install Center
Product Documentation
Papers
Samples & SAS Notes
Focus Areas
SUPPORT
License Assistance
Administrator Services
Downloads & Hot Fixes
LEARNING CENTER
Bookstore
Training
Certification
SAS Learning Edition
Higher Education Resources
SAS OnDemand For Academics
COMMUNITY
User Groups
Events
E-Newsletters
support.sas.com
KNOWLEDGE BASE
SUPPORT
LEARNING CENTER
COMMUNITY
Print
|
E-mail
|
Bookmark
Learning Center
Bookstore
Complete Catalog
New Books
SAS Press
SAS Documentation
SAS Learning Edition
JMP Software
SAS Certification Prep Guides
Coming Soon
Author Pages
Browse Resources
- New to SAS?
- For Instructors
- Companion Sites
- Help
Training
Certification
SAS Learning Edition
SAS Global Academic Program
SAS OnDemand
More Information
About the Book
About the Author
Reviews
Authorline Interview
Book Extras
Table of Contents (PDF)
Sample Chapter (PDF)
Example Code and Data
Samples and Tips, Blogs, and More
Keep in Touch
Contact the Author
Contact SAS Press
SAS Press»
Companion Site
PROC SQL: Beyond the Basics Using SAS
About the Book
PROC SQL: Beyond the Basics Using SAS
By
: Kirk Lafler
ISBN
: 978-1-59047-534-8
Pages
: 384
Order this book from our online bookstore
This is a book for intermediate and advanced SAS users who want clearly written plain-English explanations, examples, and techniques on the SQL procedure, all organized in a helpful and logical way. It is organized so users can get faster, easier, and better results with the SQL procedure without spending substantial amounts of time reading paragraph after paragraph of text. This book is the perfect companion for SAS and SQL users who want step-by-step instructions and example code to enhance their SQL prowess. It's the next best thing to having an expert by your side 24 hours a day, 7 days a week.
Topics addressed in this book include
Designing Database Tables
Working with Data in SQL
Formatting Output
Coding SQL Logic
Creating, Populating, and Deleting Tables
Modifying and Updating Tables and Indexes
Performing Complex Queries
Working with Views
Troubleshooting and Debugging Techniques
Tuning for Performance and Efficiency
About the Author
Kirk Paul Lafler
, consultant and founder of Software Intelligence Corporation, has been a SAS user since 1979. Kirk received his Bachelor of Science and Master of Science degrees from the University of Miami. As a SAS Certified Professional, Kirk provides IT consulting services and training to SAS users around the world. He is the author of several other books, including Power AOL and Power SAS, and more than 100 peer-reviewed technical articles. Kirk also writes the popular SAS tips column, "Kirk's Korner, " that appears regularly in several SAS Users Group newsletters. He is a frequent speaker at SAS Users Group meetings.
Samples and Tips, Blogs, and More
Sample and Tips
Concatenating SAS Data Sets with the APPEND Procedure
Creating New Data Sets with a Subset
Exploring the World of Indexes
Manipulating Data with PROC SQL
PROC SQL Summary Functions
Reading a SAS Data Set into Real Memory
Saving Labels and Formats in SAS Data Sets
Subsetting Observations More Efficiently
Using a Colon Modifier to Select Observations with Values Beginning with a Specific Character
Validating SQL Query Syntax with the VALIDATE Statement
Web-enabling Your SAS Output
Podcast
Kirk speaks with Shelly Goodin
at the 2008 SAS Global Forum
