Author : SAS Institute
Release : 2004
Genre : Database management
Kind :
Book Rating : 344/5 ( reviews)

GET EBOOK

SAS 9.1 SQL Procedure - read free eBook in online reader or directly download on the web page. Select files or add your book in reader. Download and read online ebook SAS 9.1 SQL Procedure write by SAS Institute. This book was released on 2004. SAS 9.1 SQL Procedure available in PDF, EPUB and Kindle. 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.