|
Product Description
In PROC SQL by Example: Using SQL within SAS, author Howard Schreier illustrates the use of PROC SQL in the context of the SAS DATA step and other SAS procedures (such as SORT, FREQ, MEANS, SUMMARY, APPEND, DATASETS, and TRANSPOSE) whose functionality overlaps and complements that of SQL.Using a side-by-side approach, this concise reference guide includes many extensively explained examples showing equivalent DATA step and SQL code, enabling SAS users to take advantage of existing SAS skills and knowledge while learning about SQL. Discussions cover the differences between SQL and the DATA step as well as situations where SQL and the DATA step are used together to benefit from the strengths of each.
Topics addressed include working with joins and merges; using subqueries; understanding set operators; using the Macro Facility with PROC SQL; maintaining tables; working with views; using PROC SQL as a report generator; and more.
This text is ideal for SAS programmers seeking to add PROC SQL to their SAS toolkits as well as SQL programmers striving to better integrate the SAS DATA step and SQL.
Customers Who Bought This Item Also Bought
- SAS Certified Professional Prep Guide: Advanced Programming Using SAS 9.4
- The Essential PROC SQL Handbook for SAS Users
- Cody's Data Cleaning Techniques Using SAS, Third Edition
- Learning SAS by Example: A Programmer's Guide, Second Edition: A Programmer's Guide, Second Edition
- The Little SAS Book: A Primer, Fifth Edition
- The Little SAS Enterprise Guide Book
- Learning SAS by Example: A Programmer's Guide
- Applied Statistics and the SAS Programming Language (5th Edition)
- Carpenter's Complete Guide to the SAS Macro Language, Third Edition
- SAS Macro Programming Made Easy, Third Edition
*If this is not the "PROC SQL by Example: Using SQL within SAS" product you were looking for, you can check the other results by clicking this link. Details were last updated on Nov 6, 2024 00:41 +08.