Efficiency Techniques: SQL vs. Retain Variables
Source category: Conference paper
THE COMMUNITY ARCHIVE
PROC SQL Papers and PresentationsPage 16
Explore querying, joins, aggregation and data preparation with PROC SQL. Papers offer different ways to reason about row counts, duplicate keys and performance when translating a data task into a query.
387 papers · Showing 301–320
Getting Started with SQL
Source category: Tutorials
Author collections: Kirk Paul Lafler
Performance Enhancements to PROC SQL in Version 7 of the SAS System
Source category: Conference paper
Relational Database Schemes and SAS Software SQL Solutions
Source category: Conference paper
Author collections: Sigurd W. Hermansen
SQL Query Window Classes: How to Incorporate the SQL Column Expression Builder Class In Custom SAS/AF Applications
Source category: Conference paper
Author collections: Christopher A. Roper
Use PROC SQL to Collapse Cells - It's Easy
Source category: Conference paper
Using PROC SQL to Calculate Age-Gender Adjusted Pharmacy Utilization Data
Source category: Coders’ Corner
Author collections: Nikki M. Carroll
What's All This Metadata Good For, Anyway? Using Metadata to Dynamically Generate SQL
Source category: Conference paper
Author collections: Jonathan Stokes
An Introduction to PROC SQL
Source category: Conference paper
Author collections: Rosalind K. Gusinow · J. Michael Miscisin
An Introduction to PROC SQL
Source category: Conference paper
Author collections: Rosalind K. Gusinow · J. Michael Miscisin
An Investigation of the Efficiency of SQL DML Operations Performed on an ORACLE DBMS using SAS/ACCESS Software
Source category: Conference paper
Author collections: Annie Guo
Intermediate PROC SQL
Source category: Conference paper
Querying the Data Warehouse with SQL SELECT Statement
Source category: Data Warehousing and Database Management
Author collections: Kirk Paul Lafler · Sunil Kumar Gupta · Charles Edwin Shipp
Querying the Data Warehouse with the SQL Procedure SELECT Statement
Source category: Conference paper
Author collections: Kirk Paul Lafler
Some Utility Applications Using the Dictionary Tables in PROC SQL
Source category: Coders’ Corner
Author collections: Jack F. Hamilton
SQL Query Window Classes: How to Incorporate the SQL Column Experession Builder Class in Custom SAS/AF Applications
Source category: Tutorials
Author collections: Christopher A. Roper
SQL Query Window Classes: How to Incorporate the SQL Where Expression Builder Class in Custom SAS/AF Applications
Source category: Tutorials
Author collections: Christopher A. Roper
SQL Step by Step: An Advanced T utorial for Business Users
Source category: Conference paper
Author collections: Judy Loren · Gregory S. Barnes Nelson
Ten Great Reasons to Learn SAS Software's SQL Procedure
Source category: Conference paper
Author collections: Kirk Paul Lafler
Using PROC SQL and the Outside Table/File with a Database
Source category: Operating Environments
Author collections: Lynn G. Palmer