Sas 9.1 Sql Procedure User's Guide - Brossura

SAS Institute

Brossura

ISBN 10: 1590473345 ISBN 13: 9781590473344

Casa editrice: Sas Inst, 2004

Riassunto

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.

Su questo libro

Product Description

Book by SAS Institute Inc Sas Institute

Dettagli dell?edizione

• Editore: Sas Inst
• Data di pubblicazione: 2004
• ISBN 10: 1590473345
• ISBN 13: 9781590473344
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero di pagine: 176