SAS 9.1 SQL Procedure User's Guide - Softcover

SAS Institute, Inc; Sas Institute

Softcover

ISBN 10: 1590473345 ISBN 13: 9781590473344

Verlag: SAS Institute, 2004

Inhaltsangabe

Book by SAS Institute Inc Sas Institute

Über diesen Titel

Reseña del editor

Base SAS software supports Structured Query Language (SQL), the ANSI standard and widely used language that enables you to create, retrieve, and update database information. This title is your introductory, task-oriented resource for SQL as implemented through the SAS SQL procedure. With this title, you will learn the basics of using PROC SQL, including retrieving data from single and multiple tables, selecting specific data from tables, subsetting, ordering, and summarizing data, updating tables, combining tables to create new tables and useful reports, performing queries on database management system (DBMS) tables, using PROC SQL with the SAS macro facility, and debugging and optimizing PROC SQL code. Additionally, detailed examples show you how to use PROC SQL to solve real-world problems, such as computing a weighted average, expanding hierarchical data in a table, creating a summary report, updating a table with values from another table, and using PROC SQL tables in other SAS programs. This title is also available online. This title is intended for users with a working knowledge of SAS programming. No knowledge of SQL or relational databases is assumed.

Supports releases 9.1 and higher of SAS software.

Details zur Ausgabe

• Verlag: SAS Institute
• Erscheinungsdatum: 2004
• ISBN 10: 1590473345
• ISBN 13: 9781590473344
• Einband: Tapa blanda
• Sprache: Englisch
• Anzahl der Seiten: 176