Powerful and ‘Sometimes’ Hard-to-Find PROC SQL Features
Source category: Hands On Workshop
Author collections: Kirk Paul Lafler
THE COMMUNITY ARCHIVE
PROC SQL Papers and PresentationsPage 4
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 61–80
PROC SQL for PROC SUMMARY Stalwarts
Source category: Know your SAS: Foundations
File inside source ZIP: Know_your_SAS_Foundations/SESUG2019_Paper-219_Final_PDF.pdf
Author collections: Christianna Williams
PROC SQL Showdown: joins versus subqueries
Source category: Beginner’s Techniques
The publisher's PDF link currently returns 404; the conference abstract remains available.
PROC SQL to the Rescue: When a Data Step Just Won’t Do Anymore
Source category: Advanced Programming
Author collections: John O’Leary
SD07 Building SQL Scripts Using Google Sheets R and R Shiny
Source category: Software Demonstrations
Sometimes SQL Really Is Better: A Beginner's Guide to SQL Coding for DATA Step Users
Source category: Conference presentation
The Power of PROC SQL’s SELECT DISTINCT INTO
Source category: Know your SAS: Advanced Techniques
File inside source ZIP: Know_your_SAS_Advanced_Techniques/SESUG2019_Paper-177_Final_PDF.pdf
Three Ways to Transform Your Code into PROC SQL
Source category: Coder’s Corner (10-minute presentation)
File inside source ZIP: Coders_Corner/SESUG2019_Paper-192_Final_PDF.pdf
Time Since Last Dose-Anatomy of a SQL Query
Source category: Applications Development
Author collections: Derek Morgan
Using PROC SQL to Generate Shift Tables More Efficiently
Source category: Conference presentation
Automation Methods: Using SAS to Write PROC SQL Joins for You
Source category: Coders Corner
File inside source ZIP: Coders_Corner/SESUG2018_Paper-274_Final_PDF.pdf
Author collections: Imelda Go
Confessions of a SAS PROC SQL Instructor
Source category: Beyond the Basics: Programming
Author collections: Charu Shankar
Cool SQL Tricks
Source category: Conference presentation
Emulating FIRST. and LAST. SAS® DATA Step Processing in SQL? Concepts and Review
Source category: Building Blocks
File inside source ZIP: Building_Blocks/SESUG2018_Paper-192_Final_PDF.pdf
Author collections: Thomas Billings
Fun with Address Matching: Use of the COMPGED Function and the SQL Procedure
Source category: Conference presentation
Fuzzy Joins with Proc SQL for Better Data Utilization
Source category: Coding Tips & Tricks
Author collections: Sunil Gupta
How to Avoid Possible Tricks When Using DATA STEP MERGE Instead of PROC SQL JOIN
Source category: e-Posters
PROC SQL - GET "INTO:" IT!
Source category: Coders Corner
File inside source ZIP: Coders_Corner/SESUG2018_Paper-267_Final_PDF.pdf
Proc SQL in Twenty Minutes
Source category: Building Blocks
File inside source ZIP: Building_Blocks/SESUG2018_Paper-266_Final_PDF.pdf
Author collections: John Cohen
The Joinless Join ~ The Impossible Dream Come True Using SAS® Enterprise Guide® and Base SAS® PROC SQL and DATA Step; Expand the Power of SAS® Enterprise Guide® and Base SAS® in New Ways
Source category: Hands-on Workshops
Author collections: Kent Phelps · Ronda Phelps