THE COMMUNITY ARCHIVE

PROC SQL Papers and PresentationsPage 7

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.

125 papers · Showing 121–125

PharmaSUG · 2014Paper BB04PharmaSUG 2014

D is for Dynamic, putting Dynamic back into CDISC (A simple macro utilizing PROC SQL which auto-formats continuous variables for lab tables)

Steven Black

Source category: Beyond the Basics

Author collections: Steven Black

PharmaSUG · 2014Paper BB20PharmaSUG 2014

Efficient SQL for Pharma… and Other Industries

Chris Olinger

Source category: Beyond the Basics

PharmaSUG · 2014Paper CC16PharmaSUG 2014

Need for Speed in Large Datasets – The Trio of SAS® INDICES, PROC SQL and WHERE CLAUSE is the Answer

Kunal Agnihotri

Source category: Coders Corner

Author collections: Kunal Agnihotri

PharmaSUG · 2014Paper TT05PharmaSUG 2014

Principles of Writing Readable SQL

Kenneth W. Borowiak

Source category: Techniques & Tutorials: Foundations

Author collections: Kenneth W. Borowiak

PharmaSUG · 2014Paper BB10PharmaSUG 2014

Using the Power of SAS SQL

Jessica Wang

Source category: Beyond the Basics