The Fantastic Four: Running Your Report Using the TABULATE, TRANSPOSE, REPORT, or SQL Procedure
Source category: Conference presentation
THE COMMUNITY ARCHIVE
PROC SQL Papers and PresentationsPage 6
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 101–120
Tips for Pulling Data from Oracle® Using PROC SQL® Pass-Through
Source category: Coder's Corner
File inside source ZIP: Coders Corner/CC-161_Final_PDF.pdf
Author collections: John Cohen
Top 10 Uses of Macro %VARLIST - In Proc SQL, Data Step and Elsewhere
Source category: Coding Solutions
Author collections: Jean-Michel Bodart
Application Development Techniques Using PROC SQL
Source category: Hands-On Training
Author collections: Kirk Paul Lafler
Application Development Techniques Using PROC SQL
Source category: Hands On Workshop
File inside source ZIP: SESUG 2015 Final paper PDF Files 11_2_2015/Hands_on_Workshops/24_Final_PDF.pdf
Author collections: Kirk Paul Lafler
Creating output datasets using SQL (Structured Query Language) only
Source category: Quick Tips
Dynamic, Powerful, User-friendly SQL Joins Made Easy with %VARLIST, a Generic SAS® Macro Function
Source category: Coder's Corner
Author collections: Jean-Michel Bodart
Essential Data Step Merge and PROC SQL Join Techniques using SAS University Edition Software
Source category: Foundations & Fundamentals
Author collections: Charles Edwin Shipp
Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques
Source category: Foundations & Fundamentals
Author collections: Kirk Paul Lafler
Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques
Source category: Application Development
File inside source ZIP: SESUG 2015 Final paper PDF Files 11_2_2015/Application_Development/16_Final_PDF.pdf
Author collections: Kirk Paul Lafler
Nifty Uses of SQL Reflexive Join and Subquery in SAS®
Source category: Conference presentation
Performing Efficient Transposes on Large Teradata Tables Using SQL Explicit Pass-Through
Source category: Conference presentation
PROC RANK, PROC SQL, PROC FORMAT and PROC GMAP Team Up and a (Map) Legend is Born!
Source category: Reporting and Information Visualization
The publisher lists this abstract, but its numbered PDF is missing or unreadable in the original ZIP.
PROC RANK, PROC SQL, PROC FORMAT, and PROC GMAP Team Up and a (Map) Legend Is Born!
Source category: Conference presentation
PROC SQL for PROC SUMMARY Stalwarts
Source category: Conference presentation
PROC SQL for SQL Die-hards
Source category: Quick Tips
Author collections: Barbara Ross
PROC SQL: Make it a monster using these powerful functions and options
Source category: Techniques and Tutorials
Author collections: Arun Raj Vidhyadharan · Sunil Mohan Jairath
Something for Nothing? Adding Group Descriptive Statistics Using SAS® PROC SQL Subqueries II
Source category: Conference presentation
SQL by Example: A Comparative Introduction to PROC SQL
Source category: Coder's Corner
Author collections: Jeanina Worden
Using SAS PROC SQL to Create a Build Combinations Tool to Support Modularity
Source category: Application Development
File inside source ZIP: SESUG 2015 Final paper PDF Files 11_2_2015/Application_Development/32_Final_PDF.pdf
Author collections: Stephen Sloan