PROC SQL by Example

PROC SQL by Example
Author :
Publisher : SAS Institute
Total Pages : 294
Release :
ISBN-10 : 9781599948836
ISBN-13 : 1599948834
Rating : 4/5 (834 Downloads)

Book Synopsis PROC SQL by Example by : Howard Schreier

Download or read book PROC SQL by Example written by Howard Schreier and published by SAS Institute. This book was released on 2014-11-07 with total page 294 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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. This book is part of the SAS Press program.


PROC SQL by Example Related Books

PROC SQL by Example
Language: en
Pages: 294
Authors: Howard Schreier
Categories: Computers
Type: BOOK - Published: 2014-11-07 - Publisher: SAS Institute

GET EBOOK

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 procedure
PROC SQL
Language: en
Pages: 525
Authors: Kirk Paul Lafler
Categories: Computers
Type: BOOK - Published: 2019-03-20 - Publisher: SAS Institute

GET EBOOK

PROC SQL: Beyond the Basics Using SAS®, Third Edition, is a step-by-step, example-driven guide that helps readers master the language of PROC SQL. Packed with
Learning SAS by Example
Language: en
Pages: 553
Authors: Ron Cody
Categories: Computers
Type: BOOK - Published: 2018-07-03 - Publisher: SAS Institute

GET EBOOK

Learn to program SAS by example! Learning SAS by Example, A Programmer’s Guide, Second Edition, teaches SAS programming from very basic concepts to more advan
SAS Certification Prep Guide
Language: en
Pages: 582
Authors: Sas Institute
Categories: Computers
Type: BOOK - Published: 2017-12-22 - Publisher: SAS Institute

GET EBOOK

Prepare for the SAS Base Programming for SAS 9 exam with the official guide by the SAS Global Certification Program. New and experienced SAS users who want to p
SAS Certified Professional Prep Guide
Language: en
Pages: 649
Authors: SAS Institute
Categories: Computers
Type: BOOK - Published: 2019-10-18 - Publisher: SAS Institute

GET EBOOK

The official guide by the SAS Global Certification Program, SAS Certified Professional Prep Guide: Advanced Programming Using SAS 9.4 prepares you to take the n