Renaming All Variables in a SAS® Data Set Using the Information from PROC SQL's Dictionary Tables
Source category: Conference paper
Author collections: Prasad S. Ravi
THE COMMUNITY ARCHIVE
PROC SQL Papers and PresentationsPage 14
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 261–280
Toyota Automatically Combining the Data from a Variety of DBMSs with ODBC and PROC SQL
Source category: Conference paper
Author collections: Han Wu
Undocumented and Hard-to-find SQL Features
Source category: Data Warehousing and Database Management
Author collections: Kirk Paul Lafler
Undocumented and Hard-to-Find SQL Features
Source category: Conference paper
Author collections: Kirk Paul Lafler
Using SAS Views and SQL Views
Source category: Data Warehousing and Database Management
Author collections: Lynn G. Palmer
Using SQL to Summarize Data Down Rows and Across Columns
Source category: Coders’ Corner
Author collections: Kirk Paul Lafler
A Visual Introduction to SQL Joins
Source category: Conference paper
Author collections: Kirk P. Lafler
A Visual Introduction to SQL Joins
Source category: Coders’ Corner
Author collections: Kirk Paul Lafler
An Introduction to PROC SQL
Source category: Conference paper
The publisher's title link points to a different file from its numbered paper link; this entry uses the numbered link pending PDF identity review.
Author collections: Steven First
An Introduction to SAS ® PROC SQL
Source category: Conference paper
Author collections: Timothy J Harrington
Creating Efficient SQL — Four Steps to a Quick Query
Source category: Conference paper
Author collections: Paul D. Sherman
DATA Step vs. PROC SQL: What’s a Neophyte to Do?
Source category: Conference paper
Author collections: Craig Dickstein · Ray Pass
Improve Your Queries: Hints and Tips for Using SQL
Source category: Conference paper
Author collections: Marje Fecht
Taking Advantage of Missing Values in PROC SQL
Source category: Conference paper
Author collections: Ya Huang
Using PROC SQL for Creating a Group Variable on Census 2000 Tracts Based on Their Relationship with the Census 1990 Tracts
Source category: Coders’ Corner
Author collections: Xiao Chen
Using the Magical Keyword ‘INTO:’ in PROC SQL
Source category: Conference paper
Author collections: Thiru Satchi
Using Views with DB2, MS Access, and SQL Server
Source category: Data Warehousing and Database Management
Author collections: Lynn G. Palmer
Advanced SQL Processing
Source category: Hands-On Workshops
An Introduction to PROC SQL
Source category: Conference paper
Author collections: David Beam
Basic SQL Processing
Source category: Hands-On Workshops