Building a Simple SAS Macro to Generate SQL Instructions in Frequently Used DB2 Tables
Source category: Conference paper
Author collections: Monique Bryher
THE COMMUNITY ARCHIVE
PROC SQL Papers and PresentationsPage 17
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.
387 papers · Showing 321–340
Introduction to Using PROC SQL
Source category: Conference paper
The publisher TOC prints paper number 067-24, although this is SUGI 22; the number may be incorrect.
Overcoming Kainophobia: Replacing Complex Merges with PROC SQL
Source category: Conference paper
The publisher TOC prints paper number 198-24, although this is SUGI 22; the number may be incorrect.
Ten Good Reasons to Learn SAS Software's SQL Procedure
Source category: Conference paper
The publisher TOC prints paper number 035-24, although this is SUGI 22; the number may be incorrect.
Author collections: Sigurd Hermansen
Ten Great Reasons to Learn SAS Software’s SQL Procedure
Source category: Tutorials
Author collections: Kirk Paul Lafler
An SQL Tutorial - Some Random Tips
Source category: Conference paper
Author collections: Paul Kent
Building a Simple SAS Macro to Generate SQL Instructions in Frequently Used DB2 Tables
Source category: Applications Development
Author collections: Monique Bryher
Comprehensive Data Management with the SQL Query Window
Source category: Formal Online Demos
Author collections: Henrietta Cummings
Developing Applications with the SAS System Emphasis on the SQL Query Window
Source category: Applications Development
Author collections: Julianne Staub Perry · Henrietta Cummings
FRAME Your View of Data with the SQL Procedure
Source category: Conference paper
Author collections: Kirk Paul Lafler
Measuring Performance Between PROC SQL and the Merge Approach
Source category: Data Warehousing and Database Management
Author collections: Martin Haase
PROC SQL — A SAS Programmer’s Perspective
Source category: Tutorials
PROC SQL as an Alternative to Multiple SORT/MERGE Statements
Source category: Coders’ Corner
Author collections: Robert Bachler
SELECT ITEMS FROM PROC SQL WHERE ITEMS >BASICS;
Source category: Conference paper
Author collections: Alan Dickson · Ray Pass
SELECT ITEMS FROM PROC.SQL WHERE ITEMS >BASIC
Source category: Conference paper
Author collections: Alan Dickson · Ray Pass
A Technique for Using SQL Pass-Thru Facility with Very Large Datasets
Source category: Coders’ Corner
Frame Your View of Data with the SQL Procedure
Source category: Tutorials
Author collections: Kirk Paul Lafler
Guzzy SQL Merges with Laboratory Data Normal Ranges
Source category: Coders’ Corner
Author collections: Justina M. Flavin
Introduction to PROC SQL as a Data Summary Tool
Source category: Tutorials
SELECT ITEMS FROM PROC.SQL WHERE ITEMS >BASICS;
Source category: Conference paper
Author collections: Alan Dickson · Ray Pass