Demystifying PROC SQL Join Algorithms
Source category: Databases and Warehouses
Author collections: Kirk Paul Lafler
THE COMMUNITY ARCHIVE
PROC SQL Papers and PresentationsPage 11
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 201–220
Existential Moments in Database Programming: SAS® PROC SQL EXISTS and NOT EXISTS Quantifiers, and More
Source category: Coders' Corner
Author collections: Sigurd Hermansen
Exploring the Undocumented PROC SQL _METHOD Option
Source category: Coders' Corner
Author collections: Kirk P. Lafler
Exploring the Undocumented PROC SQL _METHOD Option
Source category: Coders’ Corner
Author collections: Kirk Paul Lafler
Getting SAS to Play Nice With Others: Connecting SAS to Microsoft SQL Server
Source category: Databases and Warehouses
Getting SAS® to Play Nice with Others: Connecting SAS® to a Microsoft SQL Server with an ODBC Connection
Source category: Data Integration
It's a Bird, It's a Plane, It's SQL Transpose!
Source category: Coders' Corner
Author collections: Ted Conway
Joining Data: DATA Step Merge or SQL?
Source category: Foundations and Fundamentals
Author collections: Faisal Dosani · Harry Droogendyk
Labor-Saving SQL Constructs
Source category: Coders' Corner
Author collections: Brian Fairfield-Carter · David Carr
New SQL Performance Optimizations to Enhance Your SAS® Client and Solution Access to the Database
Source category: SAS Presents
PROC SQL for DATA Step Die-Hards
Source category: Hands-on Workshops
Author collections: Christianna Williams
SAS and Oracle PL/SQL : Partners or Competitors?
Source category: Coders’ Corner
Author collections: Stanley E. Fogleman
Teaching a New Dog Old Tricks – Using the EXCEPT Operator in PROC SQL and Generation Data Sets to Produce a Comparison Report
Source category: Coders’ Corner
Author collections: Stanley E. Fogleman
Using the SAS® DATA Step and PROC SQL to Create Macro Arrays
Source category: Coders' Corner
Author collections: Stuart Long · Edward Heaton
A Hands-on Tour Inside the World of PROC SQL
Source category: Hands-On Workshops
Author collections: Kirk Paul Lafler
A Hands-On Tour inside the World of PROC SQL
Source category: Conference paper
An animated guide: The Amazing SQL Optimizer...
Source category: Coding solutions
Author collections: Russ Lavery
Calculating Statistics Using PROC MEANS versus PROC SQL
Source category: Conference paper
DATA Step vs. PROC SQL: What's a Neophyte to Do?
Source category: Conference paper
Exploring the World of PROC SQL Joins
Source category: Tutorials
Author collections: Kirk Paul Lafler