| WUSS |
2026 |
Automating SDTM Subject Visits (SV) Derivation A Configuration-Driven, Meta-Programming Approach in SAS [presentation] |
Huiqing Chen |
source |
15 |
| MWSUG |
2025 |
Under the Hood: The Mechanics of SQL Query Optimization Techniques |
Kirk Paul Lafler |
source |
8 |
| SESUG |
2025 |
Exploring the World of Metadata with SAS DICTIONARY Tables and SASHELP Views |
Kirk Paul Lafler |
|
7 |
| WUSS |
2025 |
Sugar Rush: SQL Master Class for Pharma Professionals [presentation] |
Charu Shankar |
source |
32 |
| PharmaSUG |
2025 |
Going from PROC SQL to PROC FedSQL for CAS Processing - Common mistakes to avoid. |
Vijayasarathy Govindarajan |
source |
15 |
| PharmaSUG |
2025 |
Sugar Rush: SQL Master Class for Pharma Professionals |
Charu Shankar |
source |
9 |
| MWSUG |
2024 |
Confessions of a PROC SQL Instructor [presentation] |
Charu Shankar |
source |
77 |
| MWSUG |
2024 |
From Paper To Pedigrees: A Beginners Approach with SAS |
Vijay Susmitha Bommini |
source |
14 |
| SESUG |
2024 |
Efficient Way to Create Adverse Event (AE) Summary Tables by System Organ Class (SOC) and Preferred Term (PT) using PROC SQL in SAS |
Hardik Sheth |
source |
8 |
| SESUG |
2024 |
Generating new variables from variable names and values in a DATA step |
Bruce F. Gilsen |
source |
11 |
| SESUG |
2024 |
The Battle of the Titans: DATA Step versus PROC SQL |
Kirk Paul Lafler, Charu Shankar, Richann J. Watson, Joshua M. Horstman |
source |
22 |
| PharmaSUG |
2024 |
The Art of Defensive SAS Programming |
Philip R. Holland |
source |
28 |
| WUSS |
2023 |
Automating Reports Using Macros and Macro Variables |
Ekaterina Roudneva |
source |
18 |
| WUSS |
2023 |
The Battle of the Titans: DATA Step versus PROC SQL |
Kirk Paul Lafler, Richann J. Watson, Joshua M. Horstman, Charu Shankar |
source |
22 |
| SESUG |
2023 |
The Battle of the Titans: DATA Step versus PROC SQL |
Kirk Paul Lafler, Richann J. Watson, Joshua M. Horstman, Charu Shankar |
source |
22 |
| WUSS |
2022 |
Automating Reports Using Macros and Macro Variables |
Ekaterina Roudneva |
source |
18 |
| WUSS |
2022 |
Your Query's No Good Here: PROC SQL Code That Doesn't Work Outside of SAS |
Jedediah J. Teres |
source |
11 |
| SESUG |
2021 |
Under the Hood: The Mechanics of SQL Query Optimization Techniques |
Kirk Paul Lafler |
source |
9 |
| PharmaSUG |
2021 |
Under the Hood: The Mechanics of Various SQL Query Optimization Techniques |
Kirk Paul Lafler |
source |
9 |
| SGF |
2021 |
Data-driven Programming Techniques Using SAS |
Kirk Paul Lafler |
source presentation |
23 |
| SESUG |
2020 |
A Game Plan for Beating the IF-THEN-ELSE Overhead in DATA Steps |
Jason J. Su |
source |
20 |
| SESUG |
2020 |
Creating Data Listings Utilizing PROC Procedures |
Ballari Sen |
source |
9 |
| SCSUG |
2019 |
Introduction to Data-Driven Programming Using SAS for Beginners |
Kirk Paul Lafler |
source |
23 |
| MWSUG |
2019 |
Powerful and "Sometimes" Hard-to-find PROC SQL Features |
Kirk Paul Lafler |
|
14 |
| WUSS |
2019 |
'Tis Better to Give than Receive: Considerations when Sharing Data |
Melissa R. Pfeiffer |
source |
13 |
| WUSS |
2019 |
Easy Solutions To %LET You Reduce Repetitive Programming |
Ekaterina Roudneva |
source |
16 |
| WUSS |
2019 |
Getting the Message Across: Cutting Run Times and Updating Databases with SAS/ACCESS |
Elise S. Mara |
source |
11 |
| PharmaSUG |
2019 |
The Art of Defensive Programming: Coping with Unseen Data |
Philip R. Holland |
source |
8 |
| SGF |
2019 |
Anything You Can Do I Can Do Better: PROC FEDSQL VS PROC SQL |
Cuyler Huffman |
source |
11 |
| SGF |
2019 |
Cool SQL Tricks |
Russell M. Lavery |
source |
53 |
| SGF |
2019 |
Execution of User-Written DS2 Programs inside Apache Spark Using SAS In-Database Code Accelerator |
David Ghazaleh |
source |
18 |
| SGF |
2019 |
Introduction to Data-driven Programming Using SAS |
Kirk Paul Lafler |
source |
23 |
| SGF |
2019 |
Using PROC SQL to Generate Shift Tables More Efficiently |
Jenna Cody |
source |
9 |
| SCSUG |
2018 |
Introduction to Data-driven Programming Using SAS |
Kirk Paul Lafler |
source |
22 |
| PHUSE EU |
2018 |
Please Put Your Data in an Upright Position - Or How to Tackle Verticalisation |
Kristina Zweier |
source presentation source |
9 |
| SESUG |
2018 |
Introduction to Data-driven Programming Using SAS |
Kirk Paul Lafler |
source |
22 |
| SESUG |
2018 |
PROC SQL - GET "INTO:" IT! |
Kelly Schlessman |
source |
5 |
| SESUG |
2018 |
Proc SQL in Twenty Minutes |
John J. Cohen |
source |
11 |
| SESUG |
2018 |
Using PROC SQL to Generate Shift Tables More Efficiently |
Jenna Cody |
source |
8 |
| MWSUG |
2018 |
A Hands-on Introduction to SAS Metadata DICTIONARY Tables and SASHELP Views |
Kirk Paul Lafler |
|
16 |
| WUSS |
2018 |
Advanced Programming Concepts: History of the List Processing and Cardinality Ratio Memes |
Ronald J. Fehd |
source |
30 |
| WUSS |
2018 |
Advanced Programming Techniques Using the DS2 Procedure |
Viraj R Kumbhakarna |
source |
20 |
| WUSS |
2018 |
Introduction to Data-driven Programming Using SAS |
Kirk Paul Lafler |
source |
22 |
| SGF |
2018 |
Advanced Programming Techniques Using the DS2 Procedure |
Viraj R Kumbhakarna |
source |
20 |
| SGF |
2018 |
Cool SQL Tricks |
Russell M. Lavery |
source |
35 |
| SGF |
2018 |
Data-Driven Programming Techniques Using SAS Metadata |
Kirk Paul Lafler |
source |
11 |
| SGF |
2018 |
Non-metadata Methods to Keep Passwords and Sensitive Strings out of SAS Source Code and Logs |
Thomas E. Billings |
source |
21 |
| SGF |
2018 |
The Art of Defensive Programming |
Philip R. Holland |
source |
9 |
| SESUG |
2017 |
Advanced Programming Concepts: History of the List Processing and Cardinality Ratio Memes |
Cardinality Ratio Memes |
source |
29 |
| SESUG |
2017 |
Beyond IF THEN ELSE: Techniques for Conditional Execution of SAS Code |
Joshua M. Horstman |
source |
10 |
| SESUG |
2017 |
I Spy PII: Detect, Protect, and Monitor Personal Data with SAS Data Management |
Cecily Hoffritz |
source |
33 |
| MWSUG |
2017 |
Beyond IF THEN ELSE: Techniques for Conditional Execution of SAS Code |
Joshua M. Horstman |
|
10 |
| MWSUG |
2017 |
DOSUBL and the Function Style Macro |
John Henry King |
|
6 |
| MWSUG |
2017 |
Extraction and Use of Text Strings with SAS when Source exceeds the 32k String Length Limit |
John Schmitz |
|
10 |
| WUSS |
2017 |
An Easy Way to Split a SAS Data Set into Unique and Non-Unique Row Subsets |
Thomas E. Billings |
source |
8 |
| WUSS |
2017 |
Secure Macro-Based Method to Assign LIBNAMEs for Databases |
Thomas E. Billings |
source |
19 |
| PharmaSUG |
2017 |
Beyond IF THEN ELSE: Techniques for Conditional Execution of SAS Code |
Joshua M. Horstman |
source |
10 |
| PharmaSUG |
2017 |
Clinical Trials Data: It-s a Scary World Out There! or Code that Helps You Sleep at Night |
Scott Horton |
source |
10 |
| PharmaSUG |
2017 |
Five Ways to Create Macro Variables: A Short Introduction to the Macro Language |
Arthur L. Carpenter |
source |
12 |
| PharmaSUG |
2017 |
Important and Valuable Things You Can Do with SAS Metadata DICTIONARY Tables and SASHELP Views |
Kirk Paul Lafler |
source |
8 |
| PharmaSUG |
2017 |
Writing Efficient Queries in SAS Using PROC SQL with Teradata |
Mina Chen |
source |
5 |
| SGF |
2017 |
Advanced Programming Techniques with PROC SQL |
Kirk Paul Lafler |
source zip |
20 |
| SGF |
2017 |
An Insider's Guide to Fine-Tuning Your CREATE TABLE Statements Using SAS Options |
Jeffrey Bailey |
source |
16 |
| SGF |
2017 |
Beyond IF THEN ELSE: Techniques for Conditional Execution of SAS Code |
Joshua M. Horstman |
source |
10 |
| SGF |
2017 |
Five Ways to Create Macro Variables: A Short Introduction to the Macro Language |
Arthur L. Carpenter |
source zip |
12 |
| SGF |
2017 |
I Spy PII: Detect, Protect, and Monitor Personally Identifiable Information with SAS Federation Server |
Cecily Hoffritz |
source |
33 |
| SGF |
2017 |
Quick Results with PROC SQL |
Kirk Paul Lafler |
source zip |
20 |
| SCSUG |
2016 |
Beyond IF THEN ELSE: Techniques for Conditional Execution of SAS Code |
Joshua M. Horstman |
source |
6 |
| MWSUG |
2016 |
Beyond IF THEN ELSE: Techniques for Conditional Execution of SAS Code |
Joshua M. Horstman |
|
6 |
| MWSUG |
2016 |
Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques |
Kirk Paul Lafler |
|
20 |
| WUSS |
2016 |
Advanced Programming Techniques with PROC SQL |
Kirk Paul Lafler |
source |
20 |
| WUSS |
2016 |
Beyond IF THEN ELSE: Techniques for Conditional Execution of SAS Code |
Joshua M. Horstman |
source |
6 |
| WUSS |
2016 |
Some Useful Macros to Make Your Data Work Easier |
Ting Sa |
source |
10 |
| WUSS |
2016 |
The Fantastic Four: Running Your Report Using the TABULATE, TRANSPOSE, REPORT, or SQL Procedure |
Joshua M. Horstman |
source |
13 |
| PharmaSUG |
2016 |
Beyond IF THEN ELSE: Techniques for Conditional Execution of SAS Code |
Joshua M. Horstman |
source |
6 |
| PharmaSUG |
2016 |
DOSUBL and the Function Style Macro |
John Henry King |
source |
6 |
| SGF |
2016 |
An Insider's Guide to SAS/ACCESS Interface to Impala |
Jeffrey Bailey |
source |
19 |
| SGF |
2016 |
How to Create Data-Driven Lists |
Kate Burnett-Isaacs |
source |
8 |
| SGF |
2016 |
The Fantastic Four: Running Your Report Using the TABULATE, TRANSPOSE, REPORT, or SQL Procedure |
Joshua M. Horstman |
source |
13 |
| SCSUG |
2015 |
Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques |
Kirk Paul Lafler |
source |
20 |
| MWSUG |
2015 |
Beyond IF THEN ELSE: Techniques for Conditional Execution of SAS Code |
Joshua M. Horstman |
|
3 |
| MWSUG |
2015 |
Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques |
Kirk Paul Lafler |
|
20 |
| MWSUG |
2015 |
Introduction to PROC SQL |
Jennifer First-Kluge |
|
13 |
| MWSUG |
2015 |
Table Lookup Techniques: From the Basics to the Innovative |
Arthur L. Carpenter |
|
11 |
| SESUG |
2015 |
Application Development Techniques Using PROC SQL |
Kirk Paul Lafler |
source |
20 |
| SESUG |
2015 |
Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques |
Kirk Paul Lafler |
source |
20 |
| WUSS |
2015 |
Master Macro Variables - by Examples |
Sophia Yue |
source |
16 |
| PharmaSUG |
2015 |
A Simple Macro to Select Various Variables Lists |
Ting Sa, Yanhong Liu |
source |
5 |
| PharmaSUG |
2015 |
Application Development Techniques Using PROC SQL |
Kirk Paul Lafler |
source |
20 |
| SGF |
2015 |
Table Lookup Techniques: From the Basics to the Innovative |
Arthur L. Carpenter |
source |
11 |
| SCSUG |
2014 |
Conditional Processing Using the Case Expression in PROC SQL |
Kirk Paul Lafler |
|
8 |
| SCSUG |
2014 |
Exploring the SAS Metadata DICTIONARY Tables and SASHELP Views |
Kirk Paul Lafler |
|
7 |
| SCSUG |
2014 |
Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques |
Kirk Paul Lafler |
|
20 |
| SESUG |
2014 |
Application Development Techniques Using PROC SQL |
Kirk Paul Lafler |
source |
17 |
| SESUG |
2014 |
Let SAS Do the Coding for You! |
Robert Williams |
source |
10 |
| MWSUG |
2014 |
An Object Oriented Framework for Simulations in base SAS |
Michael C. Frick |
|
15 |
| MWSUG |
2014 |
Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques |
Kirk Paul Lafler |
|
20 |
| WUSS |
2014 |
Generation Data Groups and their Data Set Metadata (AKA Dropping Bread Crumbs). |
Jess Watkins |
source |
11 |
| WUSS |
2014 |
Table Lookup Techniques: From the Basics to the Innovative |
Arthur L. Carpenter |
source |
11 |
| PharmaSUG |
2014 |
Principles of Writing Readable SQL |
Kenneth W. Borowiak |
source |
9 |
| PharmaSUG |
2014 |
Table Lookup Techniques: From the Basics to the Innovative |
Arthur L. Carpenter |
source |
11 |
| SGF |
2014 |
Exploring Data Access Control Strategies for Securing and Strengthening Your Data Assets Using SAS Federation Server |
Mark Craver, Mike Frost |
source |
11 |
| SGF |
2014 |
Ordering Columns in a SAS Data Set: Should You Really RETAIN That? |
Andrew W. Clapson |
source |
3 |
| SGF |
2014 |
Powerful and Hard-to-find PROC SQL Features |
Kirk Paul Lafler |
source |
19 |
| SGF |
2014 |
SAS Format Optimization: SAS_PUT or UNPUT (Who's On First?) |
David Wiehle |
source |
19 |
| WUSS |
2013 |
Access to Relational Databases Using SAS |
Frederick E. Pratter |
source |
10 |
| WUSS |
2013 |
Quick Results with PROC SQL |
Kirk Paul Lafler |
source |
17 |
| SESUG |
2013 |
A Quick and Gentle Introduction to PROC SQL |
Shane Rosanbalm |
source |
10 |
| NESUG |
2013 |
I Can SQL Clearly Now, the Data's Fine... |
Brian Taaffe |
|
16 |
| NESUG |
2013 |
Quick Results with PROC SQL |
Kirk Paul Lafler |
|
17 |
| PharmaSUG |
2013 |
Access to Relational Databases Using SAS |
Frederick E. Pratter |
source |
10 |
| PharmaSUG |
2013 |
Conditional Processing Using the Case Expression in PROC SQL |
Kirk Paul Lafler |
source |
8 |
| PharmaSUG |
2013 |
Quick Results with PROC SQL |
Kirk Paul Lafler |
source |
17 |
| SGF |
2013 |
Need for Speed - Boost Performance in Data Processing with SAS/Access Interface to Oracle |
Svein Erik Vralstad |
source |
12 |
| SGF |
2013 |
Quick and Easy Techniques for Fast Data Extraction |
Chris Greni, Deepa Sarkar, Jason Yang, Mythili Rajamani |
source |
7 |
| SGF |
2013 |
Renovating Your SAS 9.3 ODS Output: Tools for Everything from Minor Remodeling to Extreme Makeovers |
Bari Lawhorn |
source |
20 |
| SGF |
2013 |
Using SAS to Assess Individuals? Best Performance in Multiple Dimensions |
Aude Pujula, David Maradiaga |
source |
5 |
| NESUG |
2012 |
Fun with PROC SQL |
Darryl Putnam |
|
6 |
| NESUG |
2012 |
Publishing SAS Metadata Using Macros, PROC SQL and Dictionary Tables |
John Fahey, Barry Campbell |
|
9 |
| NESUG |
2012 |
Quick Results with PROC SQL |
Kirk Paul Lafler |
|
17 |
| NESUG |
2012 |
Use the Full Power of SAS in Your Function-Style Macros |
Michael D. Rhoads |
|
10 |
| SCSUG |
2012 |
Exploring DICTIONARY Tables and SASHELP Views |
Kirk Paul Lafler |
source |
7 |
| SESUG |
2012 |
An In-Line View to a SQL |
Darryl Putnam |
source |
6 |
| SESUG |
2012 |
Learning PROC SQL the DATA Step Way |
Meghal Parikh |
source |
8 |
| SESUG |
2012 |
Programmatic Automation of Categorizing and Listing Specific Clinical Terms |
Ravi Kankipati, Abhilash Chimbirithy |
source |
6 |
| SESUG |
2012 |
Queries, Joins, and WHERE Clauses, Oh My!! Demystifying PROC SQL |
Christianna S. Williams |
source |
37 |
| MWSUG |
2012 |
Get SASsy with PROC SQL |
Amie Bissonett |
|
12 |
| PharmaSUG |
2012 |
Get SASsy with PROC SQL |
Amie Bissonett |
source |
12 |
| PharmaSUG |
2012 |
The Greatest Hits: ODS Essentials Every User Should Know |
Cynthia L. Zender |
source |
34 |
| SGF |
2012 |
Queries, Joins, and WHERE Clauses, Oh My!! Demystifying PROC SQL |
Christianna S. Williams |
source |
37 |
| SGF |
2012 |
Techniques for Generating Dynamic Code from SAS DICTIONARY Data |
Jingxian Zhang |
source |
7 |
| SGF |
2012 |
Use the Full Power of SAS in Your Function-Style Macros |
Michael D. Rhoads |
source |
10 |
| SCSUG |
2011 |
Can't Decide Whether to Use a DATA Step or PROC SQL? You Can Have It Both Ways with the SQL Function! |
Jeremy Poling |
source |
7 |
| SCSUG |
2011 |
The Greatest Hits: ODS Essentials Every User Should Know |
Cynthia L. Zender |
source |
34 |
| SESUG |
2011 |
Using SAS Variable Lists Effectively |
Howard L. Schreier |
source |
20 |
| WUSS |
2011 |
Conditional Processing Using the Case Expression in PROC SQL |
Kirk Paul Lafler |
source |
8 |
| WUSS |
2011 |
Powerful and "Sometimes" Hard-to-find PROC SQL Features |
Kirk Paul Lafler |
source |
17 |
| WUSS |
2011 |
Quick Results with PROC SQL |
Kirk Paul Lafler |
source |
17 |
| MWSUG |
2011 |
Fuzzy Merges - A Guide to Joining Data sets with Non-Exact Keys Using the SAS SQL Procedure |
Robert W. Graebner |
|
5 |
| MWSUG |
2011 |
Managing Datasets at Library Level via Dynamically Constructed, DICTIONARY Tables-Driven SAS Code |
Jingxian Zhang |
|
9 |
| MWSUG |
2011 |
Quick Results with PROC SQL |
Kirk Paul Lafler |
|
17 |
| NESUG |
2011 |
Applying INVALUE STATEMENT in PROC FORMAT for Ordering Character Variables |
Prajitha Nair |
|
8 |
| NESUG |
2011 |
Get Started Writing SAS Macros |
Luisa M. Hartman, Jane X. Liao |
|
12 |
| NESUG |
2011 |
Techniques for Reading DB2 Data |
Steven H. Feder |
|
15 |
| NESUG |
2011 |
The Greatest Hits: ODS Essentials Every User Should Know |
Cynthia L. Zender |
|
34 |
| PharmaSUG |
2011 |
Powerful and "Sometimes" Hard-to-find PROC SQL Features |
Kirk Paul Lafler |
source |
17 |
| PharmaSUG |
2011 |
Symbol Table Generator (New and Improved) |
James R. Johnson |
source |
14 |
| SGF |
2011 |
The Greatest Hits: ODS Essentials Every User Should Know |
Cynthia L. Zender |
source zip |
34 |
| SGF |
2011 |
To FREQ, Perchance to MEANS |
Christopher J. Bost |
source |
10 |
| NESUG |
2010 |
An Animated guide: Suggestions for coding standards |
Russell M. Lavery |
|
24 |
| NESUG |
2010 |
PROC SQL: Tips and Translations |
Gail Jorgensen, Susan P. Marcella |
|
23 |
| NESUG |
2010 |
To FREQ, Perchance to MEANS |
Christopher J. Bost |
|
11 |
| NESUG |
2010 |
Variable List Short-Cuts in PROC SQL |
Kenneth W. Borowiak |
|
4 |
| SCSUG |
2010 |
Application of DICTIONARY Tables and SASHELP Views |
Kirk Paul Lafler |
source |
9 |
| WUSS |
2010 |
Application of DICTIONARY Tables and SASHELP Views |
Kirk Paul Lafler |
source |
9 |
| WUSS |
2010 |
New Dogs and Old Tricks Part II: Using the SELECT statement and FLAGS to Streamline your Code |
Stanley E. Fogleman |
source |
4 |
| PHUSE EU |
2010 |
An Animated Guide: Coding Standards for SAS Production Programs |
Russell M. Lavery |
source |
24 |
| MWSUG |
2010 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
|
17 |
| MWSUG |
2010 |
An Introduction to SQL in SAS |
Peter J. Lund |
|
21 |
| MWSUG |
2010 |
Application of DICTIONARY Tables and SASHELP Views |
Kirk Paul Lafler |
|
7 |
| MWSUG |
2010 |
Hard-to-find, But Powerful, PROC SQL Features |
Kirk Paul Lafler |
|
17 |
| MWSUG |
2010 |
Macro Variables Make Life Easier: Applications with SAS to Excel |
Misty Johnson |
|
7 |
| SESUG |
2010 |
How To Use Proc SQL select into for List Processing |
Ronald J. Fehd |
source |
40 |
| PharmaSUG |
2010 |
When Best to Use the %LET Statement, the SYMPUT Routine, or the INTO Clause to Create Macro Variables |
Arthur X. Li |
|
18 |
| SGF |
2010 |
Exploring DICTIONARY Tables and SASHELP Views |
Kirk Paul Lafler |
source |
7 |
| SGF |
2010 |
Exploring Powerful Features in PROC SQL |
Kirk Paul Lafler |
source |
17 |
| SGF |
2010 |
New Dogs and Old Tricks Part II: Using the SELECT statement and FLAGS to Streamline your Code |
Stanley E. Fogleman |
source |
4 |
| SGF |
2010 |
SAS Presents In-Database Base Procedures in Practice |
Scott Mebust, Robert S. Ray |
source |
25 |
| SGF |
2010 |
Tales from the Help Desk 4: Still More Solutions for Common SAS Mistakes |
Bruce F. Gilsen |
source |
8 |
| SGF |
2010 |
Using Advanced Features of User-Defined Formats and Informats |
Ronald P. Cody |
source |
21 |
| SGF |
2010 |
When Best to Use the %LET Statement, the SYMPUT Routine, or the INTO Clause to Create Macro Variables |
Arthur X. Li |
source |
18 |
| SCSUG |
2009 |
Dear Ms. SAS Answers: A Guide to Efficient PROC SQL Coding |
Linda T. Jolley, Jane Stroupe |
|
14 |
| SCSUG |
2009 |
Exploring DICTIONARY Tables and SASHELP Views |
Kirk Paul Lafler |
|
7 |
| SCSUG |
2009 |
Five Ways to Create Macro Variables: A Short Introduction to the Macro Language |
Arthur L. Carpenter |
|
12 |
| SESUG |
2009 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
source |
17 |
| SESUG |
2009 |
Using ODS Select to Limit SAS Output |
Matt Reich |
source |
4 |
| PHUSE EU |
2009 |
An Animated Guide: Coding Standards for SAS Production Programs |
Russell M. Lavery |
source |
15 |
| MWSUG |
2009 |
Dear Miss SASAnswers: A Guide to Efficient PROC SQL Coding |
Jane Stroupe, Linda T. Jolley |
|
14 |
| MWSUG |
2009 |
Exploring DICTIONARY Tables and SASHELP Views |
Kirk Paul Lafler |
|
7 |
| MWSUG |
2009 |
Table Lookups: From IF-THEN to Key-Indexing |
Arthur L. Carpenter |
|
10 |
| PNWSUG |
2009 |
Five Ways to Create Macro Variables: A Short Introduction to the Macro Language |
Arthur L. Carpenter |
|
12 |
| NESUG |
2009 |
Coding Standards |
Russell M. Lavery |
|
15 |
| NESUG |
2009 |
PROC SQL Tips and Techniques |
Gail Jorgensen, Susan P. Marcella |
|
23 |
| WUSS |
2009 |
Exploring DICTIONARY Tables and SASHELP Views |
Kirk Paul Lafler |
source |
7 |
| WUSS |
2009 |
Five Ways to Create Macro Variables: A Short Introduction to the Macro Language |
Arthur L. Carpenter |
source |
12 |
| PharmaSUG |
2009 |
Automating the pooling of variables across multiple datasets using Proc SQL and SAS Macro |
Sanjiv Ramalingam |
|
10 |
| PharmaSUG |
2009 |
Exploring DICTIONARY Tables and SASHELP Views |
Kirk Paul Lafler |
|
7 |
| SGF |
2009 |
Advanced Features of User-Defined Formats and Informats |
Ronald P. Cody |
source |
21 |
| SGF |
2009 |
Avoiding Common Traps When Accessing RDBMS Data |
Michael D. Rhoads |
source |
12 |
| SGF |
2009 |
Let SQL Write SQL Scripts for You - Counts Report |
Christine S Teng |
source |
5 |
| SGF |
2009 |
Secret Sequel: Keeping Your Password Away From the LOG |
Paul D. Sherman, Arthur L. Carpenter |
source |
9 |
| SGF |
2009 |
Variable Names Don't Begin with the Same Characters? No Problem: How to Create Variable List without Copying, Pasting or Excel Intervention |
Xu Zeng |
source |
8 |
| WUSS |
2008 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
source |
17 |
| WUSS |
2008 |
Processing multiple formats with input and output control data sets in PROC FORMAT |
Thomas E. Billings |
source |
8 |
| SESUG |
2008 |
PDA Data Collection: Data Collection issues... SAS Data Step to the Rescue! |
Mira Shapiro |
source |
6 |
| SESUG |
2008 |
Undocumented and Hard-to-find PROC SQL Features |
Kirk Paul Lafler |
source |
17 |
| NESUG |
2008 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
|
17 |
| NESUG |
2008 |
A PROC SQL Primer |
Matthew Taylor |
|
11 |
| NESUG |
2008 |
Tales from the Help Desk 4: Still More Solutions for Common SAS Mistakes |
Bruce F. Gilsen |
|
8 |
| NESUG |
2008 |
Transitioning to SAS Enterprise Guide |
Michael Todd |
|
8 |
| PharmaSUG |
2008 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
|
18 |
| SGF |
2008 |
Advanced Features of User-Defined Formats and Informats |
Ronald P. Cody |
source |
21 |
| SGF |
2008 |
Steps to Success with the SAS Output Delivery System |
Andrew H. Karp |
source |
15 |
| SGF |
2008 |
Using Data Set Values and Variable Names Outside of the DATA Step |
Bruce F. Gilsen |
source |
15 |
| NESUG |
2007 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
|
18 |
| NESUG |
2007 |
Finding Answers in the PROC SQL Documentation |
Howard L. Schreier |
|
12 |
| NESUG |
2007 |
PROC SQL - A Powerful Tool in SAS |
Swetha Kongara, Raja Panchumarthi |
|
9 |
| NESUG |
2007 |
The Output Delivery System (ODS) from Scratch |
Darylene Hecht, Kevin D. Smith |
|
14 |
| NESUG |
2007 |
Using Data Set Values and Variable Names Outside of the DATA Step |
Bruce F. Gilsen |
|
15 |
| SESUG |
2007 |
How To Use Proc SQL select into for List Processing |
Ronald J. Fehd |
source |
16 |
| MWSUG |
2007 |
Exploring DICTIONARY Tables and SASHELP Views |
Kirk Paul Lafler |
|
6 |
| MWSUG |
2007 |
How To Use Proc SQL select into for List Processing |
Ronald J. Fehd |
|
16 |
| WUSS |
2007 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
source |
13 |
| WUSS |
2007 |
Exploring the World of PROC SQL Joins |
Kirk Paul Lafler |
source |
6 |
| WUSS |
2007 |
Secret Sequel: Keeping Your Password Away From the LOG |
Paul D. Sherman, Arthur L. Carpenter |
source |
10 |
| WUSS |
2007 |
The Output Delivery System (ODS) from Scratch |
Kevin D. Smith |
source |
14 |
| SCSUG |
2007 |
Exploring the World of PROC SQL Joins |
Kirk Paul Lafler |
|
6 |
| SCSUG |
2007 |
PROC SQL for New Users |
Kirk Paul Lafler |
|
13 |
| SCSUG |
2007 |
The Output Delivery System (ODS) from Scratch |
Kevin D. Smith |
|
14 |
| PNWSUG |
2007 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
|
13 |
| PharmaSUG |
2007 |
Journeymen's Tools: Data Review Macro FreqAll: Using Proc SQL List Processing with Dictionary.Columns to Eliminate Macro Do Loops |
Ronald J. Fehd |
|
10 |
| PharmaSUG |
2007 |
Proc SQL versus The DATA Step |
JoAnn R. Matthews |
|
39 |
| PharmaSUG |
2007 |
Secret Sequel: Keeping Your Password Away From the LOG |
Paul D. Sherman |
|
10 |
| SGF |
2007 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler, Ben Cochran |
source |
13 |
| SGF |
2007 |
DATA Step vs. PROC SQL: What's a Neophyte to Do? |
Ray Davis, Michael L. Dickstein, Craig Pass |
source |
12 |
| SGF |
2007 |
Journeymen's Tools: Data Review Macro FreqAll: Using Proc SQL List Processing with Dictionary.Columns to Eliminate Macro Do Loops |
Ronald J. Fehd |
source |
10 |
| SGF |
2007 |
Macro Bugs: How to Create, Avoid, and Destroy Them |
H. Ian Whitlock |
source |
20 |
| SGF |
2007 |
SAS Tools for Program Automation |
Richard F. Pless |
source |
12 |
| SGF |
2007 |
Talking to Your RDBMS Using SAS/ACCESS |
Dianne Louise Rhodes |
source |
15 |
| SGF |
2007 |
The Output Delivery System (ODS) from Scratch |
Kevin D. Smith |
source |
14 |
| PNWSUG |
2006 |
Journeymen's Tools: Data Review Macro FreqAll: Using Proc SQL List Processing with Dictionery.Columns to Eliminate Macro Do Loops |
Ronald J. Fehd |
|
10 |
| PNWSUG |
2006 |
PROC SQL vs. the Data Step - Trick or Treat? |
Tom Aldrich |
|
11 |
| MWSUG |
2006 |
Accuracy or Efficiency in Merging |
Cindy Liu |
|
6 |
| MWSUG |
2006 |
Exploring DICTIONARY Tables and SASHELP Views |
Kirk Paul Lafler |
|
6 |
| MWSUG |
2006 |
Journeymen's Tools: Data Review Macro FreqAll: Using Proc SQL List Processing with Dictionary.Columns to Eliminate Macro Do Loops |
Ronald J. Fehd |
|
12 |
| SCSUG |
2006 |
An Introduction to SQL in SAS |
Peter J. Lund |
|
22 |
| PHUSE EU |
2006 |
An Introduction to PROC SQL |
Anthony Cooper |
source |
20 |
| PHUSE EU |
2006 |
Lessons Learned: Valuable (But Hidden) SAS Details |
Dante Di Tommaso, Benjamin Szilagyi |
source |
11 |
| SESUG |
2006 |
Exploring DICTIONARY Tables and SASHELP Views |
Kirk Paul Lafler |
source |
6 |
| SESUG |
2006 |
Journeymen's Tools: Data Review Macro FreqAll: Using Proc SQL List Processing with Dictionary.Columns to Eliminate Macro Do Loops |
Ronald J. Fehd |
source |
9 |
| SESUG |
2006 |
Putting SAS Dataset Variable Names into a Macro Variable |
Stephanie R. Thompson |
source |
4 |
| SESUG |
2006 |
Selecting Variable Names into a Macro Variable Facilitates Data Analysis |
Fenggang Peng |
source |
4 |
| WUSS |
2006 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
source |
11 |
| NESUG |
2006 |
Custom Reports with Proc SQL: A Real-Life Example |
Electra Small |
|
11 |
| NESUG |
2006 |
Exporting & Importing Datasets & Catalogs: Utility Macros |
Adel Fahmy |
|
12 |
| NESUG |
2006 |
Journeymen's Tools: Data Review Macro FreqAll: Using Proc SQL List Processing with Dictionary.Columns to Eliminate Macro Do Loops |
Ronald J. Fehd |
|
9 |
| NESUG |
2006 |
Proc SQL versus The DATA Step |
JoAnn R. Matthews |
|
35 |
| NESUG |
2006 |
Variable List Short-Cuts in PROC SQL |
Kenneth W. Borowiak |
|
4 |
| PharmaSUG |
2006 |
Meta Data That You (Probably) Didn't Know That You Had: A Beginners' Guide to Using SAS Dictionaries and Automatic Macro Variables |
Richard F. Pless |
|
12 |
| PharmaSUG |
2006 |
SAS PROC SQL or Vanilla Flavor |
Angelina Cecilia Mauldin |
|
9 |
| SUGI |
2006 |
A Hands-on Tour Inside the World of PROC SQL |
Kirk Paul Lafler |
source |
11 |
| SUGI |
2006 |
The SQL Procedure - A Primer for SAS Programmers |
Jimmy A. DeFoor |
source |
17 |
| SUGI |
2006 |
Using Data Set Options in PROC SQL |
Kenneth W. Borowiak |
source |
10 |
| PNWSUG |
2005 |
Table Lookups: From IF-THEN to Key-Indexing |
Arthur L. Carpenter |
|
10 |
| SESUG |
2005 |
Five Ways to Create Macro Variables: A Short Introduction to the Macro Language |
Arthur L. Carpenter |
source |
12 |
| SESUG |
2005 |
Macro Bugs - How to Create, Avoid, and Destroy Them |
H. Ian Whitlock |
source |
20 |
| SESUG |
2005 |
Proc SQL Tips and Techniques - How to get the most out of your queries |
Kevin McGowan, Brian Spruell |
source |
11 |
| SESUG |
2005 |
The SQL Optimizer Project: _Method and _Tree in SAS 9.1 |
Russell M. Lavery |
source |
57 |
| SCSUG |
2005 |
Proc SQL - A Primer for SAS Programmers |
Jimmy A. DeFoor |
|
17 |
| MWSUG |
2005 |
Customizing ODS Statistical Graphs |
Cynthia L. Zender, Catherine Truxillo |
|
22 |
| WUSS |
2005 |
A Hands-On Tour of the 5 Most Exciting Features Found in PROC SQL |
Kirk Paul Lafler |
source |
10 |
| WUSS |
2005 |
Customizing ODS Statistical Graphs |
Cynthia L. Zender, Catherine Truxillo |
source |
22 |
| WUSS |
2005 |
Get Going with PROC SQL |
Richard Severino |
source |
20 |
| WUSS |
2005 |
Meta Data That You (Probably) Didn't Know That You Had: A Beginners' Guide to Using SAS Dictionaries and Automatic Macro Variables |
Richard F. Pless |
source |
12 |
| NESUG |
2005 |
Beyond FORMAT Basics |
Michael S. Zdeb |
|
20 |
| NESUG |
2005 |
Using Data Set Options in PROC SQL |
Kenneth W. Borowiak |
|
9 |
| PharmaSUG |
2005 |
What Would I Do without PROC SQL and the Macro Language? |
Jeffrey M. Abolafia |
|
5 |
| SUGI |
2005 |
An Introduction to SQL in SAS |
Pete Lund - SC |
source |
22 |
| SUGI |
2005 |
Customizing ODS Statistical Graphs |
Cynthia L. Zender, Catherine Truxillo |
source |
22 |
| SUGI |
2005 |
Efficiency Considerations Using the SAS System |
Richard D. Langston |
source |
12 |
| SUGI |
2005 |
Macro Bugs - How to Create, Avoid, and Destroy Them |
H. Ian Whitlock |
source |
20 |
| SUGI |
2005 |
Taming Transformation: A Strategy for Metadata within the Warehouse |
Katherine Prairie |
source |
9 |
| SUGI |
2005 |
The SQL Optimizer Project: _Method and _Tree in SAS 9.1 (broken file) |
Russell M. Lavery |
source |
57 |
| SUGI |
2005 |
Using Single-Purpose SAS Macros to Format EXCEL Spreadsheets with DDE |
Perry Watts |
source |
17 |
| SUGI |
2005 |
What Would I Do without PROC SQL and the Macro Language? |
Jeffrey M. Abolafia |
source |
5 |
| NESUG |
2004 |
Clinical Trial Data Validation: Using PROC SQL Effectively |
Balakrishna Dandamudi |
|
20 |
| NESUG |
2004 |
Danger: MERGE Ahead! Warning: BY Variable with Multiple Lengths! |
Robert Virgile |
|
6 |
| NESUG |
2004 |
Using Single-Purpose SAS Macros to Format EXCEL Spreadsheets with DDE |
Perry Watts |
|
17 |
| SCSUG |
2004 |
SAS/ACCESS to External Databases: Wisdom for the Warehouse User |
Judy Loren |
|
10 |
| SESUG |
2004 |
Dictionary Tables and Views: Essential Tools for Serious Applications |
Frank C. DiIorio, Jeffrey M. Abolafia |
source |
17 |
| SESUG |
2004 |
Introduction to PROC SQL |
Steven J. First |
source |
12 |
| WUSS |
2004 |
Creating Efficient SQL - Four Steps to a Quick Query |
Paul D. Sherman |
source |
8 |
| WUSS |
2004 |
Efficiency Techniques for Beginning PROC SQL Users |
Kirk Paul Lafler |
source |
10 |
| WUSS |
2004 |
Five Ways to Create Macro Variables: A Short Introduction to the Macro Language |
Arthur L. Carpenter |
source |
12 |
| WUSS |
2004 |
Table Lookups: From IF-THEN to Key-Indexing |
Arthur L. Carpenter |
source |
10 |
| MWSUG |
2004 |
Efficiency Techniques for Beginning PROC SQL Users |
Kirk Paul Lafler |
|
8 |
| PharmaSUG |
2004 |
A Visual Introduction to PROC SQL Joins |
Kirk Paul Lafler |
|
5 |
| PharmaSUG |
2004 |
Five Ways to Create Macro Variables: A Short Introduction to the Macro Language |
Arthur L. Carpenter |
|
12 |
| PharmaSUG |
2004 |
Programming Tips and Examples for Your Toolkit |
John Morrill, Kristi Wiser |
|
8 |
| SUGI |
2004 |
Advanced Programming Techniques for Working with Color in SAS Software |
Perry Watts |
source |
19 |
| SUGI |
2004 |
DATA Step vs. PROC SQL: What's a Neophyte to Do? |
Craig Dickstein, Ray Pass |
source |
13 |
| SUGI |
2004 |
Dictionary Tables and Views: Essential Tools for Serious Applications |
Jeffrey M. Abolafia, Frank C. DiIorio |
source |
20 |
| SUGI |
2004 |
Efficiency Techniques for Beginning PROC SQL Users |
Kirk Paul Lafler |
source |
11 |
| SUGI |
2004 |
Introduction to PROC SQL |
Katie Minten Ronk |
source |
14 |
| WUSS |
2003 |
Table Lookups: From IF-THEN to Key-Indexing |
Arthur L. Carpenter |
source |
7 |
| SCSUG |
2003 |
Proc SQL - A Primer for SAS Programmers |
Jimmy A. DeFoor |
|
10 |
| SCSUG |
2003 |
SQL - Intermediate |
Destiny Corporation (a company) |
|
19 |
| SCSUG |
2003 |
SQL Basics |
Destiny Corporation (a company) |
|
17 |
| SESUG |
2003 |
Dictionary Tables and Views: Essential Tools for Serious Applications |
Frank C. DiIorio, Jeffrey M. Abolafia |
source |
10 |
| MWSUG |
2003 |
SQL Basics |
Destiny Corporation (a company) |
|
17 |
| NESUG |
2003 |
Advanced Programming Techniques for Working with Color in SAS Software |
Perry Watts |
|
18 |
| NESUG |
2003 |
Danger: MERGE Ahead! Warning: BY Variable with Multiple Lengths! |
Robert Virgile |
|
6 |
| NESUG |
2003 |
SQL Basics Using Proc SQL |
Christopher Zogby |
|
4 |
| PharmaSUG |
2003 |
Danger: MERGE Ahead! Warning: BY Variable with Multiple Lengths! |
Bob Virgile |
|
6 |
| PharmaSUG |
2003 |
Electronic Submission of SAS Data and Catalogs Simplified |
Adel Fahmy |
|
6 |
| PharmaSUG |
2003 |
SQL for People Who Don't Think They Need SQL |
Erin M. Christen |
|
8 |
| SUGI |
2003 |
Danger: MERGE Ahead! Warning: BY Variable with Multiple Lengths! |
Bob Virgile Danger |
source |
6 |
| SUGI |
2003 |
SAS/ACCESS to External Databases: Wisdom for the Warehouse User |
Judy Loren |
source |
9 |
| MWSUG |
2002 |
SQL Basics |
Destiny Corporation (a company) |
|
5 |
| SCSUG |
2002 |
SQL Basics |
Dana Rafiee |
|
5 |
| NESUG |
2002 |
A Few Alternatives to IF-THEN-ELSE |
Jonas V. Bilenas |
|
2 |
| NESUG |
2002 |
SQL Basics |
Destiny Corporation (a company) |
|
6 |
| SESUG |
2002 |
Multiple Uses for a Simple SQL Procedure |
Rebecca Larsen |
source |
4 |
| SESUG |
2002 |
Problem Solving Techniques with SQL |
Kirk Paul Lafler |
source |
6 |
| SESUG |
2002 |
SQL Basics |
Destiny Corporation (a company) |
source |
5 |
| SESUG |
2002 |
Structured Query Language: Logic, Structure, and Syntax |
Sigurd W. Hermansen |
source |
10 |
| SUGI |
2002 |
An Introduction to SAS PROC SQL |
Timothy J. Harrington |
source |
6 |
| SUGI |
2002 |
DATA Step vs. PROC SQL: What's a Neophyte to Do? |
Craig Dickstein, Ray Pass |
source |
9 |
| SUGI |
2002 |
Keeping Form Data from Falling into the Bit Bucket with webAF |
Heather E. DeMartino |
source |
5 |
| SUGI |
2002 |
Table Look-up: Techniques Beyond the Obvious |
Henri Theuwissen, Nancy Croonen |
source |
9 |
| NESUG |
2001 |
Migrating Your SAS ODBC Application To ADO |
David Shamlin |
|
7 |
| NESUG |
2001 |
SQL Basics |
Destiny Corporation (a company) |
|
5 |
| WUSS |
2001 |
Advanced SQL Processing |
Destiny Corporation (a company) |
source |
15 |
| WUSS |
2001 |
Basic SQL Processing |
Destiny Corporation (a company) |
source |
5 |
| SESUG |
2001 |
Generating Matched Case Data Using PROC SQL |
Imelda C. Go |
source |
3 |
| SESUG |
2001 |
SQL Processing |
Destiny Corporation (a company) |
source |
5 |
| SCSUG |
2001 |
Generating Matched Case Data Using PROC SQL |
Imelda C. Go |
|
3 |
| SCSUG |
2001 |
SQL Processing |
Destiny Corporation (a company) |
|
5 |
| SUGI |
2001 |
An Introduction to PROC SQL |
David E. Beam |
source |
10 |
| SUGI |
2001 |
DATA Step vs. PROC SQL: What's a Neophyte to Do? |
Craig Dickstein |
source |
9 |
| SUGI |
2001 |
Migrating Your SAS ODBC Application To ADO |
David Shamlin |
source |
7 |
| SCSUG |
2000 |
Advanced SQL Processing |
Destiny Corporation (a company) |
|
15 |
| SCSUG |
2000 |
Basic SQL Processing |
Destiny Corporation (a company) |
|
5 |
| NESUG |
2000 |
Basic SQL Processing |
Destiny Corporation (a company) |
|
5 |
| WUSS |
2000 |
Advanced SQL Processing |
Dana Rafiee |
source |
15 |
| WUSS |
2000 |
Basic SQL Processing |
Dana Rafiee |
source |
5 |
| SCSUG |
1999 |
Basic SQL Processing |
Destiny Corporation (a company) |
|
5 |
| SCSUG |
1999 |
Introduction to Using PROC SQL |
Thomas J. Winn Jr. |
|
7 |
| WUSS |
1999 |
Getting Started with SQL |
Kirk Paul Lafler |
source |
6 |
| NESUG |
1999 |
Alternatives to Merging SAS Data Sets But Be Careful |
Michael J. Wieczkowski |
|
7 |
| NESUG |
1999 |
An Introduction to the SQL Procedure |
Christopher Yindra |
|
11 |
| NESUG |
1999 |
Creating Macro Variables via PROC SQL |
Michael S. Zdeb |
|
2 |
| NESUG |
1999 |
Program Generator with DDE and FTP |
John Q. Zhang |
|
9 |
| SUGI |
1999 |
An Introduction to PROC SQL |
David E. Beam |
source |
10 |
| SUGI |
1999 |
An Introduction to PROC SQL |
David E. Beam |
source |
10 |
| MWSUG |
1998 |
An Introduction to PROC SQL |
Pete Hansen |
|
10 |
| SCSUG |
1998 |
Making DBRMs More Readable (or Playing With Strings) |
Ann Stephan |
|
5 |
| SCSUG |
1998 |
SQL Basics |
Destiny Corporation (a company) |
|
5 |
| WUSS |
1998 |
Overview of Java Components and Applets in SAS/IntrNet Software |
Barbara Walters, Donald R. Chapman |
source |
9 |
| WUSS |
1998 |
Querying the Data Warehouse with SQL SELECT Statement |
Kirk Paul Lafler, Sunil Kumar Gupta, Charles E. Shipp |
source |
5 |
| NESUG |
1998 |
An Introduction to the SQL Procedure |
Christopher Yindra |
|
10 |
| SESUG |
1998 |
SQL Basics |
Destiny Corporation (a company) |
|
6 |
| PNWSUG |
1998 |
Advanced SQL |
Dana Rafiee |
|
15 |
| SEUGI |
1998 |
An overview of SAS Software SPDS |
Jochen Kirsten |
source |
24 |
| SUGI |
1998 |
An Introduction to PROC SQL |
Rosalind K. Gusinow, J. Michael Miscisin |
source |
12 |
| SUGI |
1998 |
Intermediate PROC SQL |
Thomas J. Winn Jr. |
source |
7 |
| SUGI |
1998 |
Optimizing SAS Access to an Oracle Database in a Large Data Warehouse |
Clare Somerville, Clive Cooper |
source |
10 |
| SUGI |
1998 |
Overview of Java Components and Applets in SAS/IntrNet Software |
Barbara Walters, Donald R. Chapman |
source |
7 |
| SUGI |
1998 |
Querying the Data Warehouse with the SQL Procedure SELECT Statement |
Kirk Paul Lafler |
source |
5 |
| SUGI |
1998 |
Ten Great Reasons to Learn SAS Software's SQL Procedure |
Kirk Paul Lafler |
source |
6 |
| SUGI |
1998 |
The SAS System Powers Web Measurement Solution at US West |
Robert M. Romero, Dale Hamilton |
source |
5 |
| SCSUG |
1997 |
Ten Great Reasons to Learn SAS Software's SQL Procedure |
Kirk Paul Lafler |
|
6 |
| WUSS |
1997 |
Ten Great Reasons to Learn SAS Software's SQL Procedure |
Kirk Paul Lafler |
source |
6 |
| WUSS |
1997 |
The Select Statement |
Jack Hamilton |
source |
4 |
| NESUG |
1997 |
SELECT ITEMS FROM PROC.SQL WHERE ITEMS > BASICS |
Alan Dickson, Ray Pass |
|
10 |
| SESUG |
1997 |
SQL: A Sequel to the Data Step |
Heidi Markovitz |
|
6 |
| SESUG |
1997 |
Ten Great Reasons to Learn SAS Software's SQL Procedure |
Kirk Paul Lafler |
|
6 |
| PharmaSUG |
1997 |
Integration of Oracle Clinical databases with SAS/PH-Clinical |
Daniel Gronell |
|
10 |
| SUGI |
1997 |
Introduction to Using PROC SQL |
Thomas J. Winn Jr. |
source |
7 |
| SCSUG |
1996 |
Introduction to PROC SQL |
Thomas J. Winn Jr. |
|
16 |
| SESUG |
1996 |
Frame Your View of Data with the SQL Procedure |
Kirk Paul Lafler |
|
4 |
| SESUG |
1996 |
ODBC: Windows to the Outside World |
S. David Riba |
|
10 |
| NESUG |
1996 |
Field Content Verification Using SQL Dictionary Tables |
Jack N. Shoemaker |
|
5 |
| NESUG |
1996 |
ODBC: Windows to the Outside World |
S. David Riba, Elisabeth A. Riba |
|
10 |
| NESUG |
1996 |
Why Neglect SELECT? |
Roger Lustig |
|
8 |
| MWSUG |
1996 |
ODBC: Windows to the Outside World |
S. David Riba, Elisabeth A. Riba |
|
10 |
| PNWSUG |
1996 |
Using SAS View to Enhance Software Quality, Improve Data Security and Reduce Data Replication |
Adam Hendricks |
|
27 |
| SUGI |
1996 |
An Introduction to PROC SOL |
Kim L. Kolbe Ritzow |
source |
9 |
| SUGI |
1996 |
FRAME Your View of Data with the SQL Procedure |
Kirk Paul Lafler |
source |
4 |
| SUGI |
1996 |
SELECT ITEMS FROM PROC.SQL WHERE ITEMS > BASICS |
Alan Dickson, Ray Pass |
source |
10 |
| SCSUG |
1995 |
Remote and Open Access to Enterprise Data: Enhanced Distributed Data Access Through Multiple Engine Architecture |
Jack Wallace, Michael D. Jones |
|
10 |
| MWSUG |
1995 |
SQL Joins - The Long and The Short of It |
Paul Kent |
|
10 |
| NESUG |
1995 |
Cooperative File Interfaces: How SAS & BMDP Can Work Together On VAX/VMS |
Thalene T. Mallus |
|
10 |
| NESUG |
1995 |
Effective Use of SAS Select Language Statement |
Rick Lockwood |
|
2 |
| NESUG |
1995 |
Efficient Data Transformations Using User-Defined Formats and Informats |
Kim L. Kolbe Ritzow |
|
4 |
| NESUG |
1995 |
Frame Your View of Data with the SQL Procedure |
Kirk Paul Lafler |
|
4 |
| NESUG |
1995 |
SELECT ITEMS FROM PROC.SQL WHERE ITEMS > BASICS |
Alan Dickson, Ray Pass |
|
10 |
| NESUG |
1995 |
Simplifying NDA Programming with PROC SQL |
Aileen L. Yam |
|
7 |
| NESUG |
1995 |
Using the SAS System to Create an Interactive Reporting System Using a Host Specific DBMS |
Philip Hamm, Rodney Meeker |
|
8 |
| WUSS |
1995 |
Frame Your View of Data with the SQL Procedure |
Kirk Paul Lafler |
source |
4 |
| WUSS |
1995 |
Introduction to PROC SQL as a Data Summary Tool |
Aileen L Yarn |
source |
5 |
| WUSS |
1995 |
Remote and Open Access to Enterprise Data: Enhanced Distributed Data Access Through Multiple Engine Architecture |
Jack Wallace |
source |
10 |
| SESUG |
1995 |
Frame Your View of Data with the SQL Procedure |
Kirk Paul Lafler |
|
4 |
| SESUG |
1995 |
Host Systems Remote and Open Access to Enterprise Data |
Jack Wallace, Michael D. Jones |
|
10 |
| SESUG |
1995 |
Managing Large Databases Using SAS and Oracle |
Ronald W. Matheny |
|
6 |
| SESUG |
1995 |
SELECT ITEMS FROM PROC.SQL WHERE ITEMS > BASICS |
Alan Dickson, Ray Pass |
|
10 |
| SUGI |
1995 |
Fuzzy Joins using SOL |
Jack N. Shoemaker |
source |
10 |
| SUGI |
1995 |
Intelligent Query Tools for Querying and Reporting |
Beverly Dudley, Henrietta Cummings |
source |
4 |
| SUGI |
1995 |
SELECT ITEMS FROM PROC.SQL WHERE ITEMS > BASICS |
Alan Dickson, Ray Pass |
source |
10 |
| SUGI |
1995 |
Simplifying NDA Programming with PROC SQL |
Aileen L. Yam |
source |
7 |
| SUGI |
1995 |
The SQL Procedure and DB2: Coding without Confusion |
Nancy Fictum |
source |
5 |
| WUSS |
1994 |
SAS/DB2 - Do's and Don'ts |
Michael L. Sperling |
source |
5 |
| NESUG |
1994 |
An Introduction to Structured Query Language and the SQL Procedure for the SAS System |
Joe Cholewczynski |
|
4 |
| NESUG |
1994 |
Fuzzy Joins Using SQL |
Jack N. Shoemaker |
|
10 |
| NESUG |
1994 |
Intelligent Tools for Querying and Reporting from DB2 |
Beverly Wells |
|
4 |
| NESUG |
1994 |
SELECT ITEMS FROM PROC.SQL WHERE ITEMS > BASICS |
Alan Dickson, Ray Pass |
|
10 |
| NESUG |
1994 |
Using SAS with Oracle Products for Database Management and Reporting |
Henry W. Buffum, Darryl J. Keith |
|
7 |
| MWSUG |
1994 |
Using the DB2 System Catalog to Generate SAS Programs |
John M. Morrill |
|
7 |
| SESUG |
1994 |
Command Line Argument Processing: No Interface Required! |
Paul Dalberth |
|
2 |
| SUGI |
1994 |
SELECT ITEMS FROM PROC.SQL WHERE ITEMS > BASICS |
Alan Dickson, Ray Pass |
source |
10 |
| NESUG |
1993 |
The PROC SQL Pass-Through Facility: Taking Advantage |
Tim Pruitt |
|
6 |
| WUSS |
1993 |
Using the SQL Procedure |
Kirk Paul Lafler |
source |
10 |
| SCSUG |
1993 |
A Legislative Bill Text Retrieval and Distribution System Using SAS, PROC SQL, and SAS/Access to DB2 |
John Turman, Kathe Richards |
|
6 |
| MWSUG |
1993 |
Efficient Programming with PROC SQL |
Kim L. Kolbe Ritzow |
|
4 |
| SUGI |
1993 |
DATA Step Changes and Enhancements |
Jeffrey A. Polzin |
source |
6 |
| SUGI |
1993 |
SAS Applications Programming with DB2/SQL |
David J. Adamson |
source |
6 |
| SUGI |
1993 |
Using SAS/ACCESS Software with PC Files and Databases |
Forrest Boozer |
source |
8 |
| SUGI |
1993 |
Using the SQL Procedure |
Kirk Paul Lafler |
source |
10 |
| SESUG |
1993 |
Keep It Simple: Applied SAS/AF Menu Techniques |
Vicentee Ferguson |
|
5 |
| SCSUG |
1992 |
A Talk on SQL |
Paul Kent |
|
12 |
| NESUG |
1992 |
Moving SAS Transport Files Across Different Hardware Platforms - An Advanced Tutorial |
Tamara R. Fischell |
|
8 |
| NESUG |
1992 |
SAS Applications Programming with DB2/SQL |
David J. Adamson |
|
6 |
| NESUG |
1992 |
Use of SAS/SQL and LATEX to Create Automatiically Regenerating Statistical Reports |
David Schoenfield, Felicia Borglum |
|
14 |
| MWSUG |
1992 |
DATA Step Changes and Enhancements |
Jeffrey A. Polzin |
|
6 |
| SEUGI |
1992 |
Accessing Data in a Distributed Database Environment Using SAS/ACCESS Software |
Bengt Bengtsson |
source |
10 |
| SEUGI |
1992 |
Corporate Data: Bringing Together the Islands of Information with SAS/ACCESS Software |
Emily P. Wallace |
source |
4 |
| SEUGI |
1992 |
DATA Step Changes and Enhancements |
Bent Sorenson |
source |
6 |
| SUGI |
1992 |
Advanced Programming Topics for the SAS/ACCESS Interface to DB2 Using the New Features of Release 6.07 |
Bradley W. Klenz, Charles A. Jacobs |
source |
|
| SUGI |
1992 |
Moving SAS Transport Files Across Different Hardware Platforms - An Advanced Tutorial |
Tamara R. Fischell, Margaret Menache |
source |
8 |
| SUGI |
1992 |
Using SAS/Access Software and Database Management Systems in a Distributed Environment |
Jana Van Wyk |
source |
10 |
| SUGI |
1992 |
Using the SQL Procedure |
Kirk Paul Lafler |
source |
6 |
| MWSUG |
1991 |
Effectively Using the SAS System for Survey Research |
Kim L. Kolbe |
|
5 |
| MWSUG |
1991 |
SAS V6.06 PROC FORMAT: Stored Statically or Dynamically |
Bill Parman |
|
10 |
| SEUGI |
1991 |
Some New Features in the DATA STEP |
Sarah Bell |
source |
7 |
| SEUGI |
1991 |
SQL and SAS/ACCESS Differences and Interrelationships |
Mouloud Dey |
source |
7 |
| SUGI |
1991 |
An Insider's Sneak Preview of the Next DATA Step Release |
Jeffrey A. Polzin |
source |
7 |
| SUGI |
1991 |
Differences and Interrelationships Between the SQL Procedure and SAS/ACCESS Software |
Mark Stranieri |
source |
7 |
| SUGI |
1991 |
Efficient Use of the SAS/ACCESS Interfaces to INGRES and Sybase |
Jana Van Wyk |
source |
6 |
| SUGI |
1991 |
Multiple Engine Architecture: A Comparison of Database Management Systems Using the SAS/ACCESS Interface |
Alma Zuniga |
source |
10 |
| SUGI |
1991 |
Using SAS/CONNECT and SAS/ACCESS Software to Access Data in a Distributed Environment |
Stephanie Creech, Jana Van Wyk |
source |
8 |
| SUGI |
1991 |
Using the SQL Procedure |
Kirk Paul Lafler |
source |
4 |
| SEUGI |
1990 |
Strategies for Planning and Implementing the Migration of SAS Applicatiosn from Version 5 to Version 6 |
Juliano Ginevro |
source |
10 |
| SUGI |
1990 |
Converting SAS Data Libraries under MVS from a Version 5 to a Version 6 Format: When and How |
Lisa M. Ripperton |
source |
8 |
| SUGI |
1990 |
Converting Version 5 Files to Release 6.06 Files: Using the V5TOV6 Procedure |
Helen Wolfson |
source |
5 |
| SUGI |
1990 |
DB2 and SAS/DB2 Software EXPLAINed |
Diane E. Brown |
source |
6 |
| SUGI |
1990 |
Modular Course Design: Develop and Deliver a Technical Course |
Kim Burch |
source |
5 |
| SUGI |
1990 |
SAS/ACCESS Interface to ORACLE and Rdb/VMS;"Release 5.18 and Release 6.06 of the SAS System |
Margaret Underberg |
source |
5 |
| SUGI |
1990 |
Transporting Files in Release 6.06 of the SAS System |
Duane E. Ressler, Holly Whittle |
source |
9 |
| SUGI |
1990 |
Writing Efficient SAS/DB2 Applications in Version 6 of the SAS System |
Charles A. Jacobs III |
source |
7 |
| NESUG |
1989 |
Modular Course Design |
Kim Burch |
|
7 |
| SUGI |
1989 |
Integrating New Applications Tools in Version 6 |
John McIntyre, Richard Roach, Jill Sarisky |
source |
11 |
| SEUGI |
1988 |
SQL and the SAS System Version 6 and Beyond |
Lewis Church Jr., Paul Kent |
source |
4 |
| SUGI |
1988 |
Efficient Programming with the SAS System for Personal Computers: Save Time, Save Space |
Lisa Ann Horwitz, E. Tim Thompson |
source |
6 |
| SUGI |
1988 |
Processing Large Files: The SUMMARY Procedure and Other Efficiency Tips |
Juliana M. Ma |
source |
9 |
| SUGI |
1988 |
SQL and the SAS System Version 6 and Beyond |
Lewis Church Jr., Paul Kent |
source |
4 |
| SEUGI |
1987 |
Rocheford Research on Creating a Human Environment for On-Line Research Tools |
L.K. J. van Romunde |
source |
15 |
| SUGI |
1987 |
Efficiency and Performance Considerations for the SAS System under PC DOS |
Gordon W. Davis, Scott C. Sweetland |
source |
9 |
| SUGI |
1987 |
Introduction to SAS/DB2 and SAS/SQL-DS Software |
Emily P. Wallace |
source |
5 |
| SUGI |
1986 |
A Menu-driven Method of Copying SAS Data Sets |
Nat H. Wooding Jr. |
source |
3 |
| SUGI |
1986 |
Using SAS Software to Retrieve Data from IBM Data Base 2 and IBM SQL/DS Data Bases |
Robert A. Wilson |
source |
5 |
| SEUGI |
1985 |
A DB2 Interface to the SAS System under MVS |
Herbert Sinwel |
source |
5 |
| SUGI |
1984 |
Using New Features of the SAS System for Minicomputers |
Stephen M. Beatrous, Bruce M. Tindall |
source |
6 |