HOME QUICK SEARCH AUTHORS KEYWORDS HELP BUGS

create table

907 papers and 21 presentations; 793 titles.

Back to keywords

Conference × Year × Title × Authors Extras Pages
WUSS 2026 Are We Winning the Vulnerabilities Battle? Measuring Cybersecurity Progress with SAS Viya Data Pipelines [presentation] Mike Krizan source 14
PharmaSUG CN 2026 The reporter package: A Powerful Reporting Package to Replicate SAS Output Bill Huang source 24
PharmaSUG 2026 Biostatistical Foundations 201: Privacy Preserving Patient Linkage Across Real World Data Sources Anbu Damodaran source 8
PharmaSUG 2026 Finding Macros Called Within A Directory of SAS Programs Derek P. Morgan,
Tatiana Kazakova		 source 11
PharmaSUG 2026 From Tables to Tolerances: The Evolving Role of Statistical Programmers in Risk-Based Quality Management (RBQM) Vihar Patel source 14
PHUSE US 2026 Group, Collapse, Repeat: A Dynamic SAS Macro for Stratification Pooling in Oncology Efficacy Analysis Venkatesh Burla source
presentation source		 9
PHUSE US 2026 Where are my Agents? Automating Cohort Building with a Dynamic Cohort Builder Mary Dolegowski,
Sherrine Eid		 source
presentation source		 12
MWSUG 2025 Code Smarter, Not Harder: The 5 C's of ChatGPT for the SASsy Professional Kirk Paul Lafler,
Charu Shankar		 source 49
MWSUG 2025 Conducting Survival Analysis in SAS using Medicare Claims as a Real-world data source Jayanth Iyengar source 32
MWSUG 2025 Validate the Code, not just the Data : A System for SAS program evaluation Jayanth Iyengar source 38
SESUG 2025 Give it a ReST! Working with APIs in SAS Mark L. Jordan 18
SESUG 2025 PROC SQL Case Study Carleigh Jo Crabtree 21
SESUG 2025 Quick Start to the SAS Macro Language Allison Saito 13
SESUG 2025 SAS Macro Case Study Carleigh Jo Crabtree 18
WUSS 2025 Conducting Survival Analysis in SAS using Medicare Claims as a Real-world data source Jayanth Iyengar source 32
WUSS 2025 FDA says, Do the Allowable Total Difference Zone: A Method Comparison using the ATDzone SAS Macro Jesse Albert Canchola,
Natasha Oza		 source 22
WUSS 2025 Inter-reader Variability and Reader Weighting in Diagnostic Accuracy Studies using the SAS System Jesse Albert Canchola,
Monica Vasquez,
Payam Ahmadi		 source 22
WUSS 2025 PFS2, did you hear about it too? - Understanding the derivation of Progression Free Survival on next-line therapy (PFS2). Yeshashwini Chenna,
Lupetu Ntambwe		 source 11
WUSS 2025 Validate the Code, not just the Data : A System for SAS program validation Jayanth Iyengar source 38
PharmaSUG 2025 A SAS Macro Calculating Confidence Intervals of the Difference in Binomial Proportions from Stratified Analysis using the Miettinen & Nurminen Method with Cochran-Mantel-Haenszel Weights Mikhail Melikov,
Brian Mosier		 source 9
PharmaSUG 2025 Code Smarter, Not Harder: The 5 C's of ChatGPT for the SASsy Professional Charu Shankar,
Kirk Paul Lafler		 source 49
PharmaSUG 2025 Conducting Survival Analysis in SAS using Medicare Claims as a Real-world data source Jayanth Iyengar source 32
PharmaSUG 2025 Going from PROC SQL to PROC FedSQL for CAS Processing - Common mistakes to avoid. Vijayasarathy Govindarajan source 15
PharmaSUG 2025 Route Sixty-Six to SAS Programming, or 63 (+3) Syntax Snippets for a Table Look-up Task, or How to Learn SAS by Solving Only One Exercise! Bartosz Jabłoński,
Quentin McMullen		 source 58
PharmaSUG 2025 SET Statement Considered Harmful Bartosz Jabłoński source 21
PharmaSUG 2025 The Many Ways to Build Cohorts to Effectively Generate Real World Evidence and Bring Drugs to Patients Faster Sherrine Eid,
Mary Dolegowski		 source 8
PharmaSUG 2025 Validate the Code, not just the Data : A System for SAS program validation Jayanth Iyengar source 38
PHUSE US 2025 SDTM UP - Versioning - Do's & Don'ts Utkarsh Pathak,
Ephicacy Lifescience		 source
presentation source		 9
PHUSE US 2025 Utility Macro for Ensuring Consistent Updates of CRF Data in SDTM Naren Surampalli source
presentation source		 8
MWSUG 2024 Calculating Cardinality Ratio in Two Steps Ronald J. Fehd source 22
MWSUG 2024 From Paper To Pedigrees: A Beginners Approach with SAS Vijay Susmitha Bommini source 14
MWSUG 2024 NHANES Dietary Supplement component: a parallel programming project Jayanth Iyengar source 20
MWSUG 2024 SAS PROC GEOCODE By Example: A Case Study [presentation] Louise S. Hadden source 44
MWSUG 2024 SAS Programming And Generic Techniques for Cohort Creation and Consort Diagrams Brandy R. Sinco source 4
PHUSE EU 2024 BY-lieve in better BY group tables Chris Spence source
presentation source		 10
PHUSE EU 2024 Resolving algorithmic SMQs - using AI chatbot and other techniques Corentin Le Scanff source
presentation source		 21
SESUG 2024 A SAS Automation Example for Completing Reporting Templates in Microsoft Excel Imelda C. Go,
Abbas S. Tavakoli		 source 18
SESUG 2024 NHANES Dietary Supplement component: a parallel programming project Jayanth Iyengar source 20
SESUG 2024 Replicating SAS Reports in R: The REPORTER Package David J. Bosak 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
WUSS 2024 Developing a SAS Macro for ISNI: Assessing Missing Data Sensitivity Beyond MAR Assumptions Bocheng Jing,
L. Grisell Diaz-Ramirez,
W. John Boscardin		 source 16
WUSS 2024 Fifty Shades of SAS Programming, or 53 (+3) Syntax Snippets for a Table Look-up Task, or How to Learn SAS by Solving Only One Exercise! Bartosz Jabłoński,
Quentin McMullen		 source 50
WUSS 2024 It's All About the Base-Procedures Jane Eslinger source 20
WUSS 2024 Statistical Programmers Role for SPM Analysis Marckenley Mercie,
Ce (Colin) Zhou		 source 11
WUSS 2024 Time Since Last Dose: Anatomy of a SQL Query Derek P. Morgan source 12
WUSS 2024 Uniform Hashing of Arbitrary Input Into Key-Exclusive Segments Paul M. Dorfman,
Donald J. Henderson		 source 17
PharmaSUG 2024 An approach to make Data Validation and Reporting tool using R Shiny for Clinica Data Validation Madhavi Gundu,
Vivek Jayesh Mandaliya		 source 10
PharmaSUG 2024 Demystifying Incidence Rates: A Step-by-Step Guide to Adverse Event Analysis for Novice Programmers Yuting Peng,
Ruohan Wang		 source 10
PharmaSUG 2024 Enhancing Define-XML Generation: Based on SAS Programming and Pinnacle 21 Community Kevin Sun source 11
PharmaSUG 2024 Externally Yours - Adeptly Managing Data Outside Your EDC System Frank Canale source 38
PHUSE US 2024 A Data Visualisation App to Reduce Event-Based Requests Lixiao Chen,
Diana Tai		 source
poster source		 9
PHUSE US 2024 Effortless Table Generation: A SAS Macro for Streamlining Your Workflow Zhen (Laura) Li source
presentation source		 12
WUSS 2023 A Dash of SAS , a Pinch of R: Cooking up Dashboards Using Two Very Different Programming Languages Joshua J. Cook source 15
WUSS 2023 Generation of AE (Adverse Events) summary tables by worst CTC Grade utilizing SAS Ballari Sen source 14
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 Ensuring Accurate Data Linkages with Metadata Tables Yeats Ye,
Jessie Parker,
Cindy Zhang,
Cordell Golden		 source 4
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
SESUG 2023 The Best of Both Worlds: Analytics with SAS Viya and Python Peter Styliadis source 63
PharmaSUG 2023 Better CDISC Standards with Metadata Programming Sunil Kumar Gupta,
Abhishek Dabral		 source 14
PharmaSUG 2023 Using SQL Dictionaries to Research the Global Symbol Table Ronald J. Fehd source 23
PharmaSUG 2023 Validating novel maraca plots - R and SAS love story Nicole Major,
Srivathsa Ravikiran,
Monika Huhn,
Samvel Gasparyan,
Martin Karpefors		 source 17
PHUSE US 2023 Scrutinize Tables Listings Figures (TLFs) Prior to Customer Delivery Vijetha Kode source
presentation source		 6
PHUSE EU 2022 Best Practices for Automated Delivery Set-up, from Raw Data to CRT, with Methods to Standardise and Streamline Programming and Delivery Processes [presentation] Daniel Carden source
video		 21
PHUSE EU 2022 Using Python to Compile CSR Loskutov Volodymyr source
video
presentation source		 4
SESUG 2022 A Two-Staged Local Regression Based Binning Method for Weight of Evidence Transformation in Credit Scoring Models Hui Wang,
Shirong Huang,
Emma Zhou,
Erin Martin		 source 30
SESUG 2022 Calling for Backup When Your One-Alarm Becomes a Two-Alarm Fire: Developing SAS Data-Driven Concurrent Processing Models through Control Tables and Dynamic Fuzzy Logic Troy Martin Hughes source 27
SESUG 2022 Using SQL Dictionaries to Research the Global Symbol Table Ronald J. Fehd source 15
WUSS 2022 Calculating Cardinality Ratio in Two Steps Ronald J. Fehd source 23
WUSS 2022 Calling for Backup When Your One-Alarm Becomes a Two-Alarm Fire: Developing SAS Data-Driven Concurrent Processing Models through Control Tables and Dynamic Fuzzy Logic Troy Martin Hughes source 27
WUSS 2022 Explore Your Data and Avoid Surprises Dan Konkler,
Gilbert Ramos		 source 16
WUSS 2022 Time Since Last Dose: Anatomy of a SQL Query Derek P. Morgan source 12
WUSS 2022 Using Dictionary Tables to Create Dynamic Programs Jake Reeser source 9
PharmaSUG 2022 Bookmarking CRFs More Efficiently Noory Y. Kim source 6
PharmaSUG 2022 Calling for Backup When Your One-Alarm Becomes a Two-Alarm Fire: Developing SAS Data-Driven Concurrent Processing Models through Control Tables and Dynamic Fuzzy Logic Troy Martin Hughes source 27
PharmaSUG 2022 How to create BARDA Safety report for Periodic review Mrityunjay Kumar,
Dnyaneshwari Nighot,
Nitish Kumar,
Ganeshchandra Gupta		 source 5
PharmaSUG 2022 Monitoring SDTM Compliance in Data Transfers from CROs Sunil Kumar Gupta source 7
PharmaSUG 2022 Self Modifying Macro to Automatically Repeat a SAS Macro Function Chary Akmyradov source 6
PHUSE US 2022 Introducing Reporting Packages in R for TFLs [presentation] Pavan Reddy,
Thomas Kalfas		 source
video		 12
PHUSE EU 2021 SAS Coding Efficiency: Developing a Performance Mindset [presentation] Richard Paterson source
video		 21
PHUSE EU 2021 When PROC COMPARE is not enough - the fast check of variables discrepancy through thousands of observations Roman Chekhun source
video
presentation source		 7
SESUG 2021 A Macro to Utilize a Nonparametric Multiple Stream Process Quality Control Chart in SAS Austin R. Brown source 10
SESUG 2021 Identifying Data Inconsistencies with SAS Imelda C. Go source 17
SESUG 2021 NHANES Dietary Supplement component: a parallel programming project Jayanth Iyengar source 20
SESUG 2021 The reporter package: A Powerful and Easy-to-use Reporting Package for R David J. Bosak source 9
PharmaSUG 2021 Data Visualization in Real World Data (RWD) and Health Economics Outcomes Research (HEOR) using (Statistical Analysis Software) SAS Swapna Ambati source 45
PharmaSUG 2021 NHANES Dietary Supplement component: a parallel programming project Jayanth Iyengar source 20
SGF 2021 Analyzing Data Missing Due to COVID-19: From Raw Data to ADaM and Beyond Yuliia Bahatska source
presentation		 12
SGF 2021 Uniform Hashing of Arbitrary Input Into Key-Exclusive Segments Paul M. Dorfman,
Donald J. Henderson		 source
presentation		 17
PHUSE EU 2020 Building of SQL queries using macro patterns Yehor Shakh source
video
presentation source		 13
PHUSE EU 2020 Scaling up for the SQL payoff, the most efficient way to code Matt Metherell source
video
presentation source		 8
PHUSE EU 2020 TidyCDISC: An Open-source Application to Interactively Create Tables, Figures and Patient Profiles from ADaM Data [presentation] Maya Gans,
Nate Mockler		 source
video		 21
PHUSE EU 2020 Using Software Development Principles and Tools to Create an R Package for Data Analysis Optimisation [presentation] Emanuil Markov,
Svetomir Hitov		 source
video		 19
SESUG 2020 Creating Data Listings Utilizing PROC Procedures Ballari Sen source 9
SESUG 2020 NHANES Dietary Supplement component: a parallel programming project Jayanth Iyengar source 20
SESUG 2020 UFO Search (User-Friendly-Optional-Search) Kannan Deivasigamani source 11
SGF 2020 Best Practices for Effective Infographics in SAS Visual Analytics Falko Schulz source 26
SGF 2020 Best Practices in SAS Programming to Support Ever-Increasing Data Loads. John Schmitz source 15
SGF 2020 How to Make Your First Impressive Web Application with Stored Processes and a Web Browser Philip A. Mason source 20
SGF 2020 Introduction to SAS/ACCESS Interface to Google BigQuery Joel Odom source 9
SGF 2020 Like, Learn to Love SAS Like Louise S. Hadden source 7
SGF 2020 SAS and Amazon Redshift: Overview of Current Capabilities Nicolas Robert source 20
SGF 2020 Time Is on Your Side. Yes It Is. Using Base SAS to Manipulate Time Carole Jesse source 16
SGF 2020 Translating SQL to SAS and Back: Performing Basic Functions Using DATA Steps vs. PROC SQL Katie Haring source 6
SGF 2020 Work Smarter, Not Harder: Learning to Live without Your X Amit Patel,
Lewis Mitchell		 source 52
PharmaSUG 2020 'This Is Not the Date We Need. Let's Backdate': An Approach to Derive First Disease Progression Date in Solid Tumor Trials Girish Kankipati,
Boxun Zhang		 source 11
PharmaSUG 2020 Like, Learn to Love SAS Like Louise S. Hadden source 7
PharmaSUG 2020 MKADRGM: A Macro to Transform Drug-Level SDTM Data into Traceable, Regimen-Level ADaM Data Sets Sara McCallum source 34
PharmaSUG 2020 NHANES Dietary Supplement component: a parallel programming project Jayanth Iyengar source 18
PharmaSUG 2020 SAS Formats: Same Name, Different Definitions FORMAT-ters of Inconvenience Jackie Fitzpatrick source 9
PharmaSUG 2020 Sometimes SQL Really Is Better: A Beginner's Guide to SQL Coding for DATA Step Users Brett Jepson source 16
PHUSE US 2020 Automation of Quality Checks for Ongoing CSR Data Lavanya Peddibhotla,
Savithri Jajam		 source
presentation source		 9
PHUSE US 2020 Incidence Rate - Incidence Proportion Prevalence Rate and Other Related Statistics Nadiia Pukhliar source
presentation source		 7
PHUSE US 2020 Let your SDTM or ADaM SAS code update itself whenever the Specs change Joseph W. Hinson source
presentation source		 8
PHUSE EU 2019 Beyond missing data patterns: augmenting PROC MI tables with summary of imputed data Lamine Signate source
presentation source		 6
PHUSE EU 2019 Stuck in a Rut? Prakash Mistry source
poster source		 9
PHUSE EU 2019 Work Less - Do More: An Automated Approach to Define-XML Validation Kai Wanke source
presentation source		 8
SESUG 2019 Data-driven Programming Techniques using SAS Macros to Semi-automate Generation of Descriptive Tables in Healthcare Research Katie Mercaldi source 37
SESUG 2019 Discovering the Power of SAS Metadata: An Introduction to Dictionary Tables and Views Frank C. DiIorio source 16
SESUG 2019 HOW AM I DIFFERENT? Kannan Deivasigamani source 17
SESUG 2019 Like, Learn to Love SAS Like Louise S. Hadden source 7
SESUG 2019 Market Basket Analysis on Instacart Aravind Dhanabal source 16
SESUG 2019 PROC SQL for PROC SUMMARY Stalwarts Christianna S. Williams source 18
SESUG 2019 Vetting Differences Between Relational Database Definitions and Actual Data with SAS Vetting Differences source 11
SESUG 2019 When in Doubt, Shell It Out Timothy Egan source 9
MWSUG 2019 Like, Learn to Love SAS Like Louise S. Hadden 7
MWSUG 2019 The Advent of Renewable Energy Sai Teja Sagi,
Miriam McGaugh		 21
WUSS 2019 Bespoke outputs, just like everyone else's: using the SAS Macro Language to create template programs for standard presentations of your client's clinical trial data Sean-Paul A. Claypool source 9
WUSS 2019 Getting the Message Across: Cutting Run Times and Updating Databases with SAS/ACCESS Elise S. Mara source 11
WUSS 2019 Like, Learn to Love SAS Like Louise S. Hadden source 7
PharmaSUG 2019 In the Style Of David Letterman's "Top Ten" Lists, Our "Top Ten" PROC SQL Statements To Use in Your SAS Program Margie Merlino source 7
PharmaSUG 2019 It's All About the Base-Procedures Jane Eslinger source 20
PharmaSUG 2019 Making the Days Count: Counting Distinct Days in Overlapping or Disjoint Date Intervals Noory Y. Kim source 12
PharmaSUG 2019 One More Paper on Dictionary Tables and Yes, I Think it Is Worth Reading Vladlen Ivanushkin source 11
PharmaSUG 2019 Six Useful Data Tool Macros Ting Sa source 24
PharmaSUG 2019 Time Since Last Dose: Anatomy of a SQL Query Derek P. Morgan source 12
SGF 2019 A scoring algorithm to validate hashed ID linkages using SPEDIS and COMPGED Nichole Sanders source 8
SGF 2019 Anything You Can Do I Can Do Better: PROC FEDSQL VS PROC SQL Cuyler Huffman source 11
SGF 2019 Boop-Oop-A-Doop! It's Showtime with SAS on Apache Hadoop! Cecily Hoffritz source 25
SGF 2019 Choosing the Best Method for Provider Performance Issue Tracking: SAS or IBM Cognos Ana Brito Skalos,
Meghna Parthasarathy,
Mark J. Mihalyo,
Mary Doyle		 source 11
SGF 2019 Cool SQL Tricks Russell M. Lavery source 53
SGF 2019 Honey, Where Are My Grants? Tips for Creating a SAS Viya Content-Security Model Based on SAS9 Mark Dragone source 20
SGF 2019 Identifying the Most Probable Principal Psychiatric Diagnosis Using Administrative Data Qingxian Chen,
Emily Leckman-Westin		 source 16
SGF 2019 It's All About the Base-Procedures Jane Eslinger source 21
SGF 2019 Process Manager Batch Job Monitoring Pradeep Ponnusamy source 9
SGF 2019 SAS and Teradata: SEe the Advances Heather Burnette,
Greg Otto,
Salman Maher		 source 15
SGF 2019 Screen Scraping Using SAS for Healthcare Fraud Prevention and Detection Hitesh Kharbanda source 11
SGF 2019 Sometimes SQL Really Is Better: A Beginner's Guide to SQL Coding for DATA Step Users Brett Jepson source 17
PHUSE US 2019 A Macro Tool to Reduce the Size of the Regulatory Submission Dataset Venkata Madhira source
presentation source		 7
PHUSE US 2019 A SAS Macro for Variable Ratio Treatment vs. Placebo in Propensity Score Matching Punjita Baranwal,
Prashant Kulkarni		 source
presentation source		 13
PHUSE US 2019 Building SQL Scripts Using Google Sheets R and R Shiny Huiming Tu source
presentation source		 19
PHUSE EU 2018 Experiences and Strategies in Linking Real-world Data from Different Sources Berber Snoeijer source
presentation source		 6
PHUSE EU 2018 Tree Traversal: Why You Should Never Transpose in PROC SQL Jessica Whittaker-Dixon,
Will Greenway		 source
poster source		 16
SESUG 2018 ANALYSIS OF FACTORS INFLUENCING DROPOUTS IN SOPHOMORE ENROLLMENT Apoorva Chandrasekaran source 14
SESUG 2018 Graph Visualization for PROC OPTGRAPH Andrew M. Henshaw source 8
SESUG 2018 Learnin' about Churnin' (with Examples from SAS Enterprise Guide) Victoria Garcia source 6
SESUG 2018 Tips for Pulling Data from Oracle Using PROC SQL Pass-Through John J. Cohen source 10
MWSUG 2018 A Macro that Can Get the Geo Coding Information from the Google Map API Ting Sa 6
MWSUG 2018 Data-Driven Data Analysis Jack N. Shoemaker 10
WUSS 2018 Advanced Programming Concepts: History of the List Processing and Cardinality Ratio Memes Ronald J. Fehd source 30
WUSS 2018 Creating BDS DERIVED parameters for a subject-level frequency summary table? Then this macro can be useful Masaki Mihaila source 4
WUSS 2018 Data-Driven Data Analysis Jack N. Shoemaker source 10
WUSS 2018 Never Cut and Paste Results Again: How to Automate Results with ODS PowerPoint, Metadata and Macros Ted D. Williams source 18
WUSS 2018 Validating User-Submitted Data Files with Base SAS Michael A. Raithel source 16
PHUSE US 2018 How To Derive Parameters At ADaM Level For Generating Yearly Interval Exposure Tables [presentation] Geetha Kesireddy source 10
PHUSE US 2018 Using the TFL Workbench for Standards Governance Hansjörg Frenzel,
Iain Humphreys		 source 9
SGF 2018 A Macro That Creates U.S. Census Tracts Keyhole Markup Language Files for Google Map Use Ting Sa source 10
SGF 2018 An Easier and Faster Way to Untranspose a Wide File Joe Matise,
Arthur S. Tabachneck,
Matthew J. Kastin,
Gerhard Svolba		 source 36
SGF 2018 Cool SQL Tricks Russell M. Lavery source 35
SGF 2018 Efficiently Join a SAS Data Set with External Database Tables Dadong Li,
Michael Cantor		 source 6
SGF 2018 Enterprise, Prepare for Analysis! Using SAS Data Management to Prepare Data for Analysis Bob Janka source 17
SGF 2018 Fuzzy Matching Programming Techniques Using SAS Software Stephen B. Sloan,
Kirk Paul Lafler		 source 24
SGF 2018 How a Code-Checking Algorithm Can Prevent Errors [presentation] Thomas Hirsch source 21
SGF 2018 Key-Independent Uniform Segmentation of Arbitrary Input Using a Hash Function Paul M. Dorfman,
Donald J. Henderson		 source 18
SGF 2018 Tools Designed to Aid in Quality Control of Administrative Data Research Projects Matthew Keller,
Katelin B. Nickel		 source 10
SGF 2018 Unleashing the Power of SAS Visual Analytics: Warranty Analytics in the Automobile Industry Prateek Kumar Singh,
Saket Shubham,
Shiv Kumar,
Paresh Peter Rodrigues		 source 16
SGF 2018 Using Information Value, Information Gain, and Gain Ratio for Detecting Two-Way Interaction Effect Alec Zhixiao Lin source 19
SGF 2018 V is for Venn Diagrams Kriss Harris,
Richann J. Watson		 source 22
SGF 2018 Validating User-Submitted Data Files with Base SAS Michael A. Raithel source 16
SGF 2018 Working Together for Public Health: Using SAS , Esri, and Tableau to Enhance Data Presentation Jennifer L. Han,
Miriam McGaugh		 source 135
SGF 2018 ZIPpy Safe Harbor De-identification Macros [presentation] Abigail Chatfield source 21
SESUG 2017 Advanced Programming Concepts: History of the List Processing and Cardinality Ratio Memes Cardinality Ratio Memes source 29
SESUG 2017 Beyond the Standard Map Alternate Methods for Visualizing Location Data Seth W. Hoffman source 10
SESUG 2017 Data movement issues: Explicit SQL Pass-Through can do the trick Kiran Venna source 8
SESUG 2017 Fuzzy Matching Programming Techniques Using SAS Software Stephen B. Sloan,
Kirk Paul Lafler		 source 25
SESUG 2017 Joining Data: Data Step Merge or SQL? Harry Droogendyk source 19
SESUG 2017 SAS/GRAPH and GfK Maps: a Subject Matter Expert Winning Combination Louise S. Hadden source 21
SESUG 2017 Statistician's secret weapon: 20 ways of detecting raw data issues Lixiang Larry Liu source 8
SCSUG 2017 Don't Fear The Network: Beat A Slow Network With Data Content Maps Michael McCarthy source 12
SCSUG 2017 Fuzzy Matching Programming Techniques Using SAS Software Kirk Paul Lafler,
Stephen B. Sloan		 source 25
SCSUG 2017 SAS vs Python - How Do They Compare? Daniel R. Bretheim source 18
PHUSE EU 2017 Data Cleaning Technique for Business Analytics: What Stats Van Do for DM Adam Korczynski source
presentation source		 16
MWSUG 2017 A Macro that can Create U.S State and U.S County KML Files Ting Sa 10
MWSUG 2017 SAS/GRAPH and GfK Maps: a Subject Matter Expert Winning Combination Louise S. Hadden 22
WUSS 2017 A Quick Look at Fuzzy Matching Programming Techniques Using SAS Software Kirk Paul Lafler,
Stephen B. Sloan		 source 25
WUSS 2017 An Intro to PROC SQL: Simple & Complex Queries Melissa Navarro source 9
WUSS 2017 Building a Member Centric World from a Transactional Data Galaxy Brian Mitchell source 3
WUSS 2017 SAS/GRAPH and GfK Maps: a Subject Matter Expert Winning Combination Louise S. Hadden source 21
PharmaSUG CN 2017 How to read RTF files into SAS dataset? Zhao Chunpeng 7
PharmaSUG 2017 Important and Valuable Things You Can Do with SAS Metadata DICTIONARY Tables and SASHELP Views Kirk Paul Lafler source 8
PharmaSUG 2017 My bag of SAS lifehacks Dmytro Hasan source 10
PharmaSUG 2017 Remove the Error: Variable length is too long for actual data Eric Larson source 9
PharmaSUG 2017 Statistician's secret weapon: 20 ways of detecting raw data issues Lixiang Larry Liu source 8
PharmaSUG 2017 Writing Efficient Queries in SAS Using PROC SQL with Teradata Mina Chen source 5
SGF 2017 A Macro that Can Search and Replace Strings in Your SAS Programs Ting Sa source
pdf		 7
SGF 2017 A Macro that Creates U.S State and County Keyhole Markup Language Files for Google Map Use Ting Sa source 10
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 Automatically Create Diagrams Showing the Structure and Performance of Your SAS Code Philip A. Mason source 17
SGF 2017 Building a Member Centric World from a Transactional Data Galaxy Brian Mitchell source 3
SGF 2017 Building Bayesian Network Classifiers Using the HPBNET Procedure Ye Liu,
Weihua Shi,
Wendy Czika		 source 19
SGF 2017 Getting Classy: A SAS Macro for CLASS Statement Automation Erica Goodrich,
Daniel Sturgeon,
Kathryn Schurr		 source
pdf		 12
SGF 2017 Jumping and Cutting: Using the Hash Object to Implement a Polygon Clipping Algorithm Seth W. Hoffman source 10
SGF 2017 Know Your Tools Before You Use Justin Jia source 16
SGF 2017 Modeling the Merchandise Return Behavior of Anonymous and Non-Anonymous Online Apparel Retail Shoppers Sunny Lam source 20
SGF 2017 Optimizing Delivery Routes with SAS Software Ben Murphy,
Bruce Bedford		 source 13
SGF 2017 Patching the Holes in SQL Systems with SAS Chris Carson source 16
SGF 2017 Quick Results with PROC SQL Kirk Paul Lafler source
zip		 20
SGF 2017 SAS/GRAPH and GfK GeoMarketing Maps: a Subject Matter Expert Winning Combination Louise S. Hadden source 21
SGF 2017 So You Think You Can Combine Data Sets? Christopher J. Bost source 23
SGF 2017 Something for Nothing? Adding Flag Variables Using Group Descriptive Statistics and PROC SQL Sunil Kumar Gupta source 8
SGF 2017 Testing the Night Away Laurent de Walick,
Bas Marsman,
Stephan Minnaert		 source 13
SGF 2017 Tracking Your SAS Licensed Product Usage Victor L. Andruskevitch source
pdf		 8
SGF 2017 Using Big Data to Visualize People Movement Using SAS Basics Stephanie R. Thompson source 11
SGF 2017 Using International Character Sets with SAS and Teradata Greg Otto,
Salman Maher,
Austin Swift		 source 14
SGF 2017 What's Love Gotta Do WITH It Jason O'Day source
pdf		 12
SGF 2017 Yet Another Lookup Method: Updatable Indexed Data Sets Jack Hamilton source 15
SCSUG 2016 Custom Excel Toolbox Michael McCarthy 10
SCSUG 2016 Hybrid recommendation system to provide suggestions based on user reviews Shanmugavel Gnanasekar,
Ravi Shankar Subramanian		 source 10
SESUG 2016 Divide & Conquer: Simple Sub-Data Sets Creation with Call Execute Dylan L. Holt source 8
SESUG 2016 Multiple Studies! DataDefinitionTracker, Made Easy! Saritha Bathi source 8
SESUG 2016 Tips for Pulling Data from Oracle Using PROC SQL Pass-Through John J. Cohen source 10
PHUSE EU 2016 Fundamental Advice to Save Time in SAS Programming Mickael Borne source
presentation source		 11
PHUSE EU 2016 QC of the aCRF Using SAS Rune Pedersen,
Niels Both		 source
presentation source		 12
MWSUG 2016 A Demonstration of Various Models Used in a Key Driver Analysis Steven M. LaLonde 17
MWSUG 2016 A Macro That Can Fix Data Length Inconsistency and Detect Data Type Inconsistency Ting Sa 7
MWSUG 2016 A Macro that can Search and Replace String in your SAS Programs Ting Sa 7
MWSUG 2016 Accessing Teradata through SAS, common pitfalls, solutions and tips Kiran Venna 8
MWSUG 2016 Automating the Process of Generating Publication Quality Regression Tables through SAS Base Programming Ji Qi 16
MWSUG 2016 Calculating Cardinality Ratio in Two Steps Ronald J. Fehd 22
MWSUG 2016 Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques Kirk Paul Lafler 20
MWSUG 2016 Hybrid recommendation system to provide suggestions based on user reviews Ravi Shankar Subramanian,
Shanmugavel Gnanasekar		 10
MWSUG 2016 SAS Automation & SAS Code Improvement (Making Codes Dynamic) Arjun Kumar Shrestha 14
MWSUG 2016 SAS/GRAPH and GfK Maps: a Subject Matter Expert Winning Combination Louise S. Hadden 14
MWSUG 2016 Solving Common PROC SQL Performance Killers when using ODBC John Schmitz 11
MWSUG 2016 Using Big Data to Visualize People Movement Using SAS Basics Stephanie R. Thompson 10
WUSS 2016 Advanced Programming Techniques with PROC SQL Kirk Paul Lafler source 20
WUSS 2016 Some Useful Macros to Make Your Data Work Easier Ting Sa source 10
WUSS 2016 Tweaking your tables: Suppressing superfluous subtotals in PROC TABULATE Steve Cavill source 8
PharmaSUG 2016 Generalized Problem-Solving Techniques for De-bugging and Diagnosing Logic Errors Brian P. Fairfield-Carter,
Tracy Sherman		 source 12
PharmaSUG 2016 Go Compare: Flagging up some underused options in PROC COMPARE Michael Auld source 14
PharmaSUG 2016 PrecMod: An Automated Precision SAS Macro for Random Effects Models Jesse Albert Canchola,
Pari Hemyari		 source 15
PharmaSUG 2016 The Benefits and Know-how of Building a Central CDISC-Terminology Dictionary with a Macro System Solomon Lee,
Ronghai Bo		 source 4
SGF 2016 A Macro That Can Fix Data Length Inconsistency and Detect Data Type Inconsistency Ting Sa source 7
SGF 2016 An Insider's Guide to SAS/ACCESS Interface to Impala Jeffrey Bailey source 19
SGF 2016 Create Web-Based SAS Reports Without Having to Be a Web Developer Kris Kiser,
Christie Corcoran,
Marie Dexter,
Amy Peters		 source 15
SGF 2016 Finding the One: Using SAS Code and SAS Data Quality Server to Create a Matched Record Elena Shtern,
Kim Hare		 source 25
SGF 2016 From SAS Data Management to Big Data Appliances: How SAS/ACCESS Makes Life Easier Magali Thesias source
presentation		 13
SGF 2016 Have it Your Way: Creating Reports with the DATA Step Report Writing Interface Peter J. Lund source 27
SGF 2016 High-Performance Data Access with FedSQL and DS2 Shaun Kaufmann source 13
SGF 2016 How to Leverage the Hadoop Distributed File System as a Storage Format for the SAS Scalable Performance Data Server and SAS Scalable Performance Data Engine Steven Sober source 19
SGF 2016 Improve Your Business through Process Mining Emily Y. Gao,
Robert Chu,
Xudong Sun		 source 17
SGF 2016 Mastering Data Summarization with PROC SQL Christianna S. Williams source 20
SGF 2016 Missing Values: They Are NOT Nothing Justin Jia,
Shan Shan Lin		 source 19
SGF 2016 Performing Efficient Wide-to-Long Transposes on Teradata Tables Using SAS Explicit Pass-Through Tao Cheng source 13
SGF 2016 PROC SQL for SQL Die-hards Barbara Ross,
Mary Jessica Bennett		 source 9
SGF 2016 Ten Tips to Unlock the Power of Hadoop with SAS Nancy A. Rausch,
Wilbram Hazejager		 source 12
SGF 2016 Uncommon Techniques for Common Variables Christopher J. Bost source 10
SCSUG 2015 Coding Tips from Too Many Years of Programming Jimmy A. DeFoor source 17
SCSUG 2015 Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques Kirk Paul Lafler source 20
SCSUG 2015 Reassigning Character/Numeric Variables length across multiple datasets for Efficiency and Consistency Srinivas Vanam,
Phaneendhar Reddy Vanam,
Mahipal Vanam		 source 12
MWSUG 2015 Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques Kirk Paul Lafler 20
MWSUG 2015 Leveraging Hadoop from the Comfort of SAS Emily Hawkins,
Lal Puthenveedu Rajanpillai		 9
MWSUG 2015 Need Help Finding Something? Why Not Ask Your (Virtual) Community! A Collaborative Filtering Based Recommendation Engine in SAS Ben Elbert 12
PHUSE EU 2015 Dynamic, Powerful, User-friendly SQL Joins Made Easy with %VARLIST, a Generic SAS Macro Function Jean-Michel Bodart source
presentation source		 8
PHUSE EU 2015 How a Clinical Data Repository can Support Pharmacovigilance Panteleo Nacci source
presentation source		 7
PHUSE EU 2015 SQL by Example: A Comparative Introduction to PROC SQL Jeanina M. Worden source
presentation source		 7
SESUG 2015 A macro to copy, rename, update and move your SAS programs - all in one click Julio Ruiz source 10
SESUG 2015 Application Development Techniques Using PROC SQL Kirk Paul Lafler source 20
SESUG 2015 Applications Design and Development, a case study of the EDA Summarize-Each-Variable Suite Ronald J. Fehd source 22
SESUG 2015 Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques Kirk Paul Lafler source 20
SESUG 2015 Hash: Is it Always the Best Solution? David Izrael,
Elizabeth Axelrod		 source 12
SESUG 2015 PROC RANK, PROC SQL, PROC FORMAT and PROC GMAP Team Up and a (Map) Legend is Born! Christianna S. Williams,
Louise S. Hadden		 source 20
SESUG 2015 Reporting of treatment emergent adverse events based on pooled data Analysis or Country Specific Submissions: A case study Sheetal Shiralkar source 8
WUSS 2015 Standardizing the Standardization Process Frank A. Ferriola,
Avery Long		 source 12
WUSS 2015 You Say 'Day-ta', I Say 'Dat-a' - Measuring Coding Differences, Considering Integrity and Transferring Data Quickly Mary Federico Katz,
Jason R. Beene		 source 13
PharmaSUG 2015 Application Development Techniques Using PROC SQL Kirk Paul Lafler source 20
PharmaSUG 2015 Mlibcompare - keep an eye on the changes of your data Wen Shi source 29
PharmaSUG 2015 PROC SQL for SQL Die-hards Mary Jessica Bennett,
Barbara Ross		 source 7
PharmaSUG 2015 Team-work and Forensic Programming: Essential Foundations of Indestructible Projects Brian P. Fairfield-Carter source 14
SGF 2015 A Mathematical Model for Optimizing Product Mix and Customer Lifetime Value Atul Thatte,
Goutam Chakraborty		 source
zip		 16
SGF 2015 Alien Nation: Text Analysis of UFO Sightings in the US Using SAS Enterprise Miner 13.1 Pradeep Reddy Kalakota,
Naresh Abburi,
Goutam Chakraborty,
Zabiulla Mohammed		 source
zip		 14
SGF 2015 Data Management Techniques for Complex Healthcare Data Gabriela Cantu,
Christopher Klekar		 source 14
SGF 2015 Data Summarization for a Dissertation: A Grad Student How-To Paper Elisa L. Priest,
Ashley Collinsworth		 source 8
SGF 2015 Examination of Three SAS Tools for Solving a Complicated Data Summary Problem Carry W. Croghan source 12
SGF 2015 How Do You Use Look-up Tables? Philip R. Holland source 10
SGF 2015 Nifty Uses of SQL Reflexive Join and Subquery in SAS Cynthia Trinidad source 5
SGF 2015 Performing Efficient Transposes on Large Teradata Tables Using SQL Explicit Pass-Through Tao Cheng source 17
SGF 2015 PROC RANK, PROC SQL, PROC FORMAT and PROC GMAP Team Up and a (Map) Legend is Born! Christianna S. Williams,
Louise S. Hadden		 source 20
SGF 2015 PROC SQL for PROC SUMMARY Stalwarts Christianna S. Williams source 19
SGF 2015 Something for Nothing? Adding Group Descriptive Statistics Using SAS PROC SQL Subqueries II Sunil Kumar Gupta source 10
SGF 2015 Standardizing the Standardization Process Avery Long,
Frank A. Ferriola		 source 13
SGF 2015 What's New in SAS Studio? Mike Porter,
Michael Monaco,
Amy Peters		 source 12
SGF 2015 You Say 'Day-ta', I Say 'Dat-a' - Measuring Coding Differences, Considering Integrity and Transferring Data Quickly Jason R. Beene,
Mary Federico Katz		 source 14
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 Expanding the Use of Weight of Evidence and Information Value to Continuous Dependent Variables for Variable Reduction and Scorecard Development Alec Zhixiao Lin,
Tung-Ying Hsieh		 23
SESUG 2014 PROC SQL for PROC SUMMARY Stalwarts Christianna S. Williams source 18
MWSUG 2014 A SAS Macro Using Parallel Genetic Algorithm to Automate Variable Selection Jinqiao Li,
Yi Cao,
Yanping Shen		 19
MWSUG 2014 Five Little Known, But Highly Valuable and Widely Usable, PROC SQL Programming Techniques Kirk Paul Lafler 20
MWSUG 2014 Jack of all Listings, A New Approach for Review of Clinical Data Hardik Panchal 15
MWSUG 2014 PROC SQL for DATA Step Die-Hards Christianna S. Williams 22
MWSUG 2014 SAS 101 For Newbies--Not Too Little, Not Too Much--Just Right Ira Shapiro 42
MWSUG 2014 SAS and Relational Databases: What You Should Know Before You Code Patricia Hettinger 15
MWSUG 2014 SAS Graphs with Multiple Y Axes - Some Useful Tips and Tricks Soma Ghosh 16
MWSUG 2014 SAS PASSTHRU to Microsoft SQL Server using ODBC Nina L. Werner 6
WUSS 2014 Different Ways of Calculating Percentiles Using SAS Arun Akkinapalli source 5
WUSS 2014 How can I simplify ETL when I only have Base SAS Steve Cavill source 15
WUSS 2014 Reassigning character variable lengths across multiple datasets for Efficiency and Consistency Srinivas Vanam,
Phaneendhar Reddy Vanam,
Mahipal Vanam		 source 7
WUSS 2014 Using SAS to do it all Chelsea Lofland,
Rebecca Ottesen		 source 16
WUSS 2014 You Say 'Day-ta', I Say 'Dat-a' - Processing Your DATA Efficiently and Ensuring Its Integrity Mary Federico Katz,
Jason R. Beene		 source 12
PharmaSUG 2014 A SAS Macro Tool for Visualizing Data Comparison Results in an Intuitive Way Hui Wang,
Weizhen Ying		 source 12
PharmaSUG 2014 An Alternative Way to Detect Invalid Reference Records in Supplemental Domains Steven Wang source 5
PharmaSUG 2014 Creating Define-XML version 2 with the SAS Clinical Standards Toolkit 1.6 Lex Jansen source 33
PharmaSUG 2014 D is for Dynamic, putting Dynamic back into CDISC (A simple macro utilizing PROC SQL which auto-formats continuous variables for lab tables) Steven C. Black source 9
PharmaSUG 2014 Efficient SQL for Pharma ... and Other Industries Christopher R. Olinger source 15
PharmaSUG 2014 Principles of Writing Readable SQL Kenneth W. Borowiak source 9
PharmaSUG 2014 Using the Power of SAS SQL Jessica Wang source 14
SGF 2014 Automatically Convert All Numeric Data Stored As Character to True Numeric Data Andrea Wainwright-Zimmerman source 8
SGF 2014 Creating a Journal-Ready Group Comparison Table in Microsoft Word with SAS [presentation] Alan C. Elliott source 3
SGF 2014 Exploring DATA Step Merges and PROC SQL Joins Kirk Paul Lafler source 14
SGF 2014 From Traffic to Twitter--Exploring Networks with SAS Visual Analytics Falko Schulz,
Nascif Abousalh-Neto		 source 32
SGF 2014 Getting the Warm and Fuzzy Feeling with Inexact Matching Toby Dunn source 20
SGF 2014 Have it Your Way: Creating Reports with the DATA Step Report Writing Interface Peter J. Lund source 27
SGF 2014 Integrating and Using Hierarchical Vocabularies in SAS Glenn Colby source 22
SGF 2014 SAS Format Optimization: SAS_PUT or UNPUT (Who's On First?) David Wiehle source 19
SGF 2014 Using Metadata-Bound Libraries to Authorize Access to SAS Data Jack Wallace source 14
SGF 2014 What's on My Mainframe? A Macro That Gives You a Solid Overview of Your SAS Data on z/OS Jesper Michelsen source 7
WUSS 2013 Access to Relational Databases Using SAS Frederick E. Pratter source 10
WUSS 2013 Implementation of DEFINE.XML Generators using SAS Hash Objects and User-Defined Functions Lei Zhang source 19
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
SESUG 2013 Coding For the Long Haul With Managed Metadata and Process Parameters Mike Molter source 20
SESUG 2013 Same Data Different Attributes: Cloning Issues with Data Sets Brian K. Varney,
Experis Business		 source 8
SESUG 2013 The Power of Combining Data with the PROC SQL Stacey Slone source 6
PHUSE EU 2013 Anatomy of an Epidemiology Study Paul Murray source
presentation source		 12
PHUSE EU 2013 EXACT - A Metadata Driven System for Creating Standard Mockups and Data Displays [presentation] Kent Letourneau source 55
PHUSE EU 2013 What's in it? SAS Arrays to Check Efficiently for Emptiness of Variables and Datasets [presentation] Guillaume Godin source 35
MWSUG 2013 Building a Dynamic SAS HTML Report with JavaScript and SAS Tagsets Mike Libassi 7
MWSUG 2013 Creation and Implementation of an Analytic Dataset for a Multi-Site Surveillance Study using Electronic Health Records (EHR) and Medical Claims Data Renuka Adibhatla,
Gabriela VazquezBenitez,
Mary Becker,
Amy Butani		 11
MWSUG 2013 Same Data Different Attributes: Cloning Issues with Data Sets Brian K. Varney 8
MWSUG 2013 Using SAS in Clinical Programming Project Management from Excel Spreadsheets Jean Crain 13
NESUG 2013 Continuous Enrollment Requirements in Epidemiologic Studies Jennifer R. Popovic 12
NESUG 2013 Marketing and Granger Causality: Going Beyond Correlation Jonathan Prantner 11
NESUG 2013 Quick Results with PROC SQL Kirk Paul Lafler 17
PharmaSUG 2013 A Closer Look at PROC SQL's FEEDBACK Option Kenneth W. Borowiak source 7
PharmaSUG 2013 Access to Relational Databases Using SAS Frederick E. Pratter source 10
PharmaSUG 2013 Coding For the Long Haul With Managed Metadata and Process Parameters Mike Molter source 20
PharmaSUG 2013 Communication of Statistical Findings by Tables and Graphs Howard Liang source 12
PharmaSUG 2013 Efficient Statistical Review Using the ExcelXP Tagset Bradford J. Danner source 5
PharmaSUG 2013 Quick Results with PROC SQL Kirk Paul Lafler source 17
PharmaSUG 2013 SQL Subqueries: Usage in Clinical Programming Sri Pavan Vemuri source 7
SGF 2013 A Case Application of Propensity Score Matching in MTM Outcomes Evaluation at Retail Pharmacy Michael Taitel,
Youbei Lou,
Zhongwen Huang		 source
pdf		 11
SGF 2013 A Day in the Life of Data - Part 2 Harry Droogendyk source 13
SGF 2013 Data Merging and Visualization to Identify Associations Between Environmental Factors and Disease Outbreaks Azhar Nizam,
Neeta Shenvi,
Xin Zhang		 source 12
SGF 2013 Developing Your SDTM Programming Toolkit David A. Scocca source 10
SGF 2013 Have it Your Way: Creating Reports with the DATA Step Report Writing Interface Peter J. Lund source 27
SGF 2013 How to Automate Security Filters for SAS OLAP Cubes Using Users Groups Information Available in SAS Management Console Plinio Faria source 5
SGF 2013 Knowing Me, Knowing My UI (ah-haa): Understanding SAS 9.3 and SAS 9.4 Desktop and Web Client Application Usage Within Your Organization Edoardo Riva,
Simon Williams		 source 15
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 Something for Nothing? Adding Group Descriptive Statistics Using PROC SQL Subqueries Sunil Kumar Gupta source 8
NESUG 2012 Applying Customer Attitudinal Segmentation to Improve Marketing Campaigns Wenhong Wang,
Mark Antiel		 10
NESUG 2012 Automatically Generating SAS Code from Client Specifications Stanley E. Legum 14
NESUG 2012 K-Nearest Neighbor Classification and Regression in SAS Liang Xie 16
NESUG 2012 PROC SQL for DATA Step Die-Hards Christianna S. Williams 20
NESUG 2012 Quick Results with PROC SQL Kirk Paul Lafler 17
PHUSE EU 2012 Designing Co-Medication Matrices Using a Burt Table Principal Berber Snoejer source
presentation source		 4
SESUG 2012 A Closer Look at PROC SQL's FEEDBACK Option Kenneth W. Borowiak source 7
SESUG 2012 A SAS macro to compute effect size (Cohen's d) and its confidence interval from raw survey data Rajendra P source 12
SESUG 2012 A Standard SAS Program for Corroborating OpenCDISC Error Messages John R. Gerlach source 11
SESUG 2012 K-Nearest Neighbor Classification and Regression using SAS Liang Xie source 16
SESUG 2012 Learning PROC SQL the DATA Step Way Meghal Parikh source 8
SESUG 2012 Leveraging SQL Return Codes When Querying Relational Databases John E. Bentley source 9
SESUG 2012 The SDTM Programming Toolkit David A. Scocca source 10
MWSUG 2012 A Simple Solution for Generating Two Sets of Similar Reports Lion Li,
Zheng Wang,
Yanhong Li		 6
MWSUG 2012 Get SASsy with PROC SQL Amie Bissonett 12
MWSUG 2012 Making it Add Up; Diagnosing Merge Issues Using PROC SQL and Simple Arithmetic Eric Schreiber 6
WUSS 2012 Metadata, Macros, and Documenting SAS Programs Patrick Thornton source 5
WUSS 2012 Using SAS to calculate incidence and prevalence rates in a dynamic population Li-Hao Chu,
Fagen Xie		 source 8
PharmaSUG 2012 A Standard SAS Program for Corroborating OpenCDISC Error Messages John R. Gerlach,
Ganesh Sankaran Thangavel		 source 12
PharmaSUG 2012 Comparing Datasets: Using PROC COMPARE and Other Helpful Tools Deb Cassidy source 9
PharmaSUG 2012 EXACTing a Price: Compute Fisher-s Exact Test P-values Only When Needed Robert D. Abelson source 6
PharmaSUG 2012 Exploring DATA Step Merges and PROC SQL Joins Kirk Paul Lafler source 14
PharmaSUG 2012 Get SASsy with PROC SQL Amie Bissonett source 12
PharmaSUG 2012 Need a hand to locate your variables in an entire library? Ying Guo source 5
PharmaSUG 2012 Quick Data Definitions Using SQL, REPORT and PRINT Procedures Bradford J. Danner source 5
SGF 2012 A Standard SAS Program for Corroborating OpenCDISC Error Messages John R. Gerlach,
Ganesh Sankaran Thangavel		 source 12
SGF 2012 Combine Data Sets Using Inexact Character Variables in SAS Kulwant Rai source 12
SGF 2012 Exploring DATA Step Merges and PROC SQL Joins Kirk Paul Lafler source 14
SGF 2012 Finding Your Inner Query with SAS Enterprise Guide Michael R. Burke,
I-Kong B. Fu		 source 40
SGF 2012 Optimized 1:N Case-Control Match Using SAS Zhiwei Wang source 5
SGF 2012 Optimizing That Which cannot be optimized. Superfast SAS 9.2 + Searches and Fuzzy Linkage of Large Data Sets Sigurd W. Hermansen source 7
SGF 2012 SAS Solutions Make HEDIS Measures Programming Easier Qingfeng Liang source 9
SGF 2012 Selecting All Observations When Any Observation Is of Interest Christopher J. Bost source 5
SGF 2012 What's New in SAS Data Management Nancy A. Rausch,
Michael Ames,
Wilbram Hazejager		 source 13
SGF 2012 What's New in SAS/ACCESS and Process Improvements That You Apply to Your DBMS Howard Plemmons Jr.,
Michael Ames		 source 14
SCSUG 2011 They're Closing Down the Office in Kalamazoo and You've Been Tapped to Run Their In-house "Production" Reporting System, OH MY! David Welch source 15
SESUG 2011 Assign Overpayment to Insurance Data with Adjustments Assign Overpayment source 5
SESUG 2011 Misquoting Jane Austen in the Name of Quality Assurance Deborah Posner source 11
SESUG 2011 Practical Approaches to Counting in SAS: How to Get Started When You Don't Know Where to Begin Sharon Avrunin-Becker source 5
SESUG 2011 The SAS Magical Dictionary Tour Linda Libeg source 12
WUSS 2011 %GetTweet: A New SAS Macro to Fetch and Summarize Tweets Satish Garla source 12
WUSS 2011 A SAS Macro Program to Calculate Medication Adherence Rate for Single and Multiple Medication Use Hao Chu source 11
WUSS 2011 Macro Tabulating Missing Values, Leveraging SAS PROC CONTENTS Adam Chow source 9
WUSS 2011 Powerful and "Sometimes" Hard-to-find PROC SQL Features Kirk Paul Lafler source 17
WUSS 2011 Probabilistic Record Linkage in SAS Glenn Wright source 13
WUSS 2011 Quick Results with PROC SQL Kirk Paul Lafler source 17
WUSS 2011 VBA Microsoft Access 2007 Macros to Import Formats and Labels to SAS Maria Melguizo Castro source 10
PHUSE EU 2011 Different Methods of Calculating Body Sway Area Thomas Wollseifen source
presentation source		 24
PHUSE EU 2011 Go Compare: Flagging up some underused options in PROC COMPARE Michael Auld source
presentation source		 13
PHUSE EU 2011 Implementing ADaM Using the SAS Clinical Standards Toolkit Gene Lightfoot source
presentation source		 12
PHUSE EU 2011 Many too many, too many performance tests Christoph Baumer source 13
MWSUG 2011 Evaluation of Novel Markers in Risk Prediction Kevin F. Kennedy 14
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
MWSUG 2011 SAS and Code Lists from Genericode Larry Hoyle 18
NESUG 2011 Combining the Results from Multiple SAS PROCs into a Publication Quality Table Robert Kabacoff 20
NESUG 2011 PROC SQL for DATA Step Die-Hards Christianna S. Williams 22
NESUG 2011 Selecting All Observations When Any Observation Is of Interest Christopher J. Bost 6
NESUG 2011 SQL Pass-Through and the ODBC Interface Jessica R. Hampton 8
NESUG 2011 Techniques for Reading DB2 Data Steven H. Feder 15
NESUG 2011 Using SQL joins to Perform Fuzzy Matches on Multiple Identifiers Jedediah J. Teres 6
PharmaSUG 2011 Array of hope: Using SAS Arrays to produce data-driven analysis and reports Aida Likaj source 4
PharmaSUG 2011 Powerful and "Sometimes" Hard-to-find PROC SQL Features Kirk Paul Lafler source 17
PharmaSUG 2011 Resolving OpenCDISC Error Messages Using SAS Virginia Redner,
John R. Gerlach		 source 10
SGF 2011 %GetTweet: A New SAS Macro to Fetch and Summarize Tweets Satish Garla,
Goutam Chakraborty		 source 12
SGF 2011 Building Match Code Using SAS David Li source 9
SGF 2011 Detail Forms with SAS Stored Procedures David P. Wells source 4
SGF 2011 Eliminating Redundant Custom Formats Philip A. Wright source 8
SGF 2011 Explicit SQL Pass-Through: Is It Still Useful? Frank Capobianco source 5
SGF 2011 Teradata Parallel Transporter: Loading Your SAS Data Just Became Easier Jeffrey Bailey source 16
SGF 2011 To FREQ, Perchance to MEANS Christopher J. Bost source 10
NESUG 2010 # or ## - how to reference SQL server temporary tables Xiaoqiang Wang 8
NESUG 2010 %whatChanged: A Tool for the Well-Behaved Macro Frank C. DiIorio 14
NESUG 2010 Misquoting Jane Austen in the Name of Quality Assurance Deborah Posner 12
NESUG 2010 Passing date ranges to Oracle made simple using SAS picture formats Santosh Kothamasu,
Jonas V. Bilenas		 3
NESUG 2010 PROC SQL: Tips and Translations Gail Jorgensen,
Susan P. Marcella		 23
NESUG 2010 Quality Control: How to Analyze and Verify Financial Data Michelle M. Duan 5
NESUG 2010 To FREQ, Perchance to MEANS Christopher J. Bost 11
NESUG 2010 TRACKING DATASET DEPENDENCIES IN CLINICAL TRIALS REPORTING Binoy Varghese,
Satyanarayana Mogallapu		 10
NESUG 2010 Using SAS Enterprise Guide to Create Standalone Programs Michael Todd 10
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
SCSUG 2010 Exploring DATA Step Merges and PROC SQL Joins Kirk Paul Lafler source 11
WUSS 2010 Application of DICTIONARY Tables and SASHELP Views Kirk Paul Lafler source 9
WUSS 2010 Normalized Editchecks Automated Tracking (N.E.A.T.) Frank Fan source 11
PHUSE EU 2010 Accessing the metadata from the define.xml using XSLT transformations Lex Jansen source
presentation 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 Choosing the Right Tool from Your SAS and Microsoft Excel Tool Belt Jennifer F. First,
Steven J. First		 18
MWSUG 2010 DATA Step and PROC SQL Programming Techniques Kirk Paul Lafler 14
MWSUG 2010 Eliminating Redundant Custom Formats (or How to Really Take Advantage of PROC SQL, PROC CATALOG, and the DATA Step) Philip A. Wright 8
MWSUG 2010 Hard-to-find, But Powerful, PROC SQL Features Kirk Paul Lafler 17
MWSUG 2010 Plotting Summary ROC Curves from Multiple Raters Using the SmryROCPlot Macro Matthew T. Karafa,
Nancy Obuchowski		 10
MWSUG 2010 Stuff We All Do: Mistakes We've Made That You Won't Have To Joe Novotny,
Michael P.D. Bramley		 13
MWSUG 2010 Using PROC SQL to Build and Incrementally Update That Data Mart Ben Cochran 6
SESUG 2010 %whatChanged: A Tool for the Well-Behaved Macro Frank C. DiIorio source 14
SESUG 2010 A SAS Macro to Compute Added Predictive Ability of New Markers Predicting a Dichotomous Outcome Kevin F. Kennedy,
Michael J. Pencina		 source 13
SESUG 2010 How To Use Proc SQL select into for List Processing Ronald J. Fehd source 40
SESUG 2010 Using DICTIONARY Views to Eliminate Tedious Visual Review Christine Davies source 7
PharmaSUG 2010 %whatChanged: A Tool for the Well-Behaved Macro Frank C. DiIorio 14
PharmaSUG 2010 Accessing the metadata from the define.xml using XSLT transformations Lex Jansen 24
PharmaSUG 2010 Automating the Process of Creating the Contents of Data Definition Document David L. Wang 10
PharmaSUG 2010 Missing Pages Report David Gray,
Zhuo Chen		 10
PharmaSUG 2010 The Interaction Between the SYNTAXCHECK and OBS= System Options During Batch Unix Sessions Robert Adams 4
PharmaSUG 2010 The SE Domain as Treatment Data Store: Using the SDTM Subject Elements (SE) domain to drive analyzing treatment Jeremy Gratt 10
PharmaSUG 2010 The Super Genius Guide to Generating Dummy Data Brian K. Varney 10
PharmaSUG 2010 Using the SAS Clinical Standards Toolkit to Validate CDISC SDTM Data [presentation] Gene Lightfoot,
Bill J. Gibson		 33
SGF 2010 Choosing the Right Tool from Your SAS and Microsoft Excel Tool Belt Jennifer F. First,
Steven J. First		 source 18
SGF 2010 Complex Data Combinations on Large Volumes: How to Get the Best Performance Henri Theuwissen source 22
SGF 2010 Data in Your Inbox? Use It! Douglas B. Liming source 7
SGF 2010 Eliminating Redundant Custom Formats (or How to Really Take Advantage of PROC SQL, PROC CATALOG, and the DATA Step) Philip A. Wright source 18
SGF 2010 Exploring Powerful Features in PROC SQL Kirk Paul Lafler source 17
SGF 2010 Investigating the Impact of Medicare Part D on Diabetes Medications Using SAS Enterprise Miner and Survival Analysis Xiao Wang source 13
SGF 2010 Look What's New in SAS/ACCESS: New Engines and SQL Optimization Howard Plemmons Jr. source 16
SGF 2010 ROC Hard? No, ROC Made Easy! Kriss Harris source 12
SGF 2010 Using the SQL Procedure to Summarize and Transpose Data Kevin Chung source 8
SCSUG 2009 A Propaedeutics for PROC SQL Joins Toby Dunn,
Lisa A. Mendez		 9
SCSUG 2009 Dear Ms. SAS Answers: A Guide to Efficient PROC SQL Coding Linda T. Jolley,
Jane Stroupe		 14
SESUG 2009 A Hands-on Tour Inside the World of PROC SQL Kirk Paul Lafler source 17
SESUG 2009 DATA Step versus PROC SQL Programming Techniques Kirk Paul Lafler source 14
SESUG 2009 Exchanging data between SAS and Microsoft Excel Yuqing Xiao source 8
SESUG 2009 List Processing Basics: Creating and Using Lists of Macro Variables Arthur L. Carpenter source 20
SESUG 2009 SAS and Clinical IVRS: Beyond Schedule Creation Gayle Flynn source 10
PHUSE EU 2009 Accessing SAS metadata and using it to help us develop data-driven SAS programs Iain Humphreys source 16
MWSUG 2009 Dear Miss SASAnswers: A Guide to Efficient PROC SQL Coding Jane Stroupe,
Linda T. Jolley		 14
MWSUG 2009 Eliminating Redundant Custom Formats (or How to Really Take Advantage of PROC SQL, PROC CATALOG, and the DATA Step) Philip A. Wright 18
MWSUG 2009 Exploring DATA Step and PROC SQL Programming Techniques Kirk Paul Lafler 14
MWSUG 2009 List Processing Basics: Creating and Using Lists of Macro Variables Ronald J. Fehd,
Arthur L. Carpenter		 21
MWSUG 2009 Using SAS as an Archival Repository for DB2 under z/OS (or other DBMS) Rich Morris 22
PNWSUG 2009 DATA Step versus PROC SQL Programming Techniques Kirk Paul Lafler 14
PNWSUG 2009 List Processing Basics: Creating and Using Lists of Macro Variables Ronald J. Fehd,
Arthur L. Carpenter		 20
NESUG 2009 A Closer Look at PROC SQL's FEEDBACK Option Kenneth W. Borowiak 7
NESUG 2009 Analyzing MCBS Data with PROC SURVEYFREQ: The Maybe Cheesy but Simple Approach Christine E. Leonard 19
NESUG 2009 Good Programming Practices in SAS Jason L. Ford 9
NESUG 2009 PROC SQL for DATA Step Die-Hards Christianna S. Williams 19
NESUG 2009 PROC SQL Tips and Techniques Gail Jorgensen,
Susan P. Marcella		 23
NESUG 2009 SAS Graphs in Small Multiples Andrea Wainwright-Zimmerman 12
NESUG 2009 Using DATA STEP MERGE and PROC SQL JOIN to Combine SAS Datasets Dalia C. Kahane 15
NESUG 2009 Using SAS to Handle HL7 Messages in A Health Information Exchange Enxu Zhao,
Kathryn J. Schmit,
Linh H. Le		 13
NESUG 2009 Using SQL Joins to Perform Weighted Matches on Multiple Identifiers Jedediah J. Teres 8
WUSS 2009 Base SAS Tips, Tricks and Techniques Kirk Paul Lafler source 14
WUSS 2009 Capturing and Presenting PROC TTEST Results Using ODS and PROC REPORT Patrick Thornton source 7
WUSS 2009 Fast Solution for Identifying and Quantifying Gaps in Messy Time Segments Lorne M. Salter source 7
WUSS 2009 No, It's Not Magic: De-mystifying the SAS Macro Facility Jay A. Jaffe source 15
WUSS 2009 Working with SAS on a Remote UNIX Server from a Local Windows Alex Zolot source 6
PharmaSUG 2009 A SAS Macro for Creating Adverse Event Analysis Dataset Daniel Li,
Suwen Li,
Stephanie Sproule		 10
PharmaSUG 2009 Inline Formatting with ODS Markup Eric A. Gebhart 12
SGF 2009 Avoiding Common Traps When Accessing RDBMS Data Michael D. Rhoads source 12
SGF 2009 Building Drill-Down Capabilities Dynamically in SAS Output Using Base SAS Mark Beardsley,
Barbara Kolln,
Ronald Palanca,
Hong (Lily) Zhang		 source 13
SGF 2009 Inline Formatting with ODS Markup Eric A. Gebhart source 12
SGF 2009 MERGING vs. JOINING: Comparing the DATA Step with SQL Malachy J. Foley source 17
SGF 2009 New Language Features in SAS 9.2 for the Global Enterprise Manfred Kiefer source 12
SGF 2009 SAS Graphs in Small Multiples Andrea Wainwright-Zimmerman source 12
SGF 2009 SAS in Financial Research: Embracing Data Taras Zlupko source 8
SGF 2009 Simple Applications of SQL Howard L. Schreier source 17
SGF 2009 Time Travel: How to Easily Create, Loop Through and Manipulate Data with Names Containing YYYYMM Jingjing Shan source 14
SGF 2009 Visualizing Two Social Networks Across Time with SAS: Collaborators on a Research Grant vs. Those Posting on SAS-L Larry Hoyle source 11
WUSS 2008 A Hands-on Tour Inside the World of PROC SQL Kirk Paul Lafler source 17
WUSS 2008 Getting SAS to Play Nice With Others: Connecting SAS to Microsoft SQL Server Candice Miller source 6
WUSS 2008 List Processing Basics: Creating and Using Lists of Macro Variables Ronald J. Fehd,
Arthur L. Carpenter		 source 20
WUSS 2008 New SAS Performance Optimizations to Enhance Your SAS Client and Solution Access to the Database Mike Whitcher source 15
WUSS 2008 Teaching a New Dog Old Tricks - Using the EXCEPT Operator in PROC SQL and Generation Data Sets to Produce a Comparison Report Stanley E. Fogleman source 3
SESUG 2008 An Added Dimension: Exploring OLAP Cubes with SAS Enterprise Guide Rupinder Dhillon source 16
SESUG 2008 An Approach for Deriving a Timing Variable in SDTM Standards Shaoan Yu,
Joyce Gui		 source 9
SESUG 2008 Joins: How to Put it All Together Janet E. Stuelpner source 10
SESUG 2008 New SAS Performance Optimizations to Enhance Your SAS Client and Solution Access to the Database Mike Whitcher source 15
SESUG 2008 PROC SQL for DATA Step Die-Hards Christianna S. Williams source 17
SESUG 2008 SAS Graphs in Small Multiples Andrea Wainwright-Zimmerman source 12
SESUG 2008 Tying it Together: Using ODS to Insert EXCEL Hyperlinks James E. Snider source 5
SESUG 2008 Undocumented and Hard-to-find PROC SQL Features Kirk Paul Lafler source 17
PHUSE EU 2008 Automated table generation: The macro SAS %GEEWHIZ Guido Wendland source 12
PHUSE EU 2008 Creating adverse event tables using PROC SQL Berber Snoeijer source 4
PHUSE EU 2008 Enriching decision making through data integration: Creating a project database (PDb) Jennifer Lomax,
Nicki Noble		 source 4
PHUSE EU 2008 Just Using ODS Tables - PROC REPORT not needed! Philip R. Holland source 10
MWSUG 2008 New SAS Performance Optimizations to Enhance Your SAS Client and Solution Access to the Database Mike Whitcher 15
PNWSUG 2008 List Processing Basics: Creating and Using Lists of Macro Variables Ronald J. Fehd,
Arthur L. Carpenter		 20
NESUG 2008 A Hands-on Tour Inside the World of PROC SQL Kirk Paul Lafler 17
NESUG 2008 Avoiding Common Traps When Accessing RDBMS Data Michael D. Rhoads 11
NESUG 2008 Effective Use of SQL in SAS Programming Yi Zhao 8
NESUG 2008 Get Your Hands Dirty Cleaning Your Data with SAS Data Quality Server Faron Kincheloe 17
NESUG 2008 Multiple Adverse Event Tables without Surgical Intervention Adel Fahmy,
Carol Matthews		 11
NESUG 2008 Using DATA STEP MERGE and PROC SQL JOIN to Combine SAS Datasets Dalia C. Kahane 15
PharmaSUG 2008 Automatic Creation of a Makefile for Clinical Trial Vikas Gaddu 8
PharmaSUG 2008 EZTABLE Macros Daniel Huang 12
PharmaSUG 2008 From Soup to Nuts: Practices in Data Management for Analytical Performance David R. Duling 25
PharmaSUG 2008 Join, Merge or Lookup? Expanding your toolkit Judy Loren,
Sandeep Gaudana		 16
PharmaSUG 2008 Labor-Saving SQL Constructs Brian P. Fairfield-Carter,
David W. Carr		 11
SGF 2008 Assigning ROTC Cadets into Air Force Specialty Codes Using SAS ORs PROC LP Procedure Anthony Lawrence source 10
SGF 2008 Exporting SAS Data Sets to DDI 3 XML files: Data, Metadata, and More Metadata Larry Hoyle,
Joachim Wackerow		 source 12
SGF 2008 From Soup to Nuts: Practices in Data Management for Analytical Performance David R. Duling,
Howard Plemmons Jr.,
Nancy A. Rausch		 source 24
SGF 2008 Get Your Hands Dirty Cleaning Your Data with SAS Data Quality Server Faron Kincheloe source 17
SGF 2008 Getting SAS to Play Nice with Others: Connecting SAS to a Microsoft SQL Server with an ODBC Connection Candice Riley source 6
SGF 2008 Joining Data: Data Step Merge or SQL? Faisal Dosani,
Harry Droogendyk		 source 19
SGF 2008 Labor-Saving SQL Constructs Brian P. Fairfield-Carter,
David W. Carr		 source 10
SGF 2008 PROC SQL for DATA Step Die-Hards Christianna S. Williams source 17
SGF 2008 SAS Scripting of a Production Database into an Open Test Environment Sigurd W. Hermansen,
Himanshi Singh,
Laura Hrycyk		 source 5
SGF 2008 The Application of a General List-Processing Macro in Combination Therapy Zhongwen Huang,
William Layton		 source 5
NESUG 2007 Automatically Renaming Common Variables Before Merging Christopher J. Bost 7
NESUG 2007 Finding Answers in the PROC SQL Documentation Howard L. Schreier 12
NESUG 2007 Identifying Invalid Social Security Numbers Paulette W. Staum,
Sally Dai		 10
NESUG 2007 List Processing Basics: Creating and Using Lists of Macro Variables Ronald J. Fehd,
Arthur L. Carpenter		 20
NESUG 2007 PROC SQL - A Powerful Tool in SAS Swetha Kongara,
Raja Panchumarthi		 9
NESUG 2007 Summing with SAS Tatiana Homonoff 12
NESUG 2007 The LIBNAME Engine Compared to SQL Pass-Through Steven H. Feder 4
NESUG 2007 Using SAS to Measure Community Cohesion Desiree Alderson,
Lyndsay McDonough,
Emilio Rodriguez		 9
SESUG 2007 %XMLPORT: An XML Substitute for SAS PROC CPORT/CIMPORT (almost) Andy Barnett source 14
SESUG 2007 Building Your Own Real-Time SAS Server Monitor under UNIX Houliang Li source 7
SESUG 2007 How To Use Proc SQL select into for List Processing Ronald J. Fehd source 16
SESUG 2007 List Processing Basics: Creating and Using Lists of Macro Variables Ronald J. Fehd,
Arthur L. Carpenter		 source 20
SESUG 2007 The SQL Procedure: When and How to Use It Ying Feng source 5
MWSUG 2007 How To Use Proc SQL select into for List Processing Ronald J. Fehd 16
MWSUG 2007 List Processing Basics: Creating and Using Lists of Macro Variables Ronald J. Fehd,
Arthur L. Carpenter		 20
WUSS 2007 Secret Sequel: Keeping Your Password Away From the LOG Paul D. Sherman,
Arthur L. Carpenter		 source 10
PHUSE EU 2007 Having your cake & eating it: extracting data and attrib from OC John Hendrickx source 17
PHUSE EU 2007 Improving maintenance and performance of SQL queries Bas van Bakel,
Rick Pagie		 source 5
PHUSE EU 2007 OSR - Output macro system with Proc report and central storage.. Peter Gerber source 13
SCSUG 2007 Adapting SQL for SAS - A few ways to Maximize Performance Rena Manning 11
SCSUG 2007 Beginning Macro Design Issues Toby Dunn,
H. Ian Whitlock		 19
SCSUG 2007 List Processing Basics: Creating and Using Lists of Macro Variables Ronald J. Fehd,
Arthur L. Carpenter		 21
SCSUG 2007 Some SAS techniques used in Health Care Analysis Wei Yu 4
SCSUG 2007 Thinking in Sets Joe Celko 60
PharmaSUG 2007 Finding Duplicate Records in a SAS Dataset David W. Franklin 4
PharmaSUG 2007 SAS and Oracle Clinical Hand-in-Hand Ramkumar Krishnamurthy,
Santa Barbara		 5
PharmaSUG 2007 Saving QC Time for Production Tables Linfeng Xu,
Sunil Kumar Gupta		 10
PharmaSUG 2007 Secret Sequel: Keeping Your Password Away From the LOG Paul D. Sherman 10
PharmaSUG 2007 Teaching a New Dog Old Tricks - Using the EXCEPT Operator in PROC SQL and Generation Data Sets to Produce a Comparison Report Stanley E. Fogleman 3
SGF 2007 Building Your Own Real-Time SAS Server Monitor under UNIX Houliang Li source 7
SGF 2007 DATA Step vs. PROC SQL: What's a Neophyte to Do? Ray Davis,
Michael L. Dickstein,
Craig Pass		 source 12
SGF 2007 List Processing Basics: Creating and Using Lists of Macro Variables Ronald J. Fehd,
Arthur L. Carpenter		 source 20
SGF 2007 SAS and Sudoku Richard A. DeVenezia,
John R. Gerlach,
Larry Hoyle,
Talbot M. Katz,
Richard D. Langston		 source 37
SGF 2007 Simple and Effective - Using ODS Destinations to Facilitate Data Management Paul Gorrell source 16
SCSUG 2006 An Introduction to SQL in SAS Peter J. Lund 22
SESUG 2006 AP16 DIFFTREE: A Macro to Compare Corresponding Files under Two Directory Trees source 25
SESUG 2006 Designing an Application with Business Intelligence Brian Deitch source 19
SESUG 2006 PROC SQL for DATA Step Die-Hards Christianna S. Williams source 17
WUSS 2006 Applying SPC Methods to Improve Work Flows in High Volume Business Environment Arkady M. Kushnir source 13
WUSS 2006 Getting Your Random Sample In PROC SQL Richard Severino source 14
WUSS 2006 Using SAS to Create Teradata Multiload Scripts and Check Load Status Wei Zhang source 6
NESUG 2006 Beginning Macro Design Issues Toby Dunn,
H. Ian Whitlock		 19
NESUG 2006 Combining, Combining, Combining, Splitting, Splitting, Splitting Emmy V Pahmer 9
NESUG 2006 Designing an Application with Business Intelligence Brian Deitch 19
NESUG 2006 How is your I/O Logic? A primer on understanding program dependencies in large SAS implementations Jim Fang,
Anuj Sharma,
Vinod Narayanan,
Patrick Dunleavy		 8
NESUG 2006 Identifying Duplicate Values Christopher J. Bost 8
NESUG 2006 PROC SQL: When and How to Use It? Ying Feng 5
NESUG 2006 SAS-L - Superb (& Free) SAS Support/Learning Tool H. Ian Whitlock 15
NESUG 2006 Teaching a New Dog Old Tricks - Using the EXCEPT Operator in PROC SQL and Generation Data Sets to Produce a Comparison Report Stanley E. Fogleman 3
NESUG 2006 Variable List Short-Cuts in PROC SQL Kenneth W. Borowiak 4
PharmaSUG 2006 DIFFTREE: A Macro to Compare Corresponding Files under Two Directory Trees Directory Trees 25
PharmaSUG 2006 SAS PROC SQL or Vanilla Flavor Angelina Cecilia Mauldin 9
PharmaSUG 2006 Simple Ways to Use PROC SQL and SAS DICTIONARY TABLES to Verify Data Structure of the Electronic Submission Data Sets Christine S Teng 10
SUGI 2006 DIGITS and DATES - The SQL Procedure Goes "Loopy" Jack Hamilton source 11
SUGI 2006 Getting Your Random Sample In PROC SQL Richard Severino source 14
SUGI 2006 SQL Set Operators: So Handy Venn You Need Them Howard L. Schreier source 18
SUGI 2006 The SQL Procedure - A Primer for SAS Programmers Jimmy A. DeFoor source 17
SUGI 2006 The SQL Procedure: When and How to Use It Ying Feng source 7
SUGI 2006 Using Data Set Options in PROC SQL Kenneth W. Borowiak source 10
PNWSUG 2005 Using Datastep programming and Proc SQL in SAS To calculate daily hospital occupancy Renu Gehring,
Rajiv Sharma		 11
SESUG 2005 Getting Started with SAS/Access for Oracle F. Joseph Kelley source 19
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 Duplicate Payments and Duplicate Vendors: How to Identify All of Them Christine L. Warner 14
SCSUG 2005 MERGING vs. JOINING: Comparing the DATA Step with SQL Malachy J. Foley 17
SCSUG 2005 Proc SQL - A Primer for SAS Programmers Jimmy A. DeFoor 17
MWSUG 2005 MERGING vs. JOINING: Comparing the DATA Step with SQL Malachy J. Foley 17
WUSS 2005 Get Going with PROC SQL Richard Severino source 20
WUSS 2005 Modular Programming using AF/SCL Kevin Graham source 12
NESUG 2005 A SAS Programmer's Guide to Project - and Program-Level Quality Control Paul Gorrell 15
NESUG 2005 Database ACCESS Basics: SQL and Data Step Interface to Relational Databases Ashley Sanders 8
NESUG 2005 Join, Merge or Lookup? Expanding your toolkit Judy Loren,
Sandeep Gaudana		 15
NESUG 2005 PROC SQL for DATA Step Die-Hards Christianna S. Williams 20
NESUG 2005 Using Data Set Options in PROC SQL Kenneth W. Borowiak 9
PharmaSUG 2005 A Better Perspective of SASHELP Views John R. Gerlach 7
PharmaSUG 2005 Creating Efficient SQL - The De-normalize Transpose Paul D. Sherman 14
PharmaSUG 2005 Everything You Always Wanted to Know About Fuzzy Merges But Were Afraid to Ask - A Guide to Merging Datasets with Non-Exact Keys Using SAS Proc SQL Robert W. Graebner 4
PharmaSUG 2005 Generating Customized Analytical Reports from SAS Procedure Output Brinda Bhaskar,
Kennan Murray		 9
PharmaSUG 2005 Know your data while writing the SAS codes Shu-Min Chuang 4
PharmaSUG 2005 SAS and Oracle PL/SQL: Partners or Competitors? Stanley E. Fogleman 5
PharmaSUG 2005 Selected SAS Macro and SQL Techniques For Efficient Analysis Programming Brian P. Fairfield-Carter 12
PharmaSUG 2005 Streamlining Processes: Reconciling Programming and Documentation James E. Witt 11
PharmaSUG 2005 The Use and Abuse of the Program Data Vector (The Procs) Jim Johnson 17
PharmaSUG 2005 Useful Techniques for Enhancement of SAS/GRAPH Output Louie Huang 8
SUGI 2005 An Introduction to SAS Applications of the Windows Scripting Host Brian P. Fairfield-Carter,
Stephen Hunt,
Tracy Sherman		 source 10
SUGI 2005 An Introduction to SQL in SAS Pete Lund - SC source 22
SUGI 2005 CALL EXECUTE: A Powerful Data Management Tool Denis Michel source 13
SUGI 2005 Merging versus Joining: Comparing the DATA Step with SQL Malachy J. Foley source 18
SUGI 2005 ODS Markup: The SAS Reports You've Always Dreamed Of Eric A. Gebhart source 26
SUGI 2005 Some UNIX Tips for SAS Programming Jianming He source 4
SUGI 2005 The SQL Optimizer Project: _Method and _Tree in SAS 9.1 (broken file) Russell M. Lavery source 57
NESUG 2004 Clinical Trial Data Validation: Using PROC SQL Effectively Balakrishna Dandamudi 20
NESUG 2004 Generating Customized Analytical Reports from SAS Procedure Output Brinda Bhaskar,
Kennan Murray		 12
NESUG 2004 Optimizing Large Data Imports from a Relational Database Management System Francis Harvey III 10
NESUG 2004 SAS and Oracle PL/SQL: Partners or Competitors? Stanley E. Fogleman 4
SCSUG 2004 SAS/ACCESS to External Databases: Wisdom for the Warehouse User Judy Loren 10
SESUG 2004 Automated Data Collection Using SAS and FTP Philip James Busby source 13
SESUG 2004 Dictionary Tables and Views: Essential Tools for Serious Applications Frank C. DiIorio,
Jeffrey M. Abolafia		 source 17
SESUG 2004 Generate a Metadata for Analysis Maria-Alexandra Paladines source 9
SESUG 2004 Methods of Storing SAS Data into Oracle Tables Lois Levin source 9
SESUG 2004 Taking it Home and Putting it into Practice Diane Cunningham source 8
SESUG 2004 Using Different Methods for Accessing Non-SAS Data to Build and Incrementally Update That Data Warehouse Ben Cochran source 9
SESUG 2004 What's That Note/Warning/Error Mean and How Do I Fix It? Deb Cassidy source 10
WUSS 2004 Creating Custom Tables Using SAS Tyler Cole source 11
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
MWSUG 2004 Accessing Oracle Tables using Base SAS/SAS Access David Thul 3
MWSUG 2004 Efficiency Techniques for Beginning PROC SQL Users Kirk Paul Lafler 8
MWSUG 2004 Using Different Methods for Accessing Non-SAS Data to Build and Load that Data Warehouse Ben Cochran 9
PharmaSUG 2004 An Introduction to SAS Applications of the Windows Scripting Host Stephen Hunt 12
PharmaSUG 2004 Create All Those Tables and Call PROC SQL Once! Stanley E. Fogleman 3
PharmaSUG 2004 Customizing Clinical Data Warehouse for Business Intelligence An analyst's view Haibin Shu Barr 8
PharmaSUG 2004 SAS and Microsoft Excel for Tracking and Managing Clinical Trial Data: Methods and Applications for Information Delivery Na Li 11
SUGI 2004 A Stand-Alone SAS Annotate System for Figure Generation Brian P. Fairfield-Carter source 13
SUGI 2004 Creating an Intranet Toolbox of Selective Oracle Metadata John Charles Gober,
Deborah Mullen,
Jana Smith		 source 9
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 Dynamic SAS Programming Techniques, or How NOT to Create Job Security Steven D. Beakley,
Suzanne D. McCoy		 source 11
SUGI 2004 Efficiency Techniques for Beginning PROC SQL Users Kirk Paul Lafler source 11
SUGI 2004 Improve Your Queries: Hints and Tips for Using SQL Marje Fecht,
Linda A. Mitterling		 source 11
SUGI 2004 Improving Peformance: Accessing DB2 Data with SAS 9 Scott Fadden source 17
SUGI 2004 Let SAS Tell Microsoft Word to Collate Haiping Luo source 11
SUGI 2004 Mainframe SAS for the 21st Century Kryn Krautheim source 9
SUGI 2004 Methods of Storing SAS Data into Oracle Tables Lois Levin source 10
SUGI 2004 Using SAS to Match Cases for Case Control Studies Hugh Kawabata,
Michelle Tran,
Patricia Hines		 source 8
WUSS 2003 Using SAS Views and SQL Views Lynn G. Palmer source 5
SCSUG 2003 Proc SQL - A Primer for SAS Programmers Jimmy A. DeFoor 10
SCSUG 2003 SQL - Intermediate Destiny Corporation (a company) 19
SESUG 2003 Data-driven Validation Rules: Custom Data Validation Without Custom Programming Don Hopkins source 8
SESUG 2003 Dictionary Tables and Views: Essential Tools for Serious Applications Frank C. DiIorio,
Jeffrey M. Abolafia		 source 10
SESUG 2003 Sublime Secrets of the SAS SQLheads Sigurd W. Hermansen source 6
MWSUG 2003 Using Different Methods for Accessing Non-SAS Data to Build and Incrementally Update That Data Warehouse Ben Cochran 6
NESUG 2003 All Things to All People: A User-defined Report in SAS/AF Aileen Bennett 6
NESUG 2003 Comparative Efficiency of SQL and Base Code When Reading from Database Tables and Existing Data Sets Steven H. Feder 5
NESUG 2003 Create All Those Tables and Call PROC SQL Once! Stanley E. Fogleman 2
NESUG 2003 Different Methods for Accessing Non-SAS Data to Build and Incrementally Load That Warehouse. Ben Cochran 6
NESUG 2003 How to Link Records Matching on at Least m Out of n Identifying Keys Xinyu Ji 10
NESUG 2003 Methods of Storing SAS Data into Oracle Tables Lois Levin 10
NESUG 2003 Picking Up Where the SQL Optimizer Leaves Off Howard L. Schreier 11
NESUG 2003 SQL Basics Using Proc SQL Christopher Zogby 4
PharmaSUG 2003 A SAS Macro for Simple Statistical Summary Michael Gunshenan 10
PharmaSUG 2003 Application of Some Advanced PROC SQL Features in Clinical Trial Programming Changhong Shi 6
PharmaSUG 2003 Generating Data Definition Tables for Electronic NDA Submissions Robert D. Abelson 4
PharmaSUG 2003 SQL for People Who Don't Think They Need SQL Erin M. Christen 8
PharmaSUG 2003 The behind the Scenes of Extracting SAS Data Sets from Oracle Clinical Angela S. Ringelberg 6
SUGI 2003 Automatic Data File Retrieval from Different Database Engines Xin Zhang,
Chuancheih Hsu		 source 3
SUGI 2003 Comparative Efficiency of SQL and Base Code When Reading from Database Tables and Existing Data Sets Steven H. Feder source 5
SUGI 2003 Performance Tuning SAS/ACCESS for DB2 Scott J. Fadden source 10
SUGI 2003 PROC SQL vs. Merge - The Miller Lite Question of 2002 and Beyond Kevin J. Smith,
Muhammad Z. Khan,
Yadong Zhang		 source 4
SUGI 2003 Reducing the CPU Time of Your SAS Jobs by More than 80%: Dream or Reality? Henri Theuwissen,
Nancy Croonen		 source 10
SUGI 2003 SAS/ACCESS to External Databases: Wisdom for the Warehouse User Judy Loren source 9
SUGI 2003 Using Different Methods for Accessing Non-SAS Data to Build and Incrementally Update That Data Warehouse Ben Cochran source 6
MWSUG 2002 %X_Ray Macro to Explore Any SAS Dataset Kinwah Fung,
Douglas Zirbel		 7
SCSUG 2002 MERGING: Comparing the DATA Step with SQL Malachy J. Foley 11
NESUG 2002 Getting Oracle Data into SAS Datasets Alexa Parliyan 3
NESUG 2002 PROC SQL for DATA Step Die-Hards Christianna S. Williams 10
NESUG 2002 PROC SQL vs. Pass-Thru SQL on DB2 or How I found an extra day Jeffrey Cohen 4
NESUG 2002 SAS Stew Keeps Facilities Running Michael A. Mace 10
SESUG 2002 MERGING: Comparing the DATA Step with SQL Malachy J. Foley source 10
SESUG 2002 Multiple Uses for a Simple SQL Procedure Rebecca Larsen source 4
SESUG 2002 Structured Query Language: Logic, Structure, and Syntax Sigurd W. Hermansen source 10
SESUG 2002 Using SAS With a SQL Server Database M. Rita Thissen,
Yan Chen Tang,
Elizabeth Heath		 source 5
WUSS 2002 Get Dynamic! Generate Macros and Batch Files Right from Your Data! Karen L. Wyland source 5
WUSS 2002 The Road to SAS Deliverance - Dueling Coders Nikki M. Carroll,
Frank A. Ferriola		 source 6
WUSS 2002 The Schizophrenic Index Michelle Nipko,
Joseph Nipko		 source 4
SEUGI 2002 A Sense of Perspective: How to use a Star Schema Data Warehouse to see any historical view you want [presentation] Steve Morton source 45
PharmaSUG 2002 A data dictionary. A more complete alternative to Proc contents. Angelina Cecilia Casas 4
PharmaSUG 2002 Data Definition Tables - Definition and Automation Matthew J. Becker 4
SUGI 2002 All Things to All People: A User-defined Report in SAS/AF Aileen D. Bennett source 6
SUGI 2002 An Introduction to SAS PROC SQL Timothy J. Harrington source 6
SUGI 2002 Can't Relate? A Primer on Using SAS with Your Relational Database Garth W. Helf source 10
SUGI 2002 Creating Efficient SQL - Four Steps to a Quick Query Paul D. Sherman source 5
SUGI 2002 DATA Step vs. PROC SQL: What's a Neophyte to Do? Craig Dickstein,
Ray Pass		 source 9
SUGI 2002 Energizing End Users with a Slice of SAS and a Cup of Java Randy Curnutt,
Michael J. Pell,
John M. LaBore		 source 10
SUGI 2002 How to Link Records Matching on at Least m Out of n Identifying Keys Xinyu Ji source 5
SUGI 2002 Maximizing Productivity by Automating Frequent Tasks Robert Ellsworth source 2
SUGI 2002 SAS Accessing DB2 Data: a Performance Victory Away Henri Theuwissen,
Nancy Croonen		 source 9
SUGI 2002 Seeing Graphical Representations Clearly to Avoid Eye Strain James D. Gilbert source 4
SUGI 2002 Self Serve Census Data for Neighborhoods and Other Custom Aggregations: A SAS/IntrNet Application Larry Hoyle source 6
MWSUG 2001 Seven (plus or minus two) Clusters, A Monte Carlo Study Larry Hoyle 10
NESUG 2001 SAS Stew Keeps Facilities Running Michael A. Mace 10
WUSS 2001 Clean Your Data with PROC SQL Ann Olmsted source 5
WUSS 2001 Using Table Viewer and Form Viewer Controls in SAS/AF Steven A. Wilson source 10
SESUG 2001 Optimizing Data Extraction from Oracle Tables Caroline C. Bahler source 9
SESUG 2001 PROC SQL - Is it a Required Tool for Good SAS Programming? H. Ian Whitlock source 6
SESUG 2001 Using the SAS ACCESS Engine for DB2 OS/390 to Bulk Load Tables Robert E. Maitland Jr.,
Blue Cross Blue Shield		 source 4
SCSUG 2001 Integrating SAS/Connect with Java John M. LaBore,
Randy Curnutt,
Michael J. Pell		 9
SCSUG 2001 Optimizing Data Extraction from Oracle Tables Caroline C. Bahler 9
SCSUG 2001 PROC SQL - Is it a Required Tool for Good SAS Programming? H. Ian Whitlock 6
SCSUG 2001 Using the SAS ACCESS Engine for DB2 OS/390 to Bulk Load Tables Robert E. Maitland Jr.,
Tom Weber,
George Bischoff		 4
SEUGI 2001 Asset and Liability Management [presentation] Sanja Vuckovic source 38
PharmaSUG 2001 Enhancing Code with the SQL Procedure Jeff Goodrich 6
PharmaSUG 2001 Integrating SAS/Connect with Java Randy Curnutt,
Michael J. Pell,
John M. LaBore		 10
PharmaSUG 2001 The Application of SAS Data Mart in Clinical Laboratory Testing Cheng Wang,
Jianming He,
R Peter Mallon		 4
PharmaSUG 2001 The Efficiency of Proc SQL in Place of Traditional Procedures for Large Data Sets Cindy Stroupe 4
SUGI 2001 A Dynamic Imagemap Generator Carol A. Martell source
SUGI 2001 DATA Step vs. PROC SQL: What's a Neophyte to Do? Craig Dickstein source 9
SUGI 2001 Database Access Using the SAS System Frederick E. Pratter source 5
SUGI 2001 Joining SAS and DBMS Tables Efficiently Garth W. Helf source 6
SUGI 2001 PROC SQL - Is It a Required Tool of Good SAS Programming? H. Ian Whitlock source 6
SUGI 2001 SAS Stew Keeps Facilities Running Michael A. Mace source 10
SUGI 2001 You Could Look It Up: An Introduction to SASHELP Dictionary Views Michael L. Davis source 10
SESUG 2000 Think Thin 2-D: "Reduced Structure" Database Architecture Sigurd W. Hermansen source 5
SESUG 2000 You CAN Get There from Here (and Back Again): Adding Hot-link Drill-down Capabilities to ODS HTML Output Ray Pass source 11
SESUG 2000 You Could Look It Up: An Introduction to SASHELP Dictionary Views Michael L. Davis source 10
NESUG 2000 Is 'STUP_ID' Really "Stupid"? Sergey Sian 5
NESUG 2000 Migrate to ORACLE? I Need My SAS Software! Dianne Louise Rhodes 5
NESUG 2000 SAS Extract Macro to Create a Comma Delimited File for Microsoft Excel97 Import Aldona A. Rajecki,
Eric E. Kahle		 2
NESUG 2000 SQL Summary Functions, Unions, and Aliases to Define a Risk Cohort and Risk Variables from a Record-based Study Janet Wikoff,
Lori Maiwald		 9
NESUG 2000 You CAN Get There from Here (and Back Again): Adding Hot-link Drill-down Capabilities to ODS HTML Output Ray Pass 11
NESUG 2000 You Could Look It Up: An Introduction to SASHELP Dictionary Views Michael L. Davis 10
WUSS 2000 A Tale of Two Analysts: The Importance of Documentation Beth Worrall source 4
WUSS 2000 Access to Databases Using SAS/ACCESS Frederick E. Pratter source 4
WUSS 2000 Creating Case Report Tabluations (CRTs) for an NDA Electronic Submission Anita Rocha,
Paul D. Hamilton		 source 5
WUSS 2000 Utilization of SAS Programs in the Business Environment Sunil Kumar Gupta,
Charles E. Shipp		 source 5
MWSUG 2000 Merges and Joins Timothy J. Harrington 6
SEUGI 2000 Increase Help-Incident/Desk Efficiency by Using SAS/ITService Vision [presentation] Walter Verhoeven source 23
SEUGI 2000 IT Service Vision - WebHound - Performance Tuning and Reporting [presentation] Don Koch,
Freda Cameron		 source 42
SEUGI 2000 Scalable Performance Data Server 3.0 [presentation] Alan Gormley source 35
PharmaSUG 2000 Automating the Quantification of Healthcare Resource Utilization With Base SAS Software Nancy Bourgeois,
Bobbie Coleman		 14
PharmaSUG 2000 Optimizing Data Extraction from Oracle Tables Caroline C. Bahler 9
PharmaSUG 2000 Using the Annotate Facility for Enhancing Output Marcia Branham,
Timothy Maxwell		 7
SUGI 2000 Make Room for Me Gregory E. Taylor source 3
SUGI 2000 Merges and Joins Timothy J. Harrington source 6
SUGI 2000 Migrate to ORACLE? I Need My SAS Software! Dianne Louise Rhodes source 5
SUGI 2000 Scaling Mount GCHART: Using a MACRO to Dynamically Reset the Scale Nina L. Werner source 5
SCSUG 1999 Introduction to Using PROC SQL Thomas J. Winn Jr. 7
SESUG 1999 A Cross-reference for SAS Data Libraries John R. Gerlach,
Cindy Garra		 source 5
SESUG 1999 What's New in Versions 7 and 8 for SAS Files? Jane Stroupe source 6
WUSS 1999 Using PROC SQL to Calculate Age-Gender Adjusted Pharmacy Utilization Data Nikki M. Carroll source 4
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 PROC SQL for DATA Step Die-Hards Christianna S. Williams 10
NESUG 1999 Program Generator with DDE and FTP John Q. Zhang 9
NESUG 1999 Robust Programming Techniques in the SAS System Alice M. Cheng 10
SEUGI 1999 A Data Warehouse on Auto-Pilot - how to maintain your SAS Data Warehouse without programming [presentation] Steve Morton source 40
SEUGI 1999 Experience with Nashville on MVS, NT OS/2 and Unix [presentation] Per Andersen source 44
SUGI 1999 A Windowed Application for Efficient Access to Data Warehouse DB2 Data with PROC SQL Pass-Through Facility and Macros James Yang source 6
SUGI 1999 Automating the Production of Clinical Trial Data Tables Anne Horney,
Gail F. Kirk		 source 5
SUGI 1999 Outta Space with SAS Software? Philip R. Holland source 5
SUGI 1999 Randomly Download Data from DB2 Database on Mainframe to SAS Data Set on RISC/6000 via SAS Wen Lin source 4
MWSUG 1998 Less Well Known Features of SAS PROC SQL Timothy J. Harrington 10
SCSUG 1998 How I Learned to Stop Worrying & Love (?) Macros Ann Stephan 6
SCSUG 1998 Slug Hunting - Using SAS to Evaluate Your Database Access Strategies in DB2 Kathe Richards 10
WUSS 1998 Some Utility Applications Using the Dictionary Tables in PROC SQL Jack Hamilton source 6
WUSS 1998 Using PROC SQL and an Outside Table/File with a Database Lynn G. Palmer source 5
NESUG 1998 Creating an ADP Center of Excellence: A Miltonian Approach of Looking Through Two Decades of "Visible Darkness" Peter Parker 6
NESUG 1998 Efficient Access to Data Warehouse With PROC SQL Pass Through Facility James Yang 7
NESUG 1998 Using SAS and WordPerfect to Automate the Production of Study Data Tables Anne Horney 4
SESUG 1998 Creating an ADP Center of Excellence: A Miltonian Approach of Looking Through Two Decades of "Visible Darkness" Peter Parker 6
SESUG 1998 PROC SQL - What Does It Offer Traditional SAS Programming? H. Ian Whitlock 6
PNWSUG 1998 A Simple Solution to the PROC SORT NOPUD Option Problem Peter J. Lund 5
SEUGI 1998 An overview of SAS Software SPDS Jochen Kirsten source 24
PharmaSUG 1998 The Causes, Impact and Detection of Duplicate Observations Alice M. Cheng 11
SUGI 1998 Creating an ADP Center of Excellence: A Miltonian Approach of Looking Through Two Decades of "Visible Darkness" Peter Parker source 6
SUGI 1998 Intermediate PROC SQL Thomas J. Winn Jr. source 7
SUGI 1998 On Data Transfer Aileen L. Yam source 10
SUGI 1998 Purge Those MERGE Problems: Realistic Solutions for Accurate and More Complete Matching of Inexact Data Fields that Occur in the Everyday World Judy Palermo source 6
SCSUG 1997 A Tip for Improving DB2 Performance Ann Stephan 5
SCSUG 1997 Hodges-Lehmann Confidence Intervals for a Shift in Location Using SAS Procedure SQL Ann Olmstead 6
SCSUG 1997 Intermediate PROC SQL Thomas J. Winn Jr. 7
NESUG 1997 PROC SQL - What Does It Offer Traditional SAS Programming? H. Ian Whitlock 6
NESUG 1997 SELECT ITEMS FROM PROC.SQL WHERE ITEMS > BASICS Alan Dickson,
Ray Pass		 10
SESUG 1997 An Iterative loop of SQl Code H. Ian Whitlock 2
SESUG 1997 Clients <<-> Agent <->> Servers: Accessing Distributed, Heterogeneous Databases Sigurd W. Hermansen,
Greg Cox		 6
SESUG 1997 SQL: A Sequel to the Data Step Heidi Markovitz 6
SEUGI 1997 Fuzzy Logic and SAS Software - Do they work together? Markku V. Suni source 5
SUGI 1997 A Standard Adverse Event Summary Report Generation Frank Liu source 7
SUGI 1997 Building a Simple SAS Macro to Generate SQL Instructions in Frequently Used DB2 Tables Monique Bryher source 5
SUGI 1997 Odds Ratios in a Tabular Presentation Stephen M. Noga,
Dingyi Zhao		 source 6
SUGI 1997 Overcoming Kainophobia: Replacing Complex Merges with PROC SQL Brenda M. Barber source 6
SUGI 1997 The Fast Food Approach to Data Warehouse Reporting: Using SAS/AF and FRAME to Build a Non-Technical User Interface Grace La Torra,
Esther Steiner		 source
SCSUG 1996 Introduction to PROC SQL Thomas J. Winn Jr. 16
SESUG 1996 A Relational Database Primer for SAS Programmers Paul Dalberth 8
NESUG 1996 A Standard Adverse Event Summary Report Generation Frank Liu 7
NESUG 1996 A Universal SAS/ACCESS Macro to Retrieve Data from DB2 Tables Chen Xi,
Linda Bergin		 4
NESUG 1996 Self-Modifying SAS Programs: A DATA Step Interface S. David Riba 8
NESUG 1996 Writing WordPerfect Documents as SAS Output: Updates and Extensions Wenrui Wang,
Larry Thorderson		 4
WUSS 1996 Building a Simple SAS Macro to Generate SQL Instructions in Frequently Used DB2 Tables Monique Bryher source 5
WUSS 1996 Measuring Performance Between PROC SQL and the Merge Approach Martin Haase source 5
PNWSUG 1996 Using SAS View to Enhance Software Quality, Improve Data Security and Reduce Data Replication Adam Hendricks 27
SEUGI 1996 Comprehensive data management with the SQL Query Window Stephen Rees source 17
SEUGI 1996 Managing the Monster ... Controlling and Using a Large SAS Data Warehouse Ann S. King source 26
SUGI 1996 Accessing Non SAS Data Files on Remote Servers via ODBC Vecdet Mehmet-Ali source 5
SUGI 1996 An SQL Tutorial - Some Random Tips Paul Kent source 5
SUGI 1996 Getting Subtotals and Percentages: It's Never Been So Easy Christopher Toppe source 6
SUGI 1996 SELECT ITEMS FROM PROC.SQL WHERE ITEMS > BASICS Alan Dickson,
Ray Pass		 source 10
SCSUG 1995 Getting Subtotals and Percentages: It's Never Been So Easy Christopher Toppe 6
MWSUG 1995 A New Approach to Outer Joins with More than Two Tables Howard Levine 10
MWSUG 1995 Data Management and Manipulation: Examples for Normalized Databases and Spreadsheets Marlene Goormastic,
Shelly Sapp		 6
MWSUG 1995 Getting Subtotals and Percentages: It's Never Been So Easy Christopher Toppe 6
MWSUG 1995 SQL Joins - The Long and The Short of It Paul Kent 10
NESUG 1995 Dynamic Data Selection Lists in SAS/AF Programming Entries John M. Rinehart 7
NESUG 1995 Getting Subtotals and Percentages: Its Never Been Easy Christopher Toppe 6
NESUG 1995 Retrieving Data from Large DB2 Tables Based on Keys in SAS: The Sequel Judy Loren,
Jack N. Shoemaker		 10
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
WUSS 1995 Administering and Using SAS/CONNECT and SAS/ACCESS Joe Terdiman,
Steven A. Wilson		 source 10
WUSS 1995 Getting Subtotals and Percentages: It's Never Been So Easy Christopher Toppe source 6
WUSS 1995 Introduction to PROC SQL as a Data Summary Tool Aileen L Yarn source 5
WUSS 1995 Solutions for the Data "Where?" House: Presenting Data form Many Sources Using SAS and ODBC Andrew J. L. Cary source 10
SESUG 1995 Beginning Tutorials GETTING SUBTOTALS AND PERCENTGES IT'S NEVER BEEN SO EASY Christopher Toppe 6
SESUG 1995 SELECT ITEMS FROM PROC.SQL WHERE ITEMS > BASICS Alan Dickson,
Ray Pass		 10
SESUG 1995 Selected Programming Problems from SAS-L H. Ian Whitlock 9
SUGI 1995 "Dot Maps" Made Simple Robert E. Allison,
Moon Suh		 source 6
SUGI 1995 A New Approach to Outer Joins with More than Two Tables Howard Levine source 10
SUGI 1995 Accessing Your Databases with the SAS System C. Michael Whitney source 6
SUGI 1995 Interoperability Features of SAS System: Administering and Using SAS/CONNECT and SAS/ACCESS Steven A. Wilson,
Joseph Terdiman		 source 10
SUGI 1995 Point and Click Your Way Through DB2 Data (or SAS Data, or ORACLE Data, or ) Efficiently! Michelle Buchecker source 5
SUGI 1995 Simplifying NDA Programming with PROC SQL Aileen L. Yam source 7
SUGI 1995 SOL Joins - The Long and the Short of it Paul Kent source 10
SUGI 1995 The SQL Procedure and DB2: Coding without Confusion Nancy Fictum source 5
SCSUG 1994 Using PROC SQL Effectively With SAS Data Sets Jimmy A. DeFoor 12
WUSS 1994 If I'm Not a Database User, What Is the SQL Procedure Good For? Ann Olmsted source 15
NESUG 1994 SELECT ITEMS FROM PROC.SQL WHERE ITEMS > BASICS Alan Dickson,
Ray Pass		 10
NESUG 1994 SQL Joins - The Long and The Short of It Paul Kent 10
NESUG 1994 Stop Merging and Start Combining Robert C. Nicol 5
SESUG 1994 rurORIALS Paul Kent 10
SUGI 1994 Advanced SQL and Database Connectivity C. Michael Whitney source 4
SUGI 1994 Building a Simple Time Tracking System Using Screen Control Language Orion V. Hanger source 10
SUGI 1994 Multiple Applications in SAS Software Jonathan M. Siegel source 6
SUGI 1994 Processing Large SAS and DB2 Files: Close Encounters of the Colossal Kind Judy Loren,
Alan Dickson		 source 8
SUGI 1994 SELECT ITEMS FROM PROC.SQL WHERE ITEMS > BASICS Alan Dickson,
Ray Pass		 source 10
NESUG 1993 Close Encounters of the Colossal Kind: How Can Large SAS and DB2 Files Get Together? Judy Loren,
Alan Dickson		 8
NESUG 1993 The PROC SQL Pass-Through Facility: Taking Advantage Tim Pruitt 6
NESUG 1993 Using SAS Data Sets to Select DB2 Rows Ken Fose 4
WUSS 1993 Using the SQL Procedure Kirk Paul Lafler source 10
SCSUG 1993 SAS Macros and PROC SQL in Managing Chemical Plant Laboratory Results Conrad Reynolds 14
MWSUG 1993 Advanced SQL and Database Connectivity C. Michael Whitney 7
MWSUG 1993 Efficient Programming with PROC SQL Kim L. Kolbe Ritzow 4
SUGI 1993 Demystifying Extended Tables Stephen Davidson source 8
SUGI 1993 Management of Time-Range Data Andrew A. Norton source 8
SUGI 1993 Strengths and Weaknesses of the SQL Procedure Compared to Standard SAS Language Howard Levine source 8
SUGI 1993 Using SAS Software to Develop an Online Pregnancy Registry System Jean Fletcher source 6
SUGI 1993 Using the SQL Procedure Kirk Paul Lafler source 10
SESUG 1993 Building a Simple Time Tracking System Using Screen Control Language Orion V. Hanger 18
SCSUG 1992 Using of SAS Software to Manage Chemical Plant Laboratory Results Conrad Reynolds 4
MWSUG 1992 Developing County Profiles using PROC SQL Arlene Slocum 6
MWSUG 1992 Management of Time-Range Data Andrew A. Norton 6
SEUGI 1992 Database Features Extend the Scope of SAS/SHARE Software Colin J. Harris source 6
SUGI 1992 Database Features Extend the Scope of SAS/SHARE Software William D. Clifford source 6
SUGI 1992 Fun with the SQL Procedure - An Advanced Tutorial Paul Kent source 9
SUGI 1992 Making Use of the SAS Implementation of SQL Don Stanley source 6
SUGI 1992 Realizing Improved Efficiency on Large Databases with SQL in SAS 6.06 with Further Improvements under SAS 6.07 Anne Soeder source 3
SUGI 1992 Strategies for Advanced Merging Applications Using the SQL Procedure and the Data Step Judith H. Mopsik,
Jeffrey Phillips,
Margaret Seldin		 source 8
SUGI 1992 The Parke-Davis Assessment Program - An Example Using SQL in SAS Programming Russell Newhouse source 6
SUGI 1992 Twin Studies: Now That I Have Your Attention, or How One Users Group Kept Its Crowd After Lunch Lynne A. Davidson source 5
SUGI 1992 Using the SQL Procedure Kirk Paul Lafler source 6
NESUG 1991 Comparing PROC SQL to Standard SAS Coding Techniques Howard Levine 6
MWSUG 1991 Comparing PROC SQL to Standard SAS Coding Techniques Howard Levine 7
SEUGI 1991 "Power: SAS/ACCESS to DB2 Financial Analysis Environment for Investment Research Bernard Burgin,
Paul Gillis		 source 11
SEUGI 1991 SQL and SAS/ACCESS Differences and Interrelationships Mouloud Dey source 7
SUGI 1991 Differences and Interrelationships Between the SQL Procedure and SAS/ACCESS Software Mark Stranieri source 7
SUGI 1991 Old Wine, New Wineskins: Why the SQL Procedure Will Change the Way You Think Peter Kretzman source 6
SUGI 1991 Using the SQL Procedure Kirk Paul Lafler source 4
SUGI 1991 Using the SQL Procedure in Data Management Applications Merry G. Rabb source 5
NESUG 1990 Using PROC SQL In Data Management Applciations Merry G. Rabb 9
SEUGI 1990 The SQL Procedure in Release 6.06 of the SAS System Jens Dahl Mikkelsen source 7
SEUGI 1990 TLOAD An Alternative for SQLLOAD Hans de Roos source 5
SUGI 1990 Creating and Managing an SQL'"Database with the SAS' System Mark Stranieri source 6

Back to keywords