PROC SQL by Example: Using SQL within SAS

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.

Credits to original uploader

Disclaimer:
Contents of this page are indexed from the Internet. All actions are under your responsability. Email us to report illegal contents or external links and we'll remove them immediately.

Please check the description for download links if any or do a search to find alternative books.

Can't Download?
Please search mirrors if you can't find download links for "PROC SQL by Example: Using SQL within SAS" in "Description" and someone else may update the links. Check the comments when back to find any updates.

Search Mirrors
Maybe some mirror pages will be helpful, search this book at top of this page or click here to find more info.

1. Ebooks list page : 3555
2. Proc SQL: Beyond the Basics Using SAS
3. Proc Tabulate by Example
4. The.Power.of.PROC.FORMAT
5. The Power of PROC FORMAT
6. The Power of PROC FORMAT
7. [share_ebook] Bergmann, de Sabbata, Gillies, Pronin (eds.). Spin in gravity (Proc. Erice 1997, WS, 1998)
8. [share_ebook] Burko, Ori (eds.). Internal structure of black holes and spacetime singularities (Proc.Haifa, 1997, IoP, 1997)