THE COMMUNITY ARCHIVE

PROC SQL Papers and PresentationsPage 12

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 221–240

WUSS · 2007WUSS 2007

Hypothesis Testing: An SQL Analogy

Leroy Bracken; Paul D. Sherman

Source category: Analytics and Statistics

Author collections: Paul D. Sherman

PHUSE · 2007Paper CC06PHUSE EU Connect 2007

Improving maintenance and performance of SQL queries

Bas van Bakel; Rick Pagie

Source category: Coder's Corner

Author collections: Bas van Bakel

SAS Global Forum · 2007Paper 028-2007SAS Global Forum 2007

Journeyman's Tools: Data Review Macro FREQALL - Using PROC SQL List Processing with Dictionary.Columns to Eliminate Macro DO Loops

Ronald J. Fehd

Source category: Conference paper

Author collections: Ronald J. Fehd

SAS Global Forum · 2007Paper 071-2007SAS Global Forum 2007

PROC SQL - The Dark Side of SAS®?

Kirsty R. Lauderdale

Source category: Conference paper

PHUSE · 2007Paper TU05PHUSE EU Connect 2007

They SQL Here, They SQL There

Ian Amaranayake; David Shannon

Source category: Tutorials

Author collections: Ian Amaranayake · David Shannon

SUGI · 2006Paper 114-31SUGI 2006

A Hands-On Tour Inside the World of PROC SQL

Kirk P. Lafler

Source category: Conference paper

Author collections: Kirk P. Lafler

WUSS · 2006WUSS 2006

A Hands-On Tour Inside the World of SQL

Kirk Paul Lafler

Source category: Hands-On Workshops

Author collections: Kirk Paul Lafler

PHUSE · 2006Paper SS05PHUSE EU Connect 2006

An Introduction to PROC SQL

Anthony Cooper

Source category: SAS Starters

Author collections: Anthony Cooper

SUGI · 2006Paper 046-31SUGI 2006

DIGITS and DATES – The SQL Procedure Goes "Loopy"

Jack Hamilton

Source category: Conference paper

Author collections: Jack Hamilton

SUGI · 2006Paper 168-31SUGI 2006

Getting Your Random Sample in PROC SQL

Richard Severino

Source category: Conference paper

Author collections: Richard Severino

WUSS · 2006WUSS 2006

Getting Your Random Sample In PROC SQL

Richard Severino

Source category: Posters

Author collections: Richard Severino

SUGI · 2006Paper 171-31SUGI 2006

PROC SQL: A Powerful Tool to Improve Your Data Quality

Keh-Dong Shiang

Source category: Conference paper

Author collections: Keh-Dong Shiang

WUSS · 2006WUSS 2006

PROC SQL: A Powerful Tool to Improve Your Data Quality

Keh-Dong Shiang

Source category: Posters

Author collections: Keh-Dong Shiang

SUGI · 2006Paper 242-31SUGI 2006

SQL Set Operators: So Handy Venn You Need Them

Howard Schreier

Source category: Conference paper

Author collections: Howard Schreier

SUGI · 2006Paper 250-31SUGI 2006

The SQL Procedure – A Primer for SAS® Programmers

Jimmy A. DeFoor

Source category: Conference paper

SUGI · 2006Paper 044-31SUGI 2006

The SQL Procedure: When and How to Use It

Ying Feng

Source category: Conference paper

Author collections: Ying Feng

SUGI · 2006Paper 131-31SUGI 2006

Using Data Set Options in PROC SQL

Kenneth W. Borowiak

Source category: Conference paper

Author collections: Kenneth W. Borowiak

SUGI · 2006Paper 101-31SUGI 2006

Using External Data Dictionary Files When Building SQL Queries in Base SAS®

Mike D. Tangedal

Source category: Conference paper

Author collections: Mike D. Tangedal

WUSS · 2005WUSS 2005

A Hands-On Tour of the 5 Most Exciting Features Found in PROC SQL

Kirk Paul Lafler

Source category: Hands-On Workshops

Author collections: Kirk Paul Lafler

SUGI · 2005Paper 257-30SUGI 2005

An Introduction to SQL in SAS

Pete Lund - SC

Source category: Conference paper