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.
SAS 9.1 SQL Query Window: User's Guide
โ Scribed by SAS Publishing
- Publisher
- SAS Publishing
- Year
- 2004
- Tongue
- English
- Leaves
- 108
- Category
- Library
No coin nor oath required. For personal study only.
โฆ Synopsis
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.
๐ SIMILAR VOLUMES
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.
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,
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 sys