HOME QUICK SEARCH AUTHORS KEYWORDS HELP BUGS

sql pass-through

127 papers and 2 presentations; 117 titles.

Back to keywords

Conference × Year × Title × Authors Extras Pages
SESUG 2025 Beyond Macro - Data-Driven Programming with CAS in SAS Viya Mark L. Jordan 21
WUSS 2024 Beyond Macro - Data-Driven Programming with CAS in SAS Viya Mark L. Jordan source 27
PHUSE US 2023 Leveraging Big Data in Real-World Evidence Generation: Data Engineering Challenges and Possibilities Samiul Haque,
S. Robert Collins		 source
presentation source		 6
WUSS 2022 Your Query's No Good Here: PROC SQL Code That Doesn't Work Outside of SAS Jedediah J. Teres source 11
SGF 2021 SAS Deployment on Google Cloud Tips/Tricks including BigQuery Integration Ande Stelk source 8
SGF 2020 Best Practices in SAS Programming to Support Ever-Increasing Data Loads. John Schmitz source 15
SGF 2020 Introduction to SAS/ACCESS Interface to Google BigQuery Joel Odom source 9
SGF 2020 SAS and Amazon Redshift: Overview of Current Capabilities Nicolas Robert source 20
SESUG 2019 CONNECT TO vs. CONNECT USING for Security in SAS PROC SQL Thomas E. Billings source 8
PharmaSUG 2019 PROC SQL to the Rescue: When a Data Step Just Won-t Do Anymore John R. O'Leary source 11
SGF 2019 Accessing Your Favorite Database with SAS and JDBC Salman Maher source 10
SGF 2019 Anything You Can Do I Can Do Better: PROC FEDSQL VS PROC SQL Cuyler Huffman source 11
SGF 2019 SAS and Teradata: SEe the Advances Heather Burnette,
Greg Otto,
Salman Maher		 source 15
SESUG 2018 Emulating FIRST. and LAST. SAS DATA Step Processing in SQL? Concepts and Review Thomas E. Billings source 8
SESUG 2018 Tips for Pulling Data from Oracle Using PROC SQL Pass-Through John J. Cohen source 10
SGF 2018 Efficiently Join a SAS Data Set with External Database Tables Dadong Li,
Michael Cantor		 source 6
SGF 2018 External Databases: Tools for the SAS Administrator Mathieu Gaouette source 13
SGF 2018 Using SAS 9.4M5 and the Varchar Data Type to Manage Text Strings Exceeding 32 kb John Schmitz source 8
SESUG 2017 Data movement issues: Explicit SQL Pass-Through can do the trick Kiran Venna source 8
MWSUG 2017 Extraction and Use of Text Strings with SAS when Source exceeds the 32k String Length Limit John Schmitz 10
PharmaSUG 2017 Writing Efficient Queries in SAS Using PROC SQL with Teradata Mina Chen source 5
SGF 2017 Exploiting Competitor Data Using SAS/ACCESS Interface to Hadoop Kayne Putman source 6
SGF 2017 SAS and Hadoop: The 6th Annual State of the Union Paul Kent source 16
SGF 2017 What's Love Gotta Do WITH It Jason O'Day source
pdf		 12
SESUG 2016 Tips for Pulling Data from Oracle Using PROC SQL Pass-Through John J. Cohen source 10
MWSUG 2016 Accessing Teradata through SAS, common pitfalls, solutions and tips Kiran Venna 8
MWSUG 2016 Solving Common PROC SQL Performance Killers when using ODBC John Schmitz 11
SGF 2016 An Insider's Guide to SAS/ACCESS Interface to Impala Jeffrey Bailey source 19
SGF 2016 From SAS Data Management to Big Data Appliances: How SAS/ACCESS Makes Life Easier Magali Thesias source
presentation		 13
SGF 2016 High-Performance Data Access with FedSQL and DS2 Shaun Kaufmann source 13
SGF 2016 Performing Efficient Wide-to-Long Transposes on Teradata Tables Using SAS Explicit Pass-Through Tao Cheng source 13
SGF 2016 Ten Tips to Unlock the Power of Hadoop with SAS Nancy A. Rausch,
Wilbram Hazejager		 source 12
MWSUG 2015 Just passing through ... Or are you? Determine when SQL Pass-Through occurs to optimize your queries Misty Johnson 8
MWSUG 2015 Leveraging Hadoop from the Comfort of SAS Emily Hawkins,
Lal Puthenveedu Rajanpillai		 9
MWSUG 2015 Macro to Create Multiple SQL IN Clauses from One Column of Data Mark Millman 8
SESUG 2015 Migrating Databases from Oracle to Teradata Phillip Julian source 12
WUSS 2015 Find What You Are Looking For And More in SAS Enterprise Guide Casey Smith source 19
WUSS 2015 Managing Tables in Microsoft SQL Server using SAS Jason Chen,
Jon Javines,
Alan Schepps,
Yuexin (Cindy) Chen		 source 12
SGF 2015 Find What You Are Looking For And More in SAS Enterprise Guide Casey Smith source 19
SGF 2015 Performing Efficient Transposes on Large Teradata Tables Using SQL Explicit Pass-Through Tao Cheng source 17
SGF 2015 Step into the Cloud: Ways to Connect to Amazon Redshift with SAS/ACCESS James Wang,
Salman Maher		 source 13
SGF 2015 Time to Harvest: Operationalizing SAS Analytics on the SAP HANA Platform Morgen Christoph source 11
SGF 2015 Unstructured Data Mining to Improve Customer Experience in Interactive Voice Response Systems Dmitriy Khots source 11
MWSUG 2014 SAS In-Database Analytics for Teradata: Stop the Data Movement Paul Segal,
Tho H. Nguyen,
John Cunningham		 4
WUSS 2014 SAS In-Database Analytics for Teradata: Stop the Data Movement Tho H. Nguyen,
Paul Segal		 source 4
PharmaSUG 2014 Tips for Creating SAS-Based Applications for Oracle Clinical Kunal Agnihotri,
Kenneth W. Borowiak		 source 6
SGF 2014 A Paradigm Shift: Complex Data Manipulations with DS2 and In-Memory Data Structures Shaun Kaufmann source 10
SGF 2014 Empowering SAS Users on the SAP HANA Platform Christoph Morgen source 9
SGF 2014 Making It Happen: A Novel Way to Combine, Construct, Customize, and Implement Your Big Data with a SAS Data Discovery, Analytics, and Fraud Framework in Medicare Vivek Sethunatesan source 15
WUSS 2013 Access to Relational Databases Using SAS Frederick E. Pratter source 10
SCSUG 2013 Improving Your Relationship with SAS EG: Tips from SAS Tech Support Jennifer Bjurstrom source 20
MWSUG 2013 Does foo Pass-Through? SQL Coding Methods and Examples using SAS Software Stephen Crosbie 4
MWSUG 2013 Improving Your Relationship with SAS Enterprise Guide Jennifer Bjurstrom 20
NESUG 2013 PROC SQL Pass-Through Log Adeline J. Wilcox 4
PharmaSUG 2013 A SAS Users Guide to Regular Expressions When the Data Resides in Oracle Kunal Agnihotri,
Kenneth W. Borowiak		 source 9
PharmaSUG 2013 Access to Relational Databases Using SAS Frederick E. Pratter source 10
SGF 2013 Improving Your Relationship with SAS Enterprise Guide: Tips from SAS Technical Support Jennifer Bjurstrom source 20
SGF 2013 Need for Speed - Boost Performance in Data Processing with SAS/Access Interface to Oracle Svein Erik Vralstad source 12
SESUG 2012 A SAS Users Guide to Regular Expressions When the Data Resides in Oracle Kunal Agnihotri source 10
SESUG 2012 Leveraging SQL Return Codes When Querying Relational Databases John E. Bentley source 9
SGF 2012 SAS Solutions Make HEDIS Measures Programming Easier Qingfeng Liang source 9
SGF 2012 What's New in SAS/ACCESS and Process Improvements That You Apply to Your DBMS Howard Plemmons Jr.,
Michael Ames		 source 14
NESUG 2011 SQL Pass-Through and the ODBC Interface Jessica R. Hampton 8
NESUG 2011 Techniques for Reading DB2 Data Steven H. Feder 15
SGF 2011 Best Practices in Data Integration: Advanced Data Management Nancy A. Rausch,
Michael Ames,
David Barkaway,
Jeff Stander		 source 15
SGF 2011 Explicit SQL Pass-Through: Is It Still Useful? Frank Capobianco source 5
SGF 2011 Romancing Your Data: The Getting-to-Know-You Phase Carole Jesse source 12
NESUG 2010 Get Connected - Attach To Your Data Sources Using SAS/ACCESS Laura G. Liotus 9
SCSUG 2010 A SAS Primer for Health Care Data Analysts Christopher W. Schacherer source 24
PHUSE EU 2010 Updating an MS SQL database from SAS Jim Groeneveld source
presentation source		 8
MWSUG 2010 A SAS Primer for Health Care Data Analysts Christopher W. Schacherer,
Brent D. Westra		 24
MWSUG 2010 Choosing the Right Tool from Your SAS and Microsoft Excel Tool Belt Jennifer F. First,
Steven J. First		 18
MWSUG 2010 Romancing Your Data: The Getting-to-Know-You Phase Carole Jesse 12
MWSUG 2010 Stuff We All Do: Mistakes We've Made That You Won't Have To Joe Novotny,
Michael P.D. Bramley		 13
SGF 2010 Choosing the Right Tool from Your SAS and Microsoft Excel Tool Belt Jennifer F. First,
Steven J. First		 source 18
SGF 2010 Look What's New in SAS/ACCESS: New Engines and SQL Optimization Howard Plemmons Jr. source 16
SGF 2010 SAS Data Integration Studio: Tips and Techniques for Implementing ELT Jeff Stander source 16
SGF 2009 Avoiding Common Traps When Accessing RDBMS Data Michael D. Rhoads source 12
SGF 2009 Innovation, Implementation, and Integration: Building a DataWarehouse with SAS Data Integration Studio and MS SQL Server Soeren Junk source 11
NESUG 2008 Avoiding Common Traps When Accessing RDBMS Data Michael D. Rhoads 11
PharmaSUG 2008 Access to Relational Databases Using SAS Frederick E. Pratter 10
NESUG 2007 The LIBNAME Engine Compared to SQL Pass-Through Steven H. Feder 4
SGF 2007 Super Size It!!! Maximize the Performance of Your ETL Processes Nancy A. Rausch,
Nancy J. Wills		 source 14
SGF 2007 Talking to Your RDBMS Using SAS/ACCESS Dianne Louise Rhodes source 15
NESUG 2006 Multi-Threaded Reads in SAS/Access for Relational Databases Sarah Whittier,
Panayiotis Manolakos		 7
SESUG 2005 Getting Started with SAS/Access for Oracle F. Joseph Kelley source 19
WUSS 2005 Producing Multipurpose Metadata for Data Quality and a Data Dictionary John E. Bentley source 19
SUGI 2005 Producing Multipurpose Metadata for Data Quality and a Data Dictionary John E. Bentley source 19
NESUG 2004 Optimizing Large Data Imports from a Relational Database Management System Francis Harvey III 10
SCSUG 2004 Joining a SAS Dataset With a SQL Table Using Enterprise Guide Gillis Guidry 6
SCSUG 2004 SAS/ACCESS to External Databases: Wisdom for the Warehouse User Judy Loren 10
MWSUG 2004 Accessing Oracle Tables using Base SAS/SAS Access David Thul 3
SUGI 2004 Improving Peformance: Accessing DB2 Data with SAS 9 Scott Fadden source 17
NESUG 2003 The Dark Side of the Transparent Moon -- Tips, Tricks and Traps of Handling ORACLE Data Using SAS Xinyu Ji 11
SUGI 2003 Performance Tuning SAS/ACCESS for DB2 Scott J. Fadden source 10
SUGI 2003 SAS/ACCESS to External Databases: Wisdom for the Warehouse User Judy Loren source 9
SEUGI 2002 Evaluating SPDS to Improve Performance of a Large Data Warehouse Clare Somerville,
Colin J. Harris		 source 14
PharmaSUG 2002 Access to Relational Databases Using SAS Frederick E. Pratter 4
NESUG 2001 Getting connected with your DATA: Using SAS/CONNECT and SAS/ACCESS to work with data housed in a remote environment Kevin Payton Delaney 8
SESUG 2001 Advanced Methods to Introduce External Data into the SAS System Andrew T. Kuligowski source 10
SUGI 2001 Database Access Using the SAS System Frederick E. Pratter source 5
WUSS 2000 Access to Databases Using SAS/ACCESS Frederick E. Pratter source 4
SEUGI 2000 e-Warehousing with SPD Server [presentation] Leigh Bates source 31
SEUGI 2000 Scalable Performance Data Server 3.0 [presentation] Alan Gormley source 35
SUGI 2000 Client/Server Setup and Implementation - Web and Non-Web Environments John W. Laing source
SESUG 1999 An Introduction to the Next Big Thing: Parallel Computing John E. Bentley source 10
SUGI 1999 Advanced Methods to Introduce External Data into the SAS System Andrew T. Kuligowski source 10
WUSS 1998 Accessing Data from Your PC Using Version 7 of the SAS System Roger Sanders source 5
NESUG 1998 Efficient Access to Data Warehouse With PROC SQL Pass Through Facility James Yang 7
SEUGI 1998 An overview of SAS Software SPDS Jochen Kirsten source 24
SUGI 1998 A Data Access Challenge: Build a SAS Frame Application for Access to an Informix Data Warehouse John E. Bentley source 7
SUGI 1998 Accessing Data from Your PC Using Version 7 of the SAS System, Presented by Michael Ho, SAS Institute Inc. Roger E. Sanders source 1
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 Ten Great Reasons to Learn SAS Software's SQL Procedure Kirk Paul Lafler source 6
SUGI 1998 Version 7 Enhancements to SAS/ACCESS Software Vino Gona,
Jana Van Wyk		 source 10
SCSUG 1997 Ten Great Reasons to Learn SAS Software's SQL Procedure Kirk Paul Lafler 6
SUGI 1997 Introduction to Using PROC SQL Thomas J. Winn Jr. source 7
SCSUG 1996 Introduction to PROC SQL Thomas J. Winn Jr. 16
WUSS 1996 Using SAS Views for Data Resource Visualization Steven A. Wilson source 10
SUGI 1996 A Relational Database Primer tor SAS Programmers Paul Dalberth source 8
SUGI 1996 Configuring and Using ODBC with SAS/ACCESS Software Forrest Boozer source
SUGI 1996 Using SAS Views for Data Source Visualization Steven A. Wilson source 10
WUSS 1995 Administering and Using SAS/CONNECT and SAS/ACCESS Joe Terdiman,
Steven A. Wilson		 source 10
WUSS 1995 Solutions for the Data "Where?" House: Presenting Data form Many Sources Using SAS and ODBC Andrew J. L. Cary source 10
SUGI 1995 Integrating the SAS System for Personal Computers into Your Enterprise David F. Kolb source 22
NESUG 1994 Using SAS with Oracle Products for Database Management and Reporting Henry W. Buffum,
Darryl J. Keith		 7
SUGI 1994 The View Review: PROC SQL Views, SAS/ACCESS Views, and DATA Step Views Andrew A. Norton source 6
MWSUG 1993 The View Review: PROC SQL Views, SAS/ACCESS Views, and DATA Step Views Andrew A. Norton 6

Back to keywords