DOSEON: Fuzzy Matching DOSE Date Intervals ON Analysis Dates Across SAS (PROC SQL, SAS Macro, DATA Step, and PROC FCMP)
Source category: Data Standards Implementation (CDISC, SEND, ADaM, SDTM)
Author collections: Inka Leprince · Troy Hughes
THE COMMUNITY ARCHIVE
PROC SQL Papers and Presentations
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 1–20
Fuzzy Matching DOSE Date Intervals ON Analysis Dates Across SAS (DATA Step, PROC SQL, SAS Macro, and PROC FCMP)
Source category: Scripts, Macros & Automation
Author collections: Inka Leprince · Troy Martin Hughes
SQL – The Grammar behind A.I.
Source category: Hands-On Training
Author collections: Charu Shankar
SQL Everywhere! Reuse your PROC SQL Code in R and Python with DuckDB
Source category: Open Source & Emerging Technologies
Author collections: Matthew Slaughter · Isaiah Lankham · Kirk Lafler
Comparing SQL and Graph Database Query Methods for Answering Clinical Trial Questions with LLM-Powered Pipelines
Source category: Strategic Implementation & Innovation
Author collections: Jaime Yan
Fuzzy Matching with SAS PROC SQL
Source category: Data Collection, Management, and Manipulation (DCMM)
File inside source ZIP: 86-Mark-Jordan-supporting-document.pdf
Author collections: Mark Jordan
Going from PROC SQL to PROC FedSQL for CAS Processing – Common mistakes to avoid.
Source category: Real World Evidence and Big Data
Author collections: Vijayasarathy Govindarajan
Going from PROC SQL to PROC FedSQL for CAS Processing: Common mistakes to avoid
Source category: Beyond the Basics
Author collections: Vijayasarathy Govindarajan
Leveraging SQL and SAS for Analysis-Ready Datasets
Source category: Beyond the Basics
Author collections: Shavonne Standifer
Leveraging SQL and SAS for Analysis-Ready Datasets
Source category: Data Collection, Management, and Manipulation (DCMM)
File inside source ZIP: 93-Shavonne-Standifer-supporting-document.pdf
Author collections: Shavonne Standifer
PROC SQL Case Study
Source category: Hands on Workshops (HOW)
File inside source ZIP: 112-Carleigh Jo-Crabtree-supporting-document.pdf
Author collections: Carleigh Jo Crabtree
Sugar Rush: SQL Master Class for Pharma Professionals
Source category: Advanced Programming
Author collections: Charu Shankar
Sugar Rush: SQL Master Class for Pharma Professionals
Source category: Hands-On Workshops (HOWs)
Author collections: Charu Shankar
Under the Hood: The Mechanics of SQL Query Optimization Techniques
Source category: Beyond the Basics
Author collections: Kirk Paul Lafler
Visualizing SQL Join Types with Venn Diagrams
Source category: Data Collection, Management, and Manipulation (DCMM)
File inside source ZIP: 20-Kirk Paul-Lafler-supporting-document.pdf
Author collections: Kirk Paul Lafler
Confessions of a PROC SQL Instructor
Source category: Basics and Beyond
Author collections: Charu Shankar
Efficient Way to Create Adverse Event (AE) Summary Tables by System Organ Class (SOC) and Preferred Term (PT) using PROC SQL in SAS
Source category: Intermediate and Advanced SAS Skills (IASS)
List Processing using SQL Select Into to Replace Call Symputx Creating Indexed Arrays of Macro Variables
Source category: Basics and Beyond
Author collections: Ronald Fehd
Q&A with the macro maven: is sql our lingua franca?
Source category: Anything Data
Author collections: Ronald Fehd
Stacking Up: Horizontal or Vertical with PROC SQL or DATA Step
Source category: Anything Data
Author collections: Charu Shankar