SAS 9.2 SQL Procedure User's Guide
โ Scribed by SAS Publishing
- Publisher
- SAS Publishing
- Year
- 2008
- Tongue
- English
- Leaves
- 185
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Synopsis
Describes 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.
๐ SIMILAR VOLUMES
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,
Explains how to design reports with PROC REPORT based on your output from the SQL Query Window. Covers basic query concepts, how to perform queries on single and multiple tables, how to use advanced SQL Query Window features, and how to customize the SQL Query Window environment.
Explains how to design reports with PROC REPORT based on your output from the SQL Query Window. Covers basic query concepts, how to perform queries on single and multiple tables, how to use advanced SQL Query Window features, and how to customize the SQL Query Window environment.
Complete with step-by-step examples, this guide will teach you basic query concepts, how to perform basic queries on single and multiple tables, how to use advanced SQL Query window features, and much more.