Tips for Pulling Data from Oracle® Using PROC SQL® Pass-Through
Source category: Coders Corner
File inside source ZIP: Coders_Corner/SESUG2018_Paper-261_Final_PDF.pdf
Author collections: John Cohen
THE COMMUNITY ARCHIVE
PROC SQL Papers and PresentationsPage 5
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 81–100
Tree Traversal: Why You Should Never Transpose in PROC SQL
Source category: Poster Presentation
Author collections: Jessica Whittaker-Dixon · Will Greenway
Using PROC SQL to Generate Shift Tables More Efficiently
Source category: Coders Corner
File inside source ZIP: Coders_Corner/SESUG2018_Paper-218_Final_PDF.pdf
Why choose between DATA Step or PROC SQL when you can have both?
Source category: Quick Tips
Author collections: Charu Shankar
Advanced Programming Techniques with PROC SQL
Source category: Conference presentation
Data movement issues: Explicit SQL Pass-Through can do the trick
Source category: Data Management Big Data
File inside source ZIP: Data_Management_Big_Data/SESUG2017_Paper-57_Final_PDF.pdf
Author collections: Kiran Venna
Identifying and Removing Subjects with Duplicates in Long Data Format: A Simple Approach Using PROC SORT and PROC SQL
Source category: Coders Corner
File inside source ZIP: Coders_Corner/SESUG2017_Paper-116_Final_PDF.pdf
Joining Data in SAS - SQL or MERGE?
Source category: Building Blocks
File inside source ZIP: Building_Blocks/SESUG2017_Paper-117_Final_PDF.pdf
Author collections: Harry Droogendyk
One-to-one, One-to-many, and Many-to-many Joins Using PROC SQL
Source category: Building Blocks
File inside source ZIP: Building_Blocks/SESUG2017_Paper-178_Final_PDF.pdf
Author collections: Charu Shankar
One-to-One, One-to-Many, and Many-to-Many Joins Using PROC SQL
Source category: Regular Session
Patching the Holes in SQL Systems with SAS®
Source category: Conference presentation
Quick Results with PROC SQL
Source category: Conference presentation
Something for Nothing? Adding Flag Variables Using Group Descriptive Statistics and PROC SQL
Source category: Conference presentation
Writing Efficient Queries in SAS Using PROC SQL with Teradata
Source category: Beyond the Basics
Author collections: Mina Chen
Architecting Data Management: Seven Principles Using SAS®, DataFlux®, and SQL
Source category: Conference presentation
Exploring HASH Tables vs. SORT/DATA Step vs. PROC SQL
Source category: Techniques and Tutorials
Author collections: Richann Watson · Lynn Mullins
Mastering Data Summarization with PROC SQL
Source category: Conference presentation
PROC SQL for SQL DieHards
Source category: Conference presentation
Proc SQL Self-Join for Aggregation
Source category: Regular Session
PROC SQL: To Create Macro Variables with Multiple Values and the Uses in Clinical Programming
Source category: Quick Tips
Author collections: Anish Kuriachen