The SQL Tuning Checklist: Making Slow Database Queries a Thing of the Past
Source category: Enterprise Guide and Coding
THE COMMUNITY ARCHIVE
PROC SQL Papers and PresentationsPage 8
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 141–160
Top 10 Most Powerful Functions for PROC SQL
Source category: Poster and Video Presentations
A Closer Look at PROC SQL's FEEDBACK Option
Source category: Coder’s Tips and Tricks
File inside source ZIP: CT-05.pdf
An In-Line View to a SQL
Source category: Coder’s Tips and Tricks
File inside source ZIP: CT-21.pdf
Demystifying PROC SQL Join Algorithms
Source category: Tutorials
Exploring DATA Step Merges and PROC SQL Joins
Source category: Techniques & Tutorials: Advanced
Author collections: Kirk Paul Lafler
Exploring DATA Step Merges and PROC SQL Joins
Source category: Programming: Foundations and Fundamentals
Get SAS®sy with PROC SQL
Source category: Techniques & Tutorials: Foundations
Author collections: Amie Bissonett
IF Cand IFN Functions: Alternatives to Simple DATA Step IF-THEN-ELSE, SELECT-END Code and PROC SQL CASE Statements
Source category: Coders’ Corner
Learning PROC SQL the DATA Step Way
Source category: Coder’s Tips and Tricks
File inside source ZIP: CT-20.pdf
Leveraging SQL Return Codes When Querying Relational Databases
Source category: Beyond the Basics
File inside source ZIP: BB-03.pdf
Queries, Joins, and WHERE Clauses, Oh My!! Demystifying PROC SQL
Source category: Hands-on Workshops
Queries, Joins, and WHERE Clauses. Oh My!! Demystifying PROC SQL
Source category: Hands-On Workshops
File inside source ZIP: HW-06.pdf
Author collections: Christianna Williams
Quick Data Definitions Using SQL, REPORT and PRINT Procedures
Source category: Coders’ Corner
Author collections: Bradford J. Danner
Ready To Become Really Productive Using PROC SQL?
Source category: Hands-On Workshops
Author collections: Sunil K. Gupta
The Power of PROC SQL
Source category: Industry Starters
Author collections: Amanda Reilly
Three Simple Steps to Recovering and Inserting Data Using Do Loops, Indexed Macro Variables, and PROC SQL Update Statements
Source category: Coders' Corner
A Many to Many Merge, Without SQL?
Source category: Tutorials
Author collections: David Franklin
Adding PROC SQL to your SAS toolbox for merging multiple tables without common variable names
Source category: Coders’ Corner
Can’t Decide Whether to Use a DATA Step or PROC SQL? You Can Have It Both Ways with the SQL Function!
Source category: Beyond the Basics
Author collections: Jeremy Poling