ebook img

SAS 9.1 SQL Procedure User's Guide PDF

177 Pages·2004·1.135 MB·English
Save to my drive
Quick download
Download
Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.

Preview SAS 9.1 SQL Procedure User's Guide

Description:
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.
See more

The list of books you might like

Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.