Deployment of a Data Transfer Application Using PROC SQL and Nested Macros
Source category: Posters
Author collections: Keh-Dong Shiang
THE COMMUNITY ARCHIVE
PROC SQL Papers and PresentationsPage 13
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 241–260
Get Going with PROC SQL
Source category: Tutorials
Author collections: Richard Severino
Manipulating Data with PROC SQL
Source category: Conference paper
Author collections: Kirk P. Lafler
Merging versus Joining: Comparing the DATA Step with SQL
Source category: Conference paper
The SQL Optimizer Project: _Method and _Tree in SAS 9.1
Source category: Data Warehousing and Database Management
Author collections: Russell M. Lavery
The SQL Optimizer Project: _Method and _Tree in SAS9.1
Source category: Conference paper
Author collections: Russ Lavery
What Would I Do without PROC SQL and the Macro Language?
Source category: Conference paper
Author collections: Jeffrey M. Abolafia
Creating Efficient SQL – Four Steps to a Quick Query
Source category: Coders’ Corner
Author collections: Paul D. Sherman
Efficiency Techniques for Beginning PROC SQL Users
Source category: Conference paper
Author collections: Kirk Paul Lafler
Efficiency Techniques for Beginning PROC SQL Users
Source category: Hands-On Workshops
Author collections: Kirk Paul Lafler
Linking Unlinked Data: PROCs SQL and SORT Can Do It
Source category: Conference paper
Author collections: Merle E. Hamburger · Thomas Sukalac
Manipulating Data with PROC SQL
Source category: Data Warehousing and Database Management
Author collections: Kirk Paul Lafler
Subsetting SAS Data Set by Using PROC SQL Self-join with Compound Key
Source category: Conference paper
Author collections: Zizhong Fan
Top Ten Reasons to Use PROC SQL
Source category: Conference paper
Using Proc SQL and ODBC to Manage Data outside of SAS®
Source category: Data Warehousing and Database Management
Validating Data Via PROC SQL
Source category: Posters
Author collections: Keh-Dong Shiang
A Visual Introduction to SQL Joins
Source category: Tutorials
Author collections: Kirk Paul Lafler · Charles Edwin Shipp
Comparative Efficiency of SQL and Base Code When Reading from Database Tables and Existing Data Sets
Source category: Conference paper
Author collections: Steven Feder
Dynamically Building SQL Queries Using Metadata Tables and Macro Processing
Source category: Conference paper
Author collections: Michael J. Molter
PROC SQL vs. Merge – The Miller Lite Question of 2002 and Beyond
Source category: Conference paper
Author collections: Kevin J. Smith · Muhammad Z. Khan · Yadong Zhang