The Battle of the Titans: DATA Step versus PROC SQL
Source category: Foundational SAS Skills (FSS)
THE COMMUNITY ARCHIVE
PROC SQL Papers and PresentationsPage 2
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 21–40
Time Since Last Dose: Anatomy of a SQL Query
Source category: Lectures
Author collections: Derek Morgan
Unanticipated Results: Uncovering Five Unexpected Outcomes in PROC SQL Joins
Source category: Intermediate and Advanced SAS Skills (IASS)
Author collections: Kiran Venna
Creating Applications with Mash-Ups: User Written Functions, Stored sql Queries and Interfaces
Source category: Application Development
Author collections: Stephen Prust
List Processing using SQL Select Into to Replace Call Symputx Creating Indexed Arrays of Macro Variables
Source category: Development and Support
Author collections: Ronald Fehd
List Processing using SQL Select Into to Replace Call Symputx Creating Indexed Arrays of Macro Variables
Source category: Advanced Programming & Techniques
Author collections: Ronald Fehd
Sas Sql 101
Source category: Hands-On Training
Author collections: Charu Shankar
The Battle of the Titans: DATA Step versus PROC SQL
Source category: Learning SAS I
The Battle of the Titans: DATA Step versus PROC SQL
Source category: Hands-on Workshops
Author collections: Kirk Paul Lafler · Richann Watson · Josh Horstman · Charu Shankar
Using SQL Dictionaries to Research the Global Symbol Table
Source category: Advanced Programming
Author collections: Ronald Fehd
What PROC SQL can’t handle while Data Step can?
Source category: e-Posters
Demystifying PROC SQL Join Algorithms
Source category: Learning SAS I
Author collections: Kirk Paul Lafler
Five Secrets of the SQL Goddess
Source category: Programming
Author collections: Charu Shankar
Integrating SQL Queries: From PROC SQL to SQLDF
Source category: Poster Presentations
Q&A with the macro maven: is sql our lingua franca?
Source category: Showcasing SAS
Author collections: Ronald Fehd
Time Since Last Dose: Anatomy of a SQL Query
Source category: Pharma and Healthcare
Author collections: Derek Morgan
Using SQL Dictionaries to Research the Global Symbol Table
Source category: Learning SAS I
Author collections: Ronald Fehd
Your Query’s No Good Here: PROC SQL Code That Doesn’t Work Outside of SAS
Source category: Advanced Techniques
A Sequel Better than the Original: Intuitive Ideas Beyond the Basics of Proc SQL
Source category: Coding Tips & Tricks
Author collections: Hector Leitch
Converting Remeasurement Data into Percentile Ranks Based on Baseline Data Using PROC SQL: Patient Experience Measures for CMS Value-Based Purchasing Program
Source category: Statistics and Data Analysis
File inside source ZIP: Statistics_and_Data_Analysis/SESUG2021_Paper_6_Final_PDF.pdf