Clean Your Data with PROC SQL
Source category: Data Warehousing and Database Management
Author collections: Ann Olmsted
THE COMMUNITY ARCHIVE
PROC SQL Papers and PresentationsPage 15
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 281–300
DATA Step vs. PROC SQL: What's a Neophyte to Do?
Source category: Conference paper
The publisher's title link points to a different file from its numbered paper link; this entry uses the numbered link pending PDF identity review.
Author collections: Craig Dickstein · Ray Pass
Merging Tables in DATA Step vs. PROC SQL: Convenience and Efficiency Issues
Source category: Conference paper
Author collections: Gajanan Bhat
PROC SQL - Is It a Required Tool of Good SAS Programming?
Source category: Conference paper
Author collections: Ian Whitlock
Tips for Using PROC SQL to Extract Information from Medical Claims Data Sets
Source category: Conference paper
Using the SAS/ACCESS Libname Technology to Get Improvements in Performance and Optimizations in SAS/SQL Queries
Source category: Conference paper
Advanced SQL Processing
Source category: Hands-On Workshops
Author collections: Dana Rafiee
Basic SQL Processing
Source category: Hands-On Workshops
Author collections: Dana Rafiee
Data Access Between a TSO Mainframe and a Unix-based Oracle Data Warehouse: The SAS Remote SQL Pass-through Method
Source category: Operating Environments
Author collections: Jay Gravink
Eenie Meenie Minie Moe – What’s the Fastest Proc from Go to Whoa? Comparing PROC SQL and PROC SUMMARY
Source category: Coders’ Corner
Author collections: Nikki M. Carroll
Introduction to PROC SQL
Source category: Conference paper
Author collections: Rosalind K. Gusinow
Notes from the Outer Limits of 4GL RDBMS/SQL: The SAS System to the Rescue
Source category: Conference paper
Author collections: Sigurd W. Hermansen
Removing Duplicates: PROC SQL Can Help You 'See'
Source category: Conference paper
SQL and Its Applications – Problem Solving Techniques for Everyone
Source category: Applications Development
Author collections: Kirk Paul Lafler
Using the Magical Keyword 'INTO:' in PROC SQL
Source category: Conference paper
Author collections: Thiru Satchi
A Process for Automatically Retrieving Database using ODBC and SAS/ACCESS SQL Procedure Pass-Through Facility
Source category: Conference paper
A Windowed Application for Efficient Access to Data Warehouse DB2 Data with PROC SQL Pass-Through Facility and Macros
Source category: Conference paper
An Introduction to PROC SQL
Source category: Conference paper
Author collections: David E. Beam
An Introduction to PROC SQL
Source category: Conference paper
Author collections: David E. Beam
An SQL List Macro to Retrieve Data from Large SAS/DB2 Databases
Source category: Conference paper
Author collections: Thiru Satchi