Combining PROC SQL Summary Functions with Logical Expressions
Source category: Health Outcomes and Healthcare Research Methodologies
Author collections: Glenn Wright
THE COMMUNITY ARCHIVE
PROC SQL Papers and PresentationsPage 9
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 161–180
Conditional Processing Using the Case Expression in PROC SQL
Source category: Coders’ Corner
Author collections: Kirk Paul Lafler
Explicit SQL Pass-Through: Is It Still Useful?
Source category: Coders' Corner
Exploring DATA Step Merges and PROC SQL Joins
Source category: Applications Development
Author collections: Kirk Paul Lafler
Loading Metadata to the IRS Compliance Data Warehouse (CDW) Website: From Spreadsheet to Database Using SAS® Macros and PROC SQL
Source category: Beyond the Basics
File inside source ZIP: BeyondBasics.zip / BB02.Rappaport.pdf
The publisher distributes this paper in a category ZIP inside the proceedings ZIP.
Powerful and “Sometimes” Hard-to-find PROC SQL® Features
Source category: Hands-On Workshops
Author collections: Kirk Paul Lafler
Powerful and Sometimes Hard-to-find PROC SQL Features
Source category: Tutorials
Author collections: Kirk Paul Lafler
Quick intro to SQL
Source category: Potpourri
The publisher lists this presentation without a PDF.
Quick Results with PROC SQL
Source category: Hands-On Workshops
Author collections: Kirk Paul Lafler
Ready to Become Really Productive Using PROC SQL?
Source category: Hands-on Workshops
Author collections: Sunil Gupta
Ready To Become Really Productive Using PROC SQL?
Source category: Hands-on Workshops
File inside source ZIP: HOW.zip / HW06.Gupta.pdf
The publisher distributes this paper in a category ZIP inside the proceedings ZIP.
Author collections: Sunil K. Gupta
Ready To Become Really Productive Using PROC SQL?
Source category: Hands-On Workshops
Author collections: Sunil Kumar Gupta
Teradata for the SAS® Programmer: Ordered Analytical Functions, Hash Objects, ANSI SQL: 2003
Source category: Applications Development
Author collections: Rick Andrews
The Many Uses of SQL Subqueries
Source category: Data Capture, validation, Manipulation and Integration
Author collections: Tasha Chapman
To Hash or Not To Hash! That Is the Question!! When it Comes to SQL!!!
Source category: Coders' Corner
Using PROC SQL and PROC TRANSPOSE to provide Excel’s Pivot functions
Source category: Beyond the Basics
File inside source ZIP: BeyondBasics.zip / BB14.Nguyen.pdf
The publisher distributes this paper in a category ZIP inside the proceedings ZIP.
Author collections: Mai Nguyen · Shane Trahan
Using PROC SQL to Calculate FIRSTOBS
Source category: Coders’ Corner
Eliminating Redundant Custom Formats (or How to Really Take Advantage of PROC SQL, PROC CATALOG, and the DATA Step)
Source category: Applications Development
Author collections: Philip A. Wright
Exploring DATA Step Merges and PROC SQL Joins
Source category: Foundations and Fundamentals
Author collections: Kirk Paul Lafler
Exploring Powerful Features in PROC SQL
Source category: Foundations and Fundamentals
Author collections: Kirk P. Lafler