PROC SQL by Example : Using SQL Within SAS

Howard Schreier

ISBN 10: 1599942976 / ISBN 13: 9781599942971

Verlag: SAS Institute, 2008

Beschreibung

nach der Bestellung gedruckt Neuware - Printed after ordering - 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.

Bestandsnummer des Verkäufers 9781599942971

Bibliografische Details

• Titel: PROC SQL by Example : Using SQL Within SAS
• Verlag: SAS Institute
• Erscheinungsjahr: 2008
• Sprache: Englisch
• ISBN-10: 1599942976
• ISBN-13: 9781599942971
• Einband: Taschenbuch
• Zustand: Neu
• Abmessungen: 235B x 191 H x 17 T Millimeter Breite: 235 mm, Höhe: 191 mm, Tiefe: 17 mm
• Gewicht: 557 Gramm

Über diesen Titel

Inhaltsangabe

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.

Über die Autorin bzw. den Autor

Howard Schreier, an independent consultant and trainer, has been a SAS® user since 1981. He has presented numerous papers at various SAS user group meetings, and has served as section chair at several SAS conferences. He has contributed around 7,000 posts to the SAS-L mailing list over 20 years, and is a member of the SAS-L Hall of Fame. Howard received his BA in Economics from the University of Michigan in 1976 and his MPh in Economics from The George Washington University in 1983.