HOME QUICK SEARCH AUTHORS KEYWORDS HELP BUGS

lookup

386 papers and 6 presentations; 315 titles.

Back to keywords

Conference × Year × Title × Authors Extras Pages
PharmaSUG 2026 DOSEON: Fuzzy Matching DOSE Date Intervals ON Analysis Dates Across SAS (PROC SQL, SAS Macro, DATA Step, and PROC FCMP) Inka Leprince,
Troy Martin Hughes
source 39
PharmaSUG 2026 R-Based Translation of Japanese Characters in Clinical Datasets for Regulatory Reporting Hardik Sheth,
Roshan Stanly
source 7
PharmaSUG 2026 SAS Programming techniques for efficiency and code optimization Jayanth Iyengar source 27
PharmaSUG 2026 Three Ways to Over-Engineer Your SAS Custom Steps Mary Dolegowski,
S. Robert Collins
source 9
PharmaSUG 2026 Understanding Administrative Healthcare Datasets using SAS programming tools Jayanth Iyengar source 25
PHUSE US 2026 AI-Optimised AESI Flagging: Streamlined SAS Hash Table Logic with Dynamic CALL EXECUTE and Metadata-Driven Specifications Hang Zhong,
Rashad Rasul,
Jiaqi Hu
source
presentation source
12
PHUSE US 2026 Fuzzy Matching DOSE Date Intervals ON Analysis Dates Across SAS (DATA Step, PROC SQL, SAS Macro, and PROC FCMP) Inka Leprince,
Troy Martin Hughes
source
presentation source
32
PHUSE APAC 2026 Don't Loop - Hash! Slashing Clinical Merge Times with Five-Line In Memory SAS Lookups Hayk Nazaryan source
presentation source
5
PHUSE EU 2025 Keeping it Real: A Tiered Approach to Real-World Data Quality by Leveraging Synthetic Data Lisa Murch,
William Kuan
source
presentation source
10
MWSUG 2025 Conducting Survival Analysis in SAS using Medicare Claims as a Real-world data source Jayanth Iyengar source 32
MWSUG 2025 GIS Challenges of Cataloging Catastrophes: Serving up GeoWaffles with a Side of Hash Tables to Conquer Big Data Point-in-Polygon Determination Troy Martin Hughes source 28
MWSUG 2025 Make You Holla' Tikka Masala: Creating User-Defined Informats Using the PROC FORMAT OTHER Option To Call User-Defined FCMP Functions That Troy Martin Hughes source 10
SESUG 2025 Lookup Tables (LUT) in SAS and Data-Driven Programming Imelda C. Go,
Abbas S. Tavakoli
17
WUSS 2025 Conducting Survival Analysis in SAS using Medicare Claims as a Real-world data source Jayanth Iyengar source 32
PharmaSUG 2025 Automating Superscript Display for Upper and Lower Limit of Quantification Values in Pharmacodynamic Tables Anu Eldho source 7
PharmaSUG 2025 Conducting Survival Analysis in SAS using Medicare Claims as a Real-world data source Jayanth Iyengar source 32
MWSUG 2024 Best Practices for Efficiency and Code Optimization in SAS programming Jayanth Iyengar source 20
PHUSE EU 2024 Dynamic Lookups in R [poster] Duong Tran source 1
SESUG 2024 Comparative Examples of Geocoding and Mapping Techniques in SAS and R Using Centers for Disease Control Survey Data Joshua J. Cook,
Louise S. Hadden,
Swann Arp Adams
source 25
SESUG 2024 Look Up Not Down: Advanced Table Lookups in Base SAS Jayanth Iyengar source 20
WUSS 2024 Array Hashing: Simple, Fast, and Efficient Paul M. Dorfman source 12
WUSS 2024 Comparative Examples of Geocoding and Mapping Techniques in SAS and R Using Centers for Disease Control Survey Data Joshua J. Cook,
Louise S. Hadden,
Swann Arp Adams
source 14
PharmaSUG 2024 Periodic safety reports of clinical trials Murali Kanakenahalli,
Annette Bove,
Smita Sehgal
source 8
PharmaSUG 2024 Understanding Administrative Healthcare Datasets using SAS programming tools Jayanth Iyengar source 25
PHUSE US 2024 Automating ADaM Creation in Clinical Trials Part 2 Rie Ichihashi,
Lyubov Sushchenko
source
presentation source
7
WUSS 2023 How To Easily Ingest (Lots Of) External Data Into The SAS Ecosystem By Only Setting One Parameter - Welcome to Data Ingestion Auto Pilot (DIAP) Stephan Weigandt source 13
WUSS 2023 Make You Holla' Tikka Masala: Creating User-Defined Informats Using the PROC FORMAT OTHER Option To Call User-Defined FCMP Functions That Facilitate Data Ingestion Data Quality Troy Martin Hughes source 10
WUSS 2023 Picking Scabs and Digging Scarabs: Refactoring User-Defined Decision Table Interpretation Using the SAS Hash Object To Maximize Efficiency and Minimize Metaprogramming Troy Martin Hughes,
Louise S. Hadden
source 15
WUSS 2023 Table Lookup by Enclosing Hash in FCMP Wenyu Hu source 7
SESUG 2023 Best Practices for Efficiency and Code Optimization in SAS programming Jayanth Iyengar source 20
SESUG 2023 Hashes From The Ashes Paul M. Dorfman,
Richard A. DeVenezia
source 14
SESUG 2023 Make You Holla' Tikka Masala: Creating User-Defined Informats Using the PROC FORMAT OTHER Option To Call User-Defined FCMP Functions That Facilitate Data Ingestion Data Quality Troy Martin Hughes source 10
SESUG 2023 Understanding Administrative Healthcare Datasets using SAS programming tools Jayanth Iyengar source 25
PharmaSUG 2023 Best Practices for Efficiency and Code Optimization in SAS programming Jayanth Iyengar source 20
PharmaSUG 2023 Better CDISC Standards with Metadata Programming Sunil Kumar Gupta,
Abhishek Dabral
source 14
PharmaSUG 2023 Make You Holla' Tikka Masala: Creating User-Defined Informats Using the PROC FORMAT OTHER Option To Call User-Defined FCMP Functions That Facilitate Data Ingestion Data Quality Troy Martin Hughes source 10
PharmaSUG 2023 Picking Scabs and Digging Scarabs: Refactoring User-Defined Decision Table Interpretation Using the SAS Hash Object To Maximize Efficiency and Minimize Metaprogramming Troy Martin Hughes,
Louise S. Hadden
source 15
PharmaSUG 2023 Understanding Administrative Healthcare Datasets using SAS programming tools Jayanth Iyengar source 24
SESUG 2022 Essential Programming Techniques Every SAS User Should Learn Kirk Paul Lafler source 27
SESUG 2022 Standardized, Customized or Both? Defining and Implementing (MedDRA) Queries in ADaM Data Sets Richann J. Watson,
Karl Miller
source 7
SESUG 2022 Why Write Base SAS Code When the Macro Processor Can Do It for You Andrew E. Walker source 13
WUSS 2022 Best Practices for Efficiency and Code Optimization in SAS programming Jayanth Iyengar source 21
WUSS 2022 Essential Programming Techniques Every SAS User Should Learn Kirk Paul Lafler source 27
WUSS 2022 GIS Challenges of Cataloging Catastrophes: Serving up GeoWaffles with a Side of Hash Tables to Conquer Big Data Point-in-Polygon Determination and Supplant SAS PROC GINSIDE Troy Martin Hughes source 28
WUSS 2022 Standardized, Customized or Both? Defining and Implementing (MedDRA) Queries in ADaM Data Sets Richann J. Watson,
Karl Miller
source 7
WUSS 2022 Understanding Administrative Healthcare Datasets using SAS programming tools Jayanth Iyengar source 24
PharmaSUG 2022 GIS Challenges of Cataloging Catastrophes: Serving up GeoWaffles with a Side of Hash Tables to Conquer Big Data Point-in-Polygon Determination and Supplant SAS PROC GINSIDE Troy Martin Hughes source 28
PharmaSUG 2022 Look Up Not Down: Advanced Table Lookups in Base SAS Jayanth Iyengar,
Joshua M. Horstman
source 28
PharmaSUG 2022 The Emerging Use of Automation to Address the Challenge of Cross-Table Consistency Checking of Output Used in the Reporting of Clinical Trial Data Ilan Carmeli,
Keren Mayorov,
Hugh Donovan
source 6
PharmaSUG 2022 Understanding Administrative Healthcare Datasets using SAS programming tools Jayanth Iyengar source 24
PharmaSUG 2022 Validation of Statistical Outputs Using Automation Ilan Carmeli,
Yoran Bar
source 6
PHUSE US 2022 An open-source project to map lab terminology and standardize units for analysis Sunil Kumar Pusarla,
Kevin R. Viel,
Dante Di Tommaso
source
video
presentation source
7
SESUG 2021 Converting Remeasurement Data into Percentile Ranks Based on Baseline Data Using PROC SQL: Patient Experience Measures for CMS Value-Based Purchasing Program Jenhao Jacob Cheng source 7
SESUG 2021 GIS Challenges of Cataloging Catastrophes: Serving up GeoWaffles with a Side of Hash Tables to Conquer Big Data Point-in-Polygon Determination and Supplant SAS PROC GINSIDE Troy Martin Hughes source 28
SESUG 2021 PROC FORMAT for Scrappy SAS Users and Posh Programmers Rachel Straney source 12
PharmaSUG 2021 Essential Programming Techniques Every SAS User Should Learn Kirk Paul Lafler source 26
PharmaSUG 2021 Standardizing Laboratory Data From Diverse RWD to Enable Meaningful Assessments of Drug Safety and Effectiveness Irene Cosmatos,
Michael Bulgrien
source 11
PharmaSUG 2021 Understanding Administrative Healthcare Datasets using SAS programming tools Jayanth Iyengar source 24
PHUSE EU 2020 Advancing SDTM Annotation Through Automation [presentation] Anja Kreis,
Wolfgang Rohnert
source
video
20
SESUG 2020 An Introduction to SAS DATA Step Hash Programming Kirk Paul Lafler source 12
SESUG 2020 Joining SAS and a Complex, Sparsely Populated Database for Machine Learning/Data Mining Thomas E. Billings source 9
SESUG 2020 Look Up Not Down: Advanced Table Lookups in Base SAS Jayanth Iyengar,
Joshua M. Horstman
source 28
SGF 2020 A Hands-on Introduction to SAS Hash Programming Techniques Kirk Paul Lafler source 13
SGF 2020 Best Practices in SAS Programming to Support Ever-Increasing Data Loads. John Schmitz source 15
PHUSE US 2020 Automated Units Verification, Units Conversion and Converted Results Verification Through the Unified Code for Units of Measure and LOINC Sam Tomioka source
presentation source
8
SESUG 2019 UCF's SDES Dashboard: A Collection of Maintenance-Free SAS Web Report Studio Reports Carlos Piemonti source 8
SESUG 2019 When fuzzy matching doesn't work: using the CONTAINS and JOIN functions through SAS EG to find foreign words in text strings Arthur Laciak source 5
MWSUG 2019 Look Up Not Down: Advanced Table Lookups in Base SAS Jayanth Iyengar,
Joshua M. Horstman
24
MWSUG 2019 Understanding Administrative Healthcare Datasets using SAS programming tools Jayanth Iyengar 24
WUSS 2019 A Hands-on Introduction to SAS DATA Step Hash Programming Techniques Kirk Paul Lafler source 12
WUSS 2019 A HOW on Hashing Russell M. Lavery source 25
WUSS 2019 Getting the Message Across: Cutting Run Times and Updating Databases with SAS/ACCESS Elise S. Mara source 11
PharmaSUG 2019 The Power of PROC FORMAT Jonas V. Bilenas,
Kajal Tahiliani
source 13
SGF 2019 HASH Beyond Lookups - Take Another Look Elizabeth Axelrod source 13
SGF 2019 Re-Mapping a Bitmap Paul M. Dorfman,
Lessia S. Shajenko
source 33
SGF 2019 Reduce Table Size and Always Normalize! (Right? Maybe Not!) Darryl Prebble source 8
SGF 2019 Simple Techniques to Improve the Performance of your SAS Programs When Processing Large Data Sets Steve Cavill source 20
SGF 2019 The SAS Hash Object: Well Beyond Table Lookup Paul M. Dorfman,
Donald J. Henderson
source 27
PHUSE US 2019 Stay Relaxed... A Utility to Auto-create Specification! Kaveri Pachiappan source
poster source
7
SCSUG 2018 A Hands-on Introduction to SAS DATA Step Hash Programming Techniques Kirk Paul Lafler source 12
SESUG 2018 Efficient DATA Step Random Sampling Out Of Thin Air Paul M. Dorfman source 16
SESUG 2018 HASH Beyond Lookups - Take Another Look Elizabeth Axelrod source 11
SESUG 2018 Obtain better data accuracy using reference tables Kiran Venna,
Suryakiran Pothuraju
source 10
SESUG 2018 Using PROC FORMAT to Automate Data correction process Dalvi Shreyas source 6
MWSUG 2018 Automatic Indicators for Dummies: A macro for generating dummy indicators from category type variables Matthew Bates 11
MWSUG 2018 Understanding Administrative Healthcare Datasets using SAS programming tools Jayanth Iyengar 24
WUSS 2018 Essential Programming Techniques Every SAS User Should Learn Kirk Paul Lafler source 26
WUSS 2018 Using a lookup table to transform electronic laboratory results into standardized case-specific information to manage a record-breaking flu season Rachel Perry,
Laura Erhart,
Shane Brady
source 10
WUSS 2018 Using Memory Resident Hash Tables to Manage Your Sparse Lookups Arthur L. Carpenter source 11
SGF 2018 Optimizing Red Hat GFS2 on SAS Grid Tony Brown source 8
SGF 2018 Table Look-Up Techniques: Is the FORMAT Procedure the Best Tool for the Job? Andrew T. Kuligowski source 9
SGF 2018 Using Hash Tables to Manage Your Macro Language Control Files Arthur L. Carpenter source 9
SESUG 2017 A Hands-on Introduction to SAS DATA Step Hash Programming Techniques Kirk Paul Lafler source 12
SESUG 2017 HASH Beyond Lookups - Your Code Will Never Be the Same! Elizabeth Axelrod source 8
SESUG 2017 Student Development and Enrollment Services Dashboard at UCF Carlos Piemonti source 8
SESUG 2017 Table Lookups: Getting Started With Proc Format John J. Cohen source 5
PHUSE EU 2017 Are you Still Afraid of Using Arrays? Let's Explore their Advantages Vladyslav Khudov source
presentation source
6
MWSUG 2017 Exploring HASH Tables vs. SORT/DATA Step vs. PROC SQL Lynn Mullins,
Richann J. Watson
14
MWSUG 2017 Proc Transpose Cookbook Douglas Zirbel 12
WUSS 2017 A Hands-on Introduction to SAS DATA Step Hash Programming Techniques Kirk Paul Lafler source 12
WUSS 2017 HASH Beyond Lookups - Your Code Will Never Be the Same! Elizabeth Axelrod source 7
PharmaSUG CN 2017 Streamline Table Lookup by Using HASH in FCMP Qing Liu 8
PharmaSUG 2017 Beyond - Just fix it!- Application of Root Cause Analysis Methodology in SAS Programming. Nagadip Rao source 8
PharmaSUG 2017 Programming Efficiency in the Creation of ADaM BDS Datasets Ellen (Zihui) Lin source 11
PharmaSUG 2017 Standardized, Customized or Both? Defining and Implementing (MedDRA) Queries in ADaM Data Sets Richann J. Watson,
Karl Miller
source 7
SGF 2017 Beyond Table Lookup: The Versatile SAS Hash Object Paul M. Dorfman,
Donald J. Henderson
source 27
SGF 2017 Student Development and Enrollment Services Dashboard at the University of Central Florida Carlos Piemonti source 9
SGF 2017 Yet Another Lookup Method: Updatable Indexed Data Sets Jack Hamilton source 15
SCSUG 2016 PRESTO! CHANGEO! Making Data Transformations Look Like Magic Patricia Hettinger source 13
SESUG 2016 An Introduction to SAS Hash Programming Techniques Kirk Paul Lafler source 12
SESUG 2016 The Power of PROC FORMAT Jonas V. Bilenas source 10
SESUG 2016 Using CALL VNAME to Populate Missing Data from a Default Values Lookup Dataset Raghav Adimulam source 6
MWSUG 2016 A Hands-on Introduction to SAS DATA Step Hash Programming Techniques Kirk Paul Lafler 12
MWSUG 2016 Solving Common PROC SQL Performance Killers when using ODBC John Schmitz 11
WUSS 2016 Avoid Change Control by Using Control Tables Frank A. Ferriola source 8
PharmaSUG 2016 Exploring HASH Tables vs. SORT/DATA Step vs. PROC SQL Richann J. Watson,
Lynn Mullins
source 14
PharmaSUG 2016 Formats and Informats - Concepts and Quick Reference Table Emmy V Pahmer source 8
SGF 2016 Avoid Change Control by Using Control Tables Frank A. Ferriola source 7
SGF 2016 Who's Your Neighbor? A SAS Algorithm for Finding Nearby Zip Codes Andrew W. Clapson,
Annmarie Smith
source
zip
7
SCSUG 2015 An Introduction to SAS Hash Programming Techniques Kirk Paul Lafler source 8
MWSUG 2015 A Macro for Systematic Treatment of Special Values in Weight of Evidence Variable Transformation Chaoxian Cai 9
MWSUG 2015 Base SAS Sentiment Analysis Using Catchprases Mike D. Tangedal 9
MWSUG 2015 Find your Way to Quick and Easy Table Lookups with FINDW Joshua M. Horstman 5
MWSUG 2015 Table Lookup Techniques: From the Basics to the Innovative Arthur L. Carpenter 11
SESUG 2015 Date Dimensiong Christopher Johnson source 4
SESUG 2015 Hash Objects for Everyone Jack Hall source 9
SESUG 2015 Table Lookups: Getting Started With Proc Format John J. Cohen 5
SESUG 2015 Unlock SAS Code Automation with the Power of Macros William 'Gui' Zupko II source 8
SGF 2015 Data Management Techniques for Complex Healthcare Data Gabriela Cantu,
Christopher Klekar
source 14
SGF 2015 Data Quality Scorecard Tom Purvis source
zip
16
SGF 2015 E-Z Simple Hash Object Lookups Andrew Dagis source
zip
6
SGF 2015 Table Lookup Techniques: From the Basics to the Innovative Arthur L. Carpenter source 11
SESUG 2014 More Hash: Some Unusual Uses of the SAS Hash Object Haikuo Bian,
David Maddox
source 11
PHUSE EU 2014 Dynamic Oceans and Static Poolings of Clinical Trial Data in NVx Panteleo Nacci source
presentation source
9
MWSUG 2014 SAS and Relational Databases: What You Should Know Before You Code Patricia Hettinger 15
MWSUG 2014 Using SAS Hash Objects To Cut Down Processing Time Girish K. Narayandas 9
WUSS 2014 An Introduction to SAS Hash Programming Techniques Kirk Paul Lafler source 8
WUSS 2014 Table Lookup Techniques: From the Basics to the Innovative Arthur L. Carpenter source 11
PharmaSUG 2014 Table Lookup Techniques: From the Basics to the Innovative Arthur L. Carpenter source 11
SGF 2014 Exploring DATA Step Merges and PROC SQL Joins Kirk Paul Lafler source 14
SGF 2014 The Power of PROC FORMAT Jonas V. Bilenas source 8
SGF 2014 The SAS Hash Object: It's Time To .find() Your Way Around Peter W. Eberhardt source 17
WUSS 2013 "How Do I...?" There Is More Than One Way To Solve That Problem; Why Continuing To Learn Is So Important Arthur L. Carpenter source 20
WUSS 2013 SAS on a Shingle, More Flippin with Hash Ethan Miller,
Kirk Paul Lafler
source 10
MWSUG 2013 "How Do I...?" There Is More Than One Way To Solve That Problem; Why Continuing To Learn Is So Important Arthur L. Carpenter 20
PharmaSUG 2013 "How Do I...?" There Is More Than One Way To Solve That Problem; Why Continuing To Learn Is So Important Arthur L. Carpenter source 20
PharmaSUG 2013 Doing the hashwork: Using the DATA step hash object to perform common clinical programming chores Miles Dunn source 9
PharmaSUG 2013 Leveraging SDTM Standards to Cut Datasets at Any Visit Anthony L. Feliu,
Stephen W. Lyons
source 12
SGF 2013 "How Do I...?" There Is More Than One Way To Solve That Problem; Why Continuing To Learn Is So Important Arthur L. Carpenter source 19
SGF 2013 Accessing SAS Code via Visual Basic for Applications Jennifer Davies source 5
SGF 2013 Data Fitness: A SAS Macro-based Application for Data Quality of Large Health Administrative Data Mahmoud Azimaee source 12
SGF 2013 Healthcare Claims Processing with Base SAS through Denormalization of ANSI 837 Format Roberto Valverde,
Victor Shigaev
source 7
SGF 2013 Information Retrieval in SAS: The Power of Combining Perl Regular Expressions and Hash Objects Fagen Xie,
Lingxiao Qi
source 6
SGF 2013 Maximizing the Power of Hash Tables David J. Corliss source 8
SGF 2013 Medical Versus Pharmacy Insurance: Which Is More Cost-Effective for Providing the Prescription? Solving the Problem Via SAS Enterprise Guide. Amber Schmitz source 7
NESUG 2012 Accessing SAS Code via Visual Basic for Applications Jennifer Davies 5
NESUG 2012 Let SAS/SHARE Deliver Formatted Data to Microsoft Office Hsiwei Yu,
Tao Dong
10
NESUG 2012 Using Axes Options to Stretch the Limits of SAS/GRAPH Template Language Perry Watts 20
SCSUG 2012 An Introduction to SAS Hash Programming Techniques Kirk Paul Lafler source 8
PHUSE EU 2012 Bootstrap Analysis Double-Independent Programming: Issues and Solutions Nils Penard source
presentation source
10
PHUSE EU 2012 Quartiles within SAS Jorine Putter,
Liz Faber
source
poster source
7
PHUSE EU 2012 Quartiles within SAS Procedures Jorine Putter,
Liz Faber
source 7
SESUG 2012 Using Axes Options to Stretch the Limits of SAS/GRAPH Template Language Perry Watts,
>>>>
source 20
MWSUG 2012 Customer Sentiment Imputation Using Hash Tables David J. Corliss 8
MWSUG 2012 Innovative Techniques: Doing More with Loops and Arrays Arthur L. Carpenter 14
MWSUG 2012 The SAS Hash Object: It's Time To .find() Your Way Around Peter W. Eberhardt 17
WUSS 2012 Innovative Techniques: Doing More with Loops and Arrays Arthur L. Carpenter source 14
WUSS 2012 SAS on a Shingle, Flippin with Hash Ethan Miller,
Kirk Paul Lafler
source 10
WUSS 2012 Scalability of Table Lookup Techniques Richard D. Langston source 5
WUSS 2012 The SAS Hash Object: It's Time To .find() Your Way Around Peter W. Eberhardt source 17
PharmaSUG CN 2012 The SAS Hash Object: It's Time To .find() Your Way Around Peter W. Eberhardt 17
PharmaSUG CN 2012 Using HASH Table to reduce the use of merge for large datasets Long Fang 7
PharmaSUG 2012 Atypical Applications of Proc Transpose John Henry King source 14
PharmaSUG 2012 Exploring DATA Step Merges and PROC SQL Joins Kirk Paul Lafler source 14
PharmaSUG 2012 Innovative Techniques: Doing More with Loops and Arrays Arthur L. Carpenter source 13
SGF 2012 Exploring DATA Step Merges and PROC SQL Joins Kirk Paul Lafler source 14
SGF 2012 The SAS Hash Object: It's Time To .find() Your Way Around Peter W. Eberhardt source 17
SCSUG 2011 An Introduction to SAS Hash Programming Techniques Kirk Paul Lafler source 8
SCSUG 2011 Finding Oracle Table Metadata: When PROC CONTENTS Is Not Enough Jeremy Poling source 12
SESUG 2011 An Introduction to SAS Hash Programming Techniques Kirk Paul Lafler source 8
PHUSE EU 2011 Don't Bring a Spreadsheet to a Database Fight: Case for Microsoft Access Ryan Burns source
presentation source
5
PHUSE EU 2011 Seven sharp surgery tips for Clinical Programmers Rohit Banga,
David J. Garbutt
source
presentation source
15
MWSUG 2011 An Introduction to SAS Hash Programming Techniques Kirk Paul Lafler 8
NESUG 2011 PROC FORMAT - Not Just Another Pretty Face Lois Levin 13
NESUG 2011 The Power of PROC FORMAT Jonas V. Bilenas 9
PharmaSUG 2011 An Introduction to SAS Hash Programming Techniques Kirk Paul Lafler source 8
SGF 2011 Best Solutions for Tuning Performance of ETL Jobs in SAS Data Integration Studio Qingfeng Liang source 10
SGF 2011 The SAS Hash Object: It's Time To .find() Your Way Around Peter W. Eberhardt source 17
SGF 2011 To Hash or Not To Hash! That Is the Question!! When it Comes to SQL!!! Mustaq Ahmad source 12
SGF 2011 What Were We Talking About at Those SAS Conferences, or Let's Make Some Tag Clouds Chang Y. Chung,
John Henry King
source 11
NESUG 2010 Table Lookup in SAS Weili Yang,
Fang K. Chen,
Liping Zhang,
Wenyu Hu
7
NESUG 2010 Table Lookups: Getting Started With Proc Format John J. Cohen 5
NESUG 2010 What Were We Talking About at Those SAS Conferences, or Let's Make Some Tag Clouds Chang Y. Chung,
John Henry King
6
SCSUG 2010 An Introduction to SAS Hash Programming Techniques Kirk Paul Lafler source 6
SCSUG 2010 SAS and Relational Databases: What You Must Know Patricia Hettinger source 18
WUSS 2010 An Introduction to SAS Hash Programming Techniques Kirk Paul Lafler source 6
MWSUG 2010 Supporting Users, Software, and a BI Server: Using SAS to Support SAS LeRoy Bessler 38
MWSUG 2010 The SAS Hash Object: It's Time To .find() Your Way Around - Hands-On Workshop Peter W. Eberhardt 17
SESUG 2010 SAS and Relational Databases: What You Must Know Patricia Hettinger source 12
PharmaSUG 2010 The SAS Hash Object: It's Time To .find() Your Way Around - Hands-On Workshop Peter W. Eberhardt 17
PharmaSUG 2010 The SAS Hash Object: It's Time To .find() Your Way Around - Tutorial Peter W. Eberhardt 17
PharmaSUG 2010 Using the SAS Clinical Standards Toolkit to Validate CDISC SDTM Data [presentation] Gene Lightfoot,
Bill J. Gibson
33
SGF 2010 Finding Your Subjects in a Haystack: The Many Ways of Implementing Table Look-Ups Olga Galin,
Alla Sapozhnikova
source 4
SGF 2010 More Ways to Use SAS to Manage, Monitor, and Control SAS and the SAS BI Server: Tools for the SAS User, Server Administrator, or Manager LeRoy Bessler source 19
SGF 2010 The SAS Hash Object: It's Time To .find() Your Way Around Peter W. Eberhardt source 17
SCSUG 2009 Why Hash? Glen Becker 6
SESUG 2009 Cr8_In_List - Easy Table Driven Programming Steve Sanders source 4
MWSUG 2009 Table Lookups: From IF-THEN to Key-Indexing Arthur L. Carpenter 10
NESUG 2009 Choosing the Right Technique to Merge Large Data Sets Efficiently Qingfeng Liang 9
SGF 2009 Choosing the Right Technique to Merge Large Data Sets Efficiently Qingfeng Liang source 9
SGF 2009 Scalability of Table Lookup Techniques Richard D. Langston source 5
WUSS 2008 ACCESS-ible SAS Formats and Labels Kathryn Martin source 7
WUSS 2008 Tap Into the Power of Formats Nikki M. Carroll source 12
SESUG 2008 SAS Hash Objects: An Efficient Table Look-Up in the Decision Tree Ying Liu source 15
SESUG 2008 Using Lookup Tables to Match Data Wenyu Hu,
Fang K. Chen,
Liping Zhang
source 7
NESUG 2008 Methodologies for converting Excel Spreadsheets to SAS datasets Karin LaPann 8
NESUG 2008 Table Lookups: Getting Started With Proc Format John J. Cohen 5
PharmaSUG 2008 An Animated Guide: Speed Merges with Key Merging and the _IORC_ Variable Russell M. Lavery 9
SGF 2008 I Can Do That with PROC FORMAT Jonas V. Bilenas source 12
SGF 2008 Using Table Lookup Techniques Efficiently Linda T. Jolley,
Jane Stroupe
source 11
SESUG 2007 Improving Efficiency using the "Virtual Merge" Steve Sanders source 3
MWSUG 2007 Getting Started with the DATA Step Hash Object Jason Secosky,
Janice Bloom
9
MWSUG 2007 Table Lookups...You Want Performance? Rob Rohrbough 11
WUSS 2007 Adventures in Arrays Jane Stroupe source 12
WUSS 2007 Tap Into the Power of Formats Nikki M. Carroll source 12
PHUSE EU 2007 Comparison of different ways using table lookups on huge tables Ralf Minkenberg source 6
SCSUG 2007 Adventures in Arrays Jane Stroupe 12
PharmaSUG 2007 Evolution and Implementation of the CDISC Study Data Tabulation Model (SDTM) PharmaSUG Annual Meeting,
Fred Wood,
Tom Guinter
47
PharmaSUG 2007 Getting Started with the DATA Step Hash Object Jason Secosky,
Janice Bloom
9
SGF 2007 Dear Miss SASAnswers: A Guide to SAS Efficiency Linda T. Jolley,
Jane Stroupe
source 8
SGF 2007 Getting Started with the DATA Step Hash Object Jason Bloom,
Janice Secosky
source 9
SGF 2007 Hashing Performance Time with Hash Tables Elena Muriel source 10
PNWSUG 2006 Getting Started with the DATA Step Hash Object Jason Secosky,
Janice Bloom
10
PNWSUG 2006 The Power of PROC FORMAT Jonas V. Bilenas 9
SCSUG 2006 Getting Started with the DATA Step Hash Object Jason Secosky,
Janice Bloom
10
SESUG 2006 Stars and Models: How to Build and Maintain Star Schemas Using SAS Data Integration Server in SAS9 Nancy A. Rausch source 24
NESUG 2006 Need a Speedy Index? RAM It! Lessia S. Shajenko,
Paul M. Dorfman
14
NESUG 2006 The Power of PROC FORMAT Jonas V. Bilenas 9
SUGI 2006 Crafting Your Own Index: Why, When, How Paul M. Dorfman,
Lessia S. Shajenko
source 14
SUGI 2006 Stars and Models - How to Build and Maintain Star Schemas Using SAS ETL Server Nancy A. Rausch source 24
SUGI 2006 The Power of the FORMAT Procedure Jonas V. Bilenas source 9
SUGI 2006 Using External Data Dictionary Files When Building SQL Queries in Base SAS Mike D. Tangedal source 10
PNWSUG 2005 Table Lookups: From IF-THEN to Key-Indexing Arthur L. Carpenter 10
SESUG 2005 _05 Managing a Many to Many Merge using Formats, Direct Access, and Implied Hashing source 8
WUSS 2005 Get Going with PROC SQL Richard Severino source 20
WUSS 2005 Making Your Data File More Versatile for Web Applications Maureen Ross source 6
NESUG 2005 An Animated Guide: Hashing in V9.1 Russell M. Lavery 13
NESUG 2005 Beyond FORMAT Basics Michael S. Zdeb 20
NESUG 2005 Crafting Your Own Index: Why, When, How Paul M. Dorfman,
Lessia S. Shajenko
10
SUGI 2005 Are You Ready to Roll? SAS9 Implementation Lessons Learned Tim Walters source 7
SUGI 2005 Best Practices in Enterprise Data Management Gary Mehler source 14
SUGI 2005 CALL EXECUTE: A Powerful Data Management Tool Denis Michel source 13
SUGI 2005 Let Your Data Power Your DATA Step: Making Effective Use of the SET, MERGE, UPDATE, and MODIFY Statements Howard L. Schreier source 19
SUGI 2005 PROC FORMAT - Not Just Another Pretty Face Lois Levin source 12
NESUG 2004 An Animated Guide: An Animated Guide: Speed Merges with Key Merging and the _IORC_ Variable Russell M. Lavery 6
NESUG 2004 An Animated Guide: Speed Merges: Resource Use by Common Non-parallel Procedures Russell M. Lavery 8
NESUG 2004 PROC FORMAT - Not Just Another Pretty Face Lois Levin 11
SESUG 2004 Taking it Home and Putting it into Practice Diane Cunningham source 8
WUSS 2004 Efficiency of Merging Many Single Column Data Sets to a Many Column and Many Row Prospect Data Set Brian Mayeux source 12
WUSS 2004 Next Generation Data Warehousing with SAS 9 Gary Mehler source 10
WUSS 2004 Table Lookups: From IF-THEN to Key-Indexing Arthur L. Carpenter source 10
PharmaSUG 2004 Customizing Clinical Data Warehouse for Business Intelligence An analyst's view Haibin Shu Barr 8
PharmaSUG 2004 How SAS Thinks or Why the DATA Step Does What It Does Neil H. Howard 17
VIEWS 2004 Help, I've received a Spreadsheet File from StarOffice Calc..! Philip R. Holland 11
SUGI 2004 A Complex Query within SAS/IntrNet John Ranson,
Wai Ming Chan
source 10
SUGI 2004 Developing Data Marts and Web-Enabled OLAP for Actuarial and Underwriting Analysis Michael Krumenaker,
George Bukhbinder
source 8
SUGI 2004 How SAS Thinks or Why the DATA Step Does What It Does Neil H. Howard source 19
SUGI 2004 Improve Your Queries: Hints and Tips for Using SQL Marje Fecht,
Linda A. Mitterling
source 11
SUGI 2004 Next Generation Data Warehousing with SAS 9 Gary Mehler source 11
WUSS 2003 An Animated Guide: Speed Merges with Key Merging and the _IORC_ Variable Russell M. Lavery source 3
WUSS 2003 An Animated Guide: Speed Merges: Formats Russell M. Lavery source 5
WUSS 2003 An Animated Guide: Speed Merges: resource use by common procedures Russell M. Lavery source 7
WUSS 2003 Table Lookups: From IF-THEN to Key-Indexing Arthur L. Carpenter source 7
SCSUG 2003 Merge Processing and Alternative Table Lookup Techniques Destiny Corporation (a company) 7
SESUG 2003 Merge Processing and Alternate Table Lookup Techniques Destiny Corporation (a company) 7
SESUG 2003 Table Lookup By Direct Addressing: From V8 To V9 Paul M. Dorfman source 13
SESUG 2003 Using SAS Macro Language to Develop User-Written Functions Deb Pine source 2
NESUG 2003 An Animated Guide: Power Merges: The Format Table Lookup Russell M. Lavery 10
NESUG 2003 Table Lookup By Direct Addressing: From V8 To V9 Paul M. Dorfman 14
NESUG 2003 User Implementation and Revision of Business Rules Without Hard Coding: Macro-Generated SAS Code Michael Krumenaker,
Jit Bhattacharya
11
NESUG 2003 When Size Matters: How Hashing Saved Our Jobs John J. Cohen,
Russell M. Lavery
8
SUGI 2003 An Efficient Approach to Combine SAS Data Sets with Voluminous Variables That Need Name and Other Changes Grace Chiu,
Edward Heaton
source 5
SUGI 2003 Finding Time: SAS and Data Warehouse Solutions for Determining Last Day of the Month Jennifer O'Neil,
Laural Wierenga
source 4
SUGI 2003 Hashing: Generations Paul M. Dorfman,
Gregg P. Snell
source 10
SUGI 2003 The Horror of Bad Data Quality Henri Theuwissen,
Nancy Croonen
source 7
NESUG 2002 An Animated Guide: Power Merging with Key/_IORC_ Merges Russell M. Lavery 5
NESUG 2002 An Animated Guide: Speed Merges with Key Indexing, Bitmapping and Hashing Paul M. Dorfman,
Russell M. Lavery
10
SESUG 2002 DATA Step Essentials Neil H. Howard source 10
WUSS 2002 DATA Step Internals: Compile and Execute Neil H. Howard source 10
SEUGI 2002 Tracking Error [presentation] Francoise Grandjean,
Gregory Magro
source 21
SUGI 2002 A Secure Online Data Validation &Collection System for HEDIS Survey Data Christopher A. Roper source 9
SUGI 2002 DATA Step Essentials Neil H. Howard source 11
SUGI 2002 Table Look-up: Techniques Beyond the Obvious Henri Theuwissen,
Nancy Croonen
source 9
SUGI 2002 Unit-of-Analysis Programming Vanessa C. Hayden source 6
MWSUG 2001 Table Lookups: From IF-THEN to Key-Indexing Arthur L. Carpenter 8
WUSS 2001 Table Lookups: From IF-THEN to Key-Indexing Arthur L. Carpenter source 8
SESUG 2001 Direct Addressing Techniques of Table Look-Up Part 1. Key-Indexing - Bitmapping Part 2. Hashing Paul M. Dorfman source 10
SCSUG 2001 Direct Addressing Techniques of Table Look-Up Part 1. Key-Indexing - Bitmapping Part 2. Hashing Paul M. Dorfman 10
SEUGI 2001 A Design Framework for Combining Click Stream and Customer Data for an e-CRM Solution [presentation] Mark Ansell source 21
SEUGI 2001 Querying Star and Snowflake Schemas in SAS Bart Heinsius source 5
PharmaSUG 2001 Unit-of-Analysis Programming Vanessa C. Hayden,
Fidelity Investments
6
SUGI 2001 A Pattern for Dynamic Web Content: SAS Server Pages Jack E. Fuller source 6
SUGI 2001 Querying Star and Snowflake Schemas in SAS Bart Heinsius source 5
SUGI 2001 Quick Disk Table Look-up via Hybrid Indexing into a Directly Addressed SAS Data Set Paul M. Dorfman source 6
SUGI 2001 Table Look-Up by Direct Addressing: Key-Indexing - Bitmapping - Hashing Paul M. Dorfman source 10
SCSUG 2000 Merge Processing - Alternative Table Lookup Techniques Destiny Corporation (a company) 7
SESUG 2000 Organizing Ultra-Quick Disk Table Lookup via Hybrid Indexing Into a Directly Addressed SAS Data Set Paul M. Dorfman source 6
SESUG 2000 Table Lookup via Direct Addressing: Key-Indexing, Bitmapping, Hashing Paul M. Dorfman source 11
NESUG 2000 Fuzzy htmSQL for SAS Myles E. Powers 4
NESUG 2000 Indexing: My New Best Friend for Table Lookup Warren E. Stinson 2
NESUG 2000 Merge Processing - Alternative Table Lookup Techniques Destiny Corporation (a company) 8
NESUG 2000 Using Indexes to Perform Table Look-up Sandra Lynn Aker 4
MWSUG 2000 Advanced DATA Step Techniques Neil H. Howard 10
SEUGI 2000 GP's assess the quality and performance of clinical activity through an interactive homepage [presentation] Birgitte Holm Andersen,
Per Allan Jensen
source 59
SUGI 2000 Advanced DATA Step Techniques Neil H. Howard source 10
SUGI 2000 Bring the Data Warehouse of Standardized Medical Costs to the Web Priscilla Van Grevenhof,
Kirsten Hall Long,
Judith L. Wagner,
Ahmed S. Rahman,
James M. Naessens,
Roger W. Evans
source 3
SUGI 2000 Creating Adobe Acrobat (PDF) Documents Directly from SAS Software Paul C. Wehr source 1
SUGI 2000 Table Lookup on the Fly Using SYMPUT and SYMGET 473 John M. Piet source 4
SUGI 2000 Using KEY= to Perform Table Look-up Sandra Lynn Aker source 4
SESUG 1999 Adventures in Arrays: A Beginning Tutorial Jane Stroupe source 6
SESUG 1999 Programming Solutions with SAS Formats and Informats Imelda C. Go source 9
NESUG 1999 Using KEY= to Perform Table Look-up Sandra Lynn Aker 4
MWSUG 1999 Adventures in Arrays: A Beginning Tutorial Jane Stroupe 6
SUGI 1999 Advanced DATA Step Topics Neil H. Howard source 10
SUGI 1999 Introduction to SAS Functions Neil H. Howard source 7
SESUG 1998 Arrays and Scoring Tests Involving Multidimensional Criteria Imelda C. Go 2
SESUG 1998 Building Bridges Between Oracle and SAS Bill Calvert 6
SESUG 1998 PC Hands-On Workshops Destiny Corporation (a company) 7
PNWSUG 1998 Merge Processing - Alternative Table Lookup Techniques Dana Rafiee 8
SEUGI 1998 How OLTP revolution leads to data warehouse evolution and quality testing execution Richard Miller source 33
SEUGI 1998 Using CIDS, a SAS/AF software application, to build a data warehouse and to provide OLAP tools for managers at PTT Post Harm Schipper source 10
SUGI 1998 Data Extraction Methods in Medium and Large Databases Anthony M. Dymond source 6
PNWSUG 1997 Make Your Life Easier with SAS Formats Sean Burnett 9
MWSUG 1997 Building a Better Dataset Descriptor Mike D. Tangedal 6
SUGI 1997 Using OOP Techniques to Make FRAME Applications More Intuitive and User Friendly Mark Bodt source 8
SESUG 1996 NO MORE MERGE - Alternative Table Lookup Techniques Dana Rafiee 6
NESUG 1996 A Universal SAS/ACCESS Macro to Retrieve Data from DB2 Tables Chen Xi,
Linda Bergin
4
MWSUG 1996 Advanced Uses of SAS Formats Howard Levine 10
MWSUG 1996 NO MORE MERGE - Alternative Table Lookup Techniques Dana Rafiee 6
MWSUG 1996 Randomly Accessing Files Using the KEY=Option Kim L. Kolbe Ritzow 10
SEUGI 1996 EIS and data warehousing applications in the telecommunications industry Garth Brown source 5
SUGI 1996 Advanced DATA Step Topics and Tips Neil H. Howard,
Cynthia L. Zender
source
SUGI 1996 Advanced Uses of SAS Formats Howard Levine source 10
SUGI 1996 Implementation of a Barcode Interface to an Existing SAS Database Using SAS/AF and SAS/FSP Software, and SAS Screen Control Language Lee Maddy source 5
SUGI 1996 NO MORE MERGE - Alternative Table Lookup Techniques Dana Rafiee source 6
SUGI 1996 Tuning Tips for Applications That Use SAS/SHARE Software Stephen M. Beatrous,
Bill Brideson,
Daniel J. Squillace,
Jan Squillace
source 11
NESUG 1995 PROC FORMAT: Use of the CNTLIN Option For Efficient Programming Karuna Nerukar,
Andrea Robertson
7
WUSS 1995 Tuning Tips for Applications That Use SAS/SHARE Software Bill Brideson,
Steve Beatrous,
Daniel J. Squillace,
Jan Squillace
source 10
SEUGI 1995 A Concept on Data Delivery for Large Enterprisewide Information Systems Stephan Tobler source 14
SEUGI 1995 A Way to Handle Pharmacokinetic Studies with SAS Software Jean-Michel Cardot source 8
SEUGI 1995 Computer Performance Evaluation: Will your Data Warehouse stand the Test of Time David Annis source 12
SUGI 1995 Finding a Needle in a Haystack: Efficient Filtering of Large Data Sets Daniel R. Bretheim,
Ryan K. Carr
source 6
SUGI 1995 The TlMELOG Tracking System Developed with SAS/AF Frame Technology Donald L Penix Jr. source 3
SUGI 1995 To Merge or Not to Merge: These are the Answers John Badolato source 5
NESUG 1994 Table Lookups in the SAS DATA Step Gary L. Katsanis 7
MWSUG 1994 Finding the Needle in the Haystack: Efficient Filtering of Large Data Sets Daniel R. Bretheim,
Ryan K. Carr
6
SUGI 1994 Developing an Air Quality Data Management System Patricia Tobin source 7
SUGI 1994 Discovering the FUN in SAS Functions Neil H. Howard source 6
SUGI 1994 Processing Large SAS and DB2 Files: Close Encounters of the Colossal Kind Judy Loren,
Alan Dickson
source 8
SUGI 1994 Table Lookups in the SAS DATA Step Gary L. Katsanis source 7
NESUG 1993 Close Encounters of the Colossal Kind: How Can Large SAS and DB2 Files Get Together? Judy Loren,
Alan Dickson
8
NESUG 1993 Utilizing SAS/AF, SAS/FSP, and Screen Control Language to Develop and Attendance Tracking Application Gilda Walker 7
WUSS 1993 Table Lookups using PROC FORMAT, the PUT Function, and a LOOKUP Macro R. David Barsky source 2
MWSUG 1993 Tuning Tips for Applications That Use SAS/SHARE Software Bill Brideson,
Steve Beatrous,
Daniel J. Squillace,
Jan Squillace
10
SUGI 1993 A SAS Solution: Building a Flexible/Standard System to Report the Analysis of Efficacy Data for Clinical Trials Judy A. Sullivan,
Naitee Ting
source 6
SUGI 1993 Discovering the FUN in SAS Functions Neil H. Howard source 5
SCSUG 1992 Discovering the FUN in Functions Neil H. Howard 5
SUGI 1992 Experiments in Indexing Swati Bansal,
Margaret Seldin
source 3
SUGI 1992 Optimal Clinical Data Structures for Use with SAS/PH-Clinical Software Sandra D. Schlotzhauer,
Andrew T. Fagan
source 8
NESUG 1990 Efficient SAS Software Programming: A New Synthesis Jean Hardy 8
NESUG 1990 Ragged Matrices, Real-Time Arragys and Other Novel Concepts Frederick E. Pratter 7
SUGI 1990 If an Axis Is Too Long for the PAGESIZE=, LINESIZE=, HSIZE=, or VSIZE= Options PANELIZE Routines Warren Repole Jr. source 6
SUGI 1990 Table Lookup without a Table Joseph A. Damico source 4
SEUGI 1989 Graphical Analysis Of Regional Blood Flow Distribution By Means Of Pseudocolor Organ Maps Rudolf Schosser source 9
SEUGI 1989 SAS Institute Internal Usage Of The SAS System Allan Russell source 6
SUGI 1989 A Survey of Table Lookup Techniques for the SAS System James E. Johnstone,
Craig K. Ray
source
SUGI 1989 Putting the FORMAT Procedure at the Wheel: Advanced Applications of Table Lookup Peter Kretzman source 8
SUGI 1989 Writing Efficient C Programs Using the SAS/C Compiler Oliver Bradley source 4
NESUG 1988 Efficient Use of Table Lookup Procedures Craig K. Ray,
Howard Levine
15
SUGI 1988 Demystifying the FORMAT Procedure Hallett German source 9
SUGI 1988 Extraction from Enormous Sequential Health Care Claims Data Files Using Multiple Format Tables Nancy Fox,
Craig K. Ray
source 7
SUGI 1988 Implementation of a Hashing Routine in SAS Software Craig K. Ray source 7
SUGI 1988 SAS Functions-Simple but Powerful Techniques Steve G. Holson,
Jenny Putman
source 6
SUGI 1988 The Comparative Efficiency of Table Look-Up Methods Leonard S. Lutomski,
Henry A. Mullally
source 6
SEUGI 1987 From Information Retrieval to Knowledge Based System A. Utlsch source 10
SUGI 1987 A Comparison of Table Look-up Techniques Craig K. Ray source 11
SUGI 1986 Efficient Use of Table Lookup Procedures Howard Levine,
Craig K. Ray
source 6
SUGI 1985 Computerized Material Loading Schedules: An Aid in Implementing High Density Storage Systems Darryl W. Kolojaco source 6
SUGI 1985 SAS-based Data Management System for Clinical Drug Trials Jean A. Bitney source 5
SUGI 1983 Efficient Techniques for Large Data Files Judith H. Mopsik source
SUGI 1982 Selecting Subset of Data Donald J. Henderson source
SUGI 1982 Table Lookup Techniques Donald J. Henderson source 7

Back to keywords