The Power of SAS SQL
Source category: SAS Global Forum proceedings
Author collections: Author not listed
THE COMMUNITY ARCHIVE
PROC SQL Papers and PresentationsPage 3
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 41–60
Under the Hood: The Mechanics of SQL Query Optimization Techniques
Source category: Know Your SAS: Advanced Techniques
File inside source ZIP: Know_Your_SAS__Advanced/SESUG2021_Paper_33_Final_PDF.pdf
Author collections: Kirk Paul Lafler
Under the Hood: The Mechanics of Various SQL Query Optimization Techniques
Source category: Advanced Programming
Author collections: Kirk Paul Lafler
Using PROC SQL to restructure data for common healthcare applications
Source category: Healthcare/Pharmaceuticals
File inside source ZIP: Healthcare_Pharmaceuticals/SESUG2021_Paper_68_Final_PDF.pdf
Author collections: Tamar Roomian
Building of SQL Queries Using Macro Patterns
Source category: Coding Tips & Tricks
Exploring the MSGLEVEL= SAS® System Option and PROC SQL _METHOD Option
Source category: Planning and Data Architecture
Author collections: Kirk Paul Lafler
Joinless Join: The Impossible Dream Come True Using SAS® Enterprise Guide®, PROC SQL, and DATA Step
Source category: Conference paper
Scaling Up for the SQL Payoff: When SQL is the Most Efficient Way to Code
Source category: Coding Tips & Tricks
Author collections: Matt Metherell
Sometimes SQL Really Is Better: A Beginner’s Guide to SQL Coding for DATA Step Users
Source category: Advanced Programming
Author collections: Brett Jepson
Step-by-Step SQL Procedure
Source category: Conference paper
Translating SQL to SAS® and Back: Performing Basic Functions Using DATA Steps vs. PROC SQL
Source category: Conference paper
Advanced PROC SQL Concepts and Programming Techniques Using SAS®
Source category: Conference Workshops
Listed in the conference abstract booklet; no matching paper appears in the publisher ZIP.
Author collections: Kirk Lafler
Anything You Can Do I Can Do Better: PROC FEDSQL VS PROC SQL
Source category: Conference presentation
Confessions of a SAS PROC SQL Instructor
Source category: Advanced Programming
Author collections: Charu Shankar
CONNECT TO vs. CONNECT USING for Security in SAS® PROC SQL
Source category: Planning and Administration
File inside source ZIP: Planning_and_Administration/SESUG2019_Paper-157_Final_PDF.pdf
Author collections: Thomas Billings
Cool SQL Tricks
Source category: Conference presentation
Creating Lists! Using the Powerful INTO Clause with PROC SQL to Store Information in Macro Lists
Source category: Conference presentation
DO loops :INTO efficient programming: DATA STEP do loop + PROC SQL in boilerplate programming
Source category: Know your SAS: Foundations
File inside source ZIP: Know_your_SAS_Foundations/SESUG2019_Paper-253_Final_PDF.pdf
DOSUBL Function + SQL View + Hash Object FedSQL + PROC DS2 Hash Package
Source category: Conference presentation
In the Style Of David Letterman’s “Top Ten” Lists, Our “Top Ten” PROC SQL Statements To Use in Your SAS Program
Source category: e-Posters
Author collections: Margie Merlino