Look What's New in SAS/ACCESS®: New Engines and SQL Optimization
Source category: SAS Presents
Author collections: Howard Plemmons
THE COMMUNITY ARCHIVE
PROC SQL Papers and PresentationsPage 10
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 181–200
PROC MEANS versus PROC SQL for Descriptive Statistics Generation of Weighted Data
Source category: Analytics and Statistics
Author collections: Keiko I. Powers
Ready To Really Become Productive Using PROC SQL?
Source category: Hands-On Workshops
Author collections: Sunil Kumar Gupta
Updating an MS SQL database from SAS
Source category: Coders Corner
Author collections: Jim Groeneveld
Using the SQL Procedure to Summarize and Transpose Data
Source category: Coders' Corner
Author collections: Kevin Chung
Yes, PROC SQL Is Great, But I Love DATA Step Programming: What's a SAS® User to Do?
Source category: Coders' Corner
Author collections: Mira Shapiro
A Propaedeutics for PROC SQL Joins
Source category: Coders' Corner
Author collections: Lisa A Mendez · Toby Dunn
DATA Step versus PROC SQL Programming Techniques
Source category: Tutorials
Author collections: Kirk Paul Lafler
Dear Ms. SAS® Answers: A Guide to Efficient PROC SQL Coding
Source category: SAS Presents
Author collections: Linda Jolley · Jane Stroupe
Exploring PROC SQL Joins and Join Algorithms
Source category: Beyond the Basics
Author collections: Kirk P. Lafler
Exploring the Undocumented PROC SQL _METHOD Option
Source category: Coders' Corner
Author collections: Kirk P. Lafler
Innovation, Implementation, and Integration: Building a DataWarehouse with SAS® Data Integration Studio and MS SQL Server
Source category: Data Integration
Let SQL Write SQL Scripts for You � Counts Report
Source category: Coders' Corner
Author collections: Christine Teng
MERGING vs. JOINING: Comparing the DATA Step with SQL
Source category: Beyond the Basics
PROC SQL and SAS® Macro: Beyond the Basics
Source category: Posters
Author collections: Louie Huang
SAS and SQL “Join” Forces to Perform a Many-to-Many Merge
Source category: Coders’ Corner
Author collections: Ginny Lai · Eric P. Elkin
Simple Applications of SQL
Source category: Foundations and Fundamentals
Author collections: Howard Schreier
A Hands-on Tour Inside the World of PROC SQL
Source category: Hands-On Workshops
Author collections: Kirk Paul Lafler
An Animated Guide: Knowing SQL internal processes makes SQL Easy, makes SQL easy
Source category: Tutorials
Author collections: Russell Lavery
Creating adverse event tables using PROC SQL
Source category: Coding Solutions
Author collections: Berber Snoeijer