| WUSS |
2026 |
Data Step Your Workflow and Macro Your Way to Automation: Importing Thousands of Excel Reports That Aren't Datasets |
Richard Rivera, Humberto Cisneros |
source |
16 |
| PharmaSUG |
2026 |
Do One Task, Get Another Done for Free: Use DEFX Tags in Comments to Fill Out Your define.xml |
Brendan Bartley, Megan Hinger |
source |
21 |
| MWSUG |
2025 |
Validate the Code, not just the Data : A System for SAS program evaluation |
Jayanth Iyengar |
source |
38 |
| SESUG |
2025 |
Becoming Trilingual: A Story of a SAS Programmer Learning R and Python |
Aaron Brown |
|
10 |
| SESUG |
2025 |
Simplifying SAS Viya: Explaining the Compute and CAS Servers, Caslibs, and In-Memory Data |
Carleigh Jo Crabtree |
|
27 |
| SESUG |
2025 |
Spring Cleaning for CSVs: Prepare for PROC IMPORT |
Brooke Ellen Delgoffe |
|
16 |
| WUSS |
2025 |
A Dynamic Approach to Processing XML Files |
David B. Horvath |
source |
9 |
| WUSS |
2025 |
Accredited, Bona fide, Certified, Diploma'ed, and Edumacated: The ABCDEs of Automating the Validation and Monitoring of Professional Requirements for Employees and Job Candidates Through Dynamic, Data-Driven SAS Reporting |
Troy Martin Hughes |
source |
20 |
| WUSS |
2025 |
Validate the Code, not just the Data : A System for SAS program validation |
Jayanth Iyengar |
source |
38 |
| PharmaSUG |
2025 |
Integrating SAS DDE to Automate Excel Task Tracking in Pharmaceutical Statistical Programming |
Amy Zhang, Huei-Ling Chen |
source |
8 |
| PharmaSUG |
2025 |
Using SAS with Microsoft 365: A Programming Approach |
Chris Hemedinger |
source |
14 |
| PharmaSUG |
2025 |
Validate the Code, not just the Data : A System for SAS program validation |
Jayanth Iyengar |
source |
38 |
| MWSUG |
2024 |
The Everytown Research database: Using SAS analytic procedures to analyze mass shootings |
Jayanth Iyengar |
source |
31 |
| SESUG |
2024 |
Data Access Made Easy Using SAS Studio |
Kirk Paul Lafler, Shaonan Wang, Nuoer Lu, Zheyuan (Walter) Yu, Daniel Qian, Swallow Xiaozhe Yan |
source |
26 |
| WUSS |
2024 |
The Everytown Research database: Using SAS analytic procedures to analyze mass shootings |
Jayanth Iyengar |
source |
31 |
| WUSS |
2024 |
Working with SAS and Microsoft 365 [presentation] |
Chris Hemedinger |
source |
22 |
| PharmaSUG CN |
2024 |
Validation result checking and tracking by X command |
Fangrun He |
source |
6 |
| PharmaSUG |
2024 |
Externally Yours - Adeptly Managing Data Outside Your EDC System |
Frank Canale |
source |
38 |
| PharmaSUG |
2024 |
Tales From A Tech Support Guy: The Top Ten Most Impactful Reporting and Data Analytic Features for the SAS Programmer |
Chevell T. Parker |
source |
23 |
| PharmaSUG |
2024 |
The SAS Genome - Genetic Sequencing |
Oliver Lu, Katie Watson |
source |
10 |
| WUSS |
2023 |
Data Access Made Easy Using SAS Studio |
Kirk Paul Lafler, Shaonan Wang, Nuoer Lu, Zheyuan (Walter) Yu, Daniel Qian, Swallow Xiaozhe Yan |
source |
26 |
| WUSS |
2023 |
Picking Scabs and Digging Scarabs: Refactoring User-Defined Decision Table Interpretation Using the SAS Hash Object To Maximize Efficiency and Minimize Metaprogramming |
Troy Martin Hughes, Louise S. Hadden |
source |
15 |
| WUSS |
2023 |
Processing Large Volumes of Communicable Disease Data: SAS Techniques from the COVID-19 Experience in San Diego County |
Whitney Webber, Nathaly Moran, Jacob Ritz, Fatema Sakha, Jacquelyn Ho, Jennifer Nelson |
source |
10 |
| WUSS |
2023 |
SAS Outputs as the Hub of Your Organization's Data Ecosystem |
Michael Aleman |
source |
10 |
| SESUG |
2023 |
Data Access Made Easy Using SAS Studio |
Kirk Paul Lafler, Shaonan Wang, Nuoer Lu, Zheyuan (Walter) Yu, Daniel Qian |
source |
26 |
| SESUG |
2023 |
Reading Comma Separated Files containing CR/LF embedded in quoted strings |
Nat H. Wooding Jr. |
source |
4 |
| SESUG |
2023 |
The Everytown Research database: Using SAS analytic procedures to analyze mass shootings |
Jayanth Iyengar |
source |
31 |
| PharmaSUG |
2023 |
A SAS Macro to Convert CSV files to SAS Datasets |
Zemin Zeng, Bo Yuan |
source |
7 |
| PharmaSUG |
2023 |
Data Access Made Easy Using SAS Studio |
Kirk Paul Lafler, Shaonan Wang, Nuoer Lu, Zheyuan (Walter) Yu, Daniel Qian |
source |
26 |
| PharmaSUG |
2023 |
Picking Scabs and Digging Scarabs: Refactoring User-Defined Decision Table Interpretation Using the SAS Hash Object To Maximize Efficiency and Minimize Metaprogramming |
Troy Martin Hughes, Louise S. Hadden |
source |
15 |
| PharmaSUG |
2023 |
Post-surgical opioid pain medications usage evaluation using SAS and Excel |
Marek K. Solak |
source |
11 |
| PharmaSUG |
2023 |
Tips to Read In and Output Excel Spreadsheets in SAS |
Chao Su, Jaime Yan, Changhong Shi |
source |
5 |
| PHUSE EU |
2022 |
A Native SAS Excel Interface - Replacing the SAS Engines |
Ivo Marek |
source presentation source |
9 |
| SESUG |
2022 |
Enhancing Your Skillset with SAS OnDemand for Academics (ODA) Software |
Kirk Paul Lafler |
source |
30 |
| SESUG |
2022 |
PROC IMPORT: Controlling SAS Data Types and Character Variable Lengths When Reading CSV Files |
Imelda C. Go, Abbas S. Tavakoli |
source |
5 |
| WUSS |
2022 |
Data Access Made Easy Using SAS Studio |
Kirk Paul Lafler, Zheyuan Yu, Shaonan Wang, Nuoer Lu, Daniel Qian, Swallow Xiaozhe Yan |
source |
26 |
| PharmaSUG |
2022 |
Automation of Variable Name and Label Mapping from Raw Data to Analysis Data Standards |
Xingshu Zhu, Bo Zheng, Li Ma |
source |
9 |
| PHUSE EU |
2021 |
No XSLX Engine in SAS? No XLSX Problem [presentation] |
Will Greenway |
source video |
22 |
| SESUG |
2021 |
Tips for Input/Handling of Dates in Command Files and Production |
Thomas E. Billings |
source |
6 |
| PharmaSUG |
2021 |
Integrating SAS and Microsoft Excel: Exploring the Many Options Available to You |
Vincent DelGobbo |
source |
23 |
| PharmaSUG |
2021 |
Lazy Programmers write Self-Modifying code OR Dealing with XML file Ordinals |
David B. Horvath |
source |
9 |
| PharmaSUG |
2021 |
PROC IMPORT and more. Or: when PROC IMPORT just doesn't do the job |
David B. Horvath |
source |
8 |
| PHUSE EU |
2020 |
SAS v. R vs. Python - A Comparison of Data Exploration Techniques |
Nathanael Cockburn |
source video presentation source |
12 |
| SESUG |
2020 |
Handling complex data sources in Python and SAS using Jupyter Notebook in SAS University Edition VM |
David B. Horvath |
source |
14 |
| SESUG |
2020 |
Lazy Programmers write Self-Modifying code OR Dealing with XML file Ordinals |
David B. Horvath |
source |
9 |
| SGF |
2020 |
Reading in a Comma Delimited File with a Data Dictionary |
Kalyani Telu |
source |
6 |
| PharmaSUG |
2020 |
Clinical Database Metadata Quality Control: Two Approaches using SAS and Python |
Craig Chin, Lawrence Madziwa |
source |
16 |
| PharmaSUG |
2020 |
SAS Formats: Same Name, Different Definitions FORMAT-ters of Inconvenience |
Jackie Fitzpatrick |
source |
9 |
| PHUSE US |
2020 |
Standardization = Automation: A Journey from Dataset Specification to SAS Code |
Anastasiia Khmelnytska |
source presentation source |
11 |
| SESUG |
2019 |
PROC IMPORT and more. Or: when PROC IMPORT just doesn't do the job |
David B. Horvath |
source |
8 |
| SESUG |
2019 |
SAS PROC IMPORT Troubleshooting Guide |
Imelda C. Go, Wendi L. Wright |
source |
12 |
| MWSUG |
2019 |
The Doctor Ordered a Prescription ... Not a Description: Driving Dynamic Data Governance Through Prescriptive Data Dictionaries That Automate Quality Control and Exception Reporting |
Troy Martin Hughes |
|
20 |
| WUSS |
2019 |
Tips for Correctly and Efficiently Comparing Two Files in SAS |
Aaron Brown |
source |
8 |
| PharmaSUG |
2019 |
Developing Analysis & Reporting Standards For Pharmaco-Epidemiology Observational Studies |
Bo Zheng, Xingshu Zhu |
source |
5 |
| PharmaSUG |
2019 |
Excel in SAS |
Charu Shankar |
source |
10 |
| PharmaSUG |
2019 |
Importing EXCEL Data in Different SAS Maintenance Release Version |
Huei-Ling Chen, Chao-Min Hoe |
source |
7 |
| PharmaSUG |
2019 |
Integrating SAS and Microsoft Excel: Exploring the Many Options Available to You |
Vincent DelGobbo |
source |
23 |
| SGF |
2019 |
Creating Great Maps in ODS Graphics Using the SGMAP Procedure |
Kelly Mills |
source |
11 |
| SGF |
2019 |
Integrating SAS and Microsoft Excel: Exploring the Many Options Available to You |
Vincent DelGobbo |
source |
23 |
| SESUG |
2018 |
A Beginner's Babblefish: Basic Skills for Translation Between R and SAS |
Sarah Woodruff |
source |
19 |
| SESUG |
2018 |
Accessing Password Protected Microsoft Excel Files in A SAS Grid Environment |
Brandon L. Welch |
source |
5 |
| SESUG |
2018 |
Accredited, Bona fide, Certified, Diploma'ed, and Edumacated: The ABCDEs of Automating the Validation and Monitoring of Professional Requirements for Employees and Job Candidates Through Dynamic, Data-Driven SAS Reporting |
Troy Martin Hughes |
source |
20 |
| SESUG |
2018 |
Create a SAS Program that Can Read the Contents of a Directory |
Ben Cochran |
source |
5 |
| SESUG |
2018 |
The Doctor Ordered a Prescription ... Not a Description: Driving Dynamic Data Governance Through Prescriptive Data Dictionaries That Automate Quality Control and Exception Reporting |
Troy Martin Hughes |
source |
20 |
| MWSUG |
2018 |
Analyzing YouTube comments on gun violence using SAS Viya and SAS Text Miner |
Sridevi Loya |
|
9 |
| WUSS |
2018 |
IMPORTING DATA WITH DDE (Dynamic Data Exchange) Or Proc Import? |
Humberto Cisneros |
source |
19 |
| WUSS |
2018 |
Let's Talk About Variable Attributes |
Elizabeth Guerrero Angel |
source |
7 |
| WUSS |
2018 |
The Doctor Ordered a Prescription ... Not a Description: Driving Dynamic Data Governance Through Prescriptive Data Dictionaries That Automate Quality Control and Exception Reporting |
Troy Martin Hughes |
source |
20 |
| PHUSE US |
2018 |
Optimizing SDTM Specification Development with Auto-population |
Cori Kramer, Ryan Adalbert |
source presentation source |
6 |
| PharmaSUG |
2018 |
A Collection of Items from a Programmers' Notebook |
David W. Franklin, Cecilia Mauldin |
source |
18 |
| PharmaSUG |
2018 |
Accredited, Bona fide, Certified, Diploma'ed, and Edumacated: The ABCDEs of Automating the Validation and Monitoring of Professional Requirements for Employees and Job Candidates Through Dynamic, Data-Driven SAS Reporting |
Troy Martin Hughes |
source |
20 |
| PharmaSUG |
2018 |
Introducing Dynamic Data Quality Control Methods: Abstracting Data Validation through External Data |
Troy Martin Hughes |
source |
20 |
| SGF |
2018 |
A SAS Macro That Uses PRX Functions to Verify Delimited Text File Formatting |
Paul Genovesi |
source |
37 |
| SGF |
2018 |
A Transition from SAS on a PC to SAS on Linux: Dealing with Microsoft Excel and Microsoft Access |
Jesse Speer, Ruby Johnson, Sara Wheeless |
source |
12 |
| SGF |
2018 |
Lazy Programmers write Self-Modifying code OR Dealing with XML file Ordinals |
David B. Horvath |
source |
9 |
| SESUG |
2017 |
Beginner Beware: Hidden Hazards in SAS Coding |
Alissa Wise |
source |
7 |
| SESUG |
2017 |
PROC IMPORT and more. Or: when PROC IMPORT just doesn't do the job |
David B. Horvath |
source |
8 |
| SESUG |
2017 |
Quality Control in SAS: Checking Input, Work, and Output |
Aaron Brown |
source |
11 |
| SCSUG |
2017 |
A Ringside Seat: The ODS Excel Destination versus the ODS ExcelXP Tagset |
Chevell T. Parker |
source |
32 |
| SCSUG |
2017 |
Three Great Reasons to Use the SAS ODS Excel Destination |
Kirk Paul Lafler |
source |
26 |
| MWSUG |
2017 |
Advanced Macro: Driving a Variable Parameter System with Metadata |
Arthur L. Carpenter |
|
10 |
| MWSUG |
2017 |
Agricultural Trip Generation - Linking Spatial Data and Travel Demand Modeling using SAS |
Alan Dybing |
|
9 |
| MWSUG |
2017 |
Hands-on Introduction to SAS and the ODS Excel Destination |
Kirk Paul Lafler |
|
26 |
| MWSUG |
2017 |
Working with Datetime Variable from Stata |
Haiyin Liu, Wei Ai |
|
3 |
| WUSS |
2017 |
Building Intelligent Macros: Driving a Variable Parameter System with Metadata |
Arthur L. Carpenter |
source |
10 |
| WUSS |
2017 |
Importing CSV Data to All Character Variables |
Arthur L. Carpenter |
source |
5 |
| PharmaSUG |
2017 |
Importing CSV Data to All Character Variables |
Arthur L. Carpenter |
source |
5 |
| PharmaSUG |
2017 |
SAS Application to Automate a Comprehensive Review of DEFINE and All of its Components |
Walter H. Hufford Jr., Vincent Guo, Mijun Hu |
source |
8 |
| SESUG |
2016 |
Creating Viable SAS Data Sets From Survey Monkey Transport Files |
John R. Gerlach |
source |
11 |
| SESUG |
2016 |
Extract Information from Large Database Using SAS Array, PROC FREQ, and SAS Macro |
Lifang Zhang |
source |
6 |
| SESUG |
2016 |
Moving Data and Results Between SAS and Microsoft Excel |
Harry Droogendyk |
source |
24 |
| MWSUG |
2016 |
Importing CSV Data to All Character Variables |
Arthur L. Carpenter |
|
5 |
| WUSS |
2016 |
A Ringside Seat: The ODS Excel Destination versus the ODS ExcelXP Tagset |
Chevell T. Parker |
source |
32 |
| WUSS |
2016 |
Creating Viable SAS Data Sets From Survey Monkey Transport Files |
John R. Gerlach, Independent Contractor |
source |
11 |
| WUSS |
2016 |
Exchanging Data Between SAS and Excel: Basic SAS Techniques |
William E. Benjamin Jr. |
source |
20 |
| WUSS |
2016 |
Getting it Done with PROC TABULATE |
Michael Williams |
source |
14 |
| PharmaSUG |
2016 |
SAS Abbreviations: a Shortcut for Remembering Complicated Syntax |
Yaorui Liu |
source |
8 |
| SGF |
2016 |
A Descriptive Analysis of Reported Health Issues in Rural Jamaica |
Verlin Joseph |
source presentation |
5 |
| SGF |
2016 |
A Ringside Seat: The ODS Excel Destination versus the ODS ExcelXP Tagset |
Chevell T. Parker |
source |
32 |
| SGF |
2016 |
Importing Metadata Programmatically Using the SAS Batch Import Tool |
David Moors |
source zip |
24 |
| SGF |
2016 |
Migrating from SAS 9.3 to SAS 9.4: SAS Communicating with Microsoft Office Products |
Hong (Lily) Zhang |
source |
10 |
| SGF |
2016 |
SAS-IO, a Browser-Based Tool to Automate Creation of Inputs/Outputs Lists for SAS Programs |
Mohammad Reza Rezai |
source presentation |
7 |
| MWSUG |
2015 |
You Can't Spell 'Assume' without S.A.S. |
Mike D. Tangedal |
|
8 |
| SESUG |
2015 |
A Beginner's Babblefish: Basic Skills for Translation Between R and SAS |
Sarah Woodruff |
source |
17 |
| SESUG |
2015 |
A Descriptive Analysis of Reported Health Issues in Rural Jamaica |
Verlin Joseph |
source |
5 |
| SESUG |
2015 |
Accessing and Extracting Unstructured XML Data using SAS and Python |
Sai Mandagondi |
source |
8 |
| PharmaSUG |
2015 |
A Collection of Items from a Programmers' Notebook |
David W. Franklin, Cecilia Mauldin |
source |
19 |
| PharmaSUG |
2015 |
SAS Grid: Simplified |
Rajinder Kumar |
source |
6 |
| PharmaSUG |
2015 |
Unpacking an Excel Cell: Dealing with Multi-Line Excel Cells in SAS |
Lucheng Shao |
source |
10 |
| SGF |
2015 |
Preparing Students for the Real World with SAS Studio |
AnnMaria De Mars |
source |
18 |
| SGF |
2015 |
Structuring your SAS Applications for Long-Term Survival: Reproducible Methods in Base SAS Programming |
Paul Thomas |
source zip |
13 |
| SCSUG |
2014 |
Survival tips for the Lone SAS programmer in an office full of stata , SPSS, and excel users |
Mary G. Crissey |
|
18 |
| SESUG |
2014 |
Flat Pack Data: Converting and ZIPping SAS Data for Delivery |
Sarah Woodruff |
source |
9 |
| SESUG |
2014 |
Moving Data and Results Between SAS and Microsoft Excel |
Harry Droogendyk |
source |
23 |
| MWSUG |
2014 |
SAS 101 For Newbies--Not Too Little, Not Too Much--Just Right |
Ira Shapiro |
|
42 |
| PharmaSUG CN |
2014 |
SAS2VBA2SAS: Automated solution to string truncation in PROC IMPORT excel |
Amarnath Vijayarangan |
|
6 |
| WUSS |
2014 |
Paperwork Without Tears: Completing Your Reporting Requirements in 10 Easy Steps |
AnnMaria De Mars |
source |
17 |
| SGF |
2014 |
Excel with SAS and Microsoft Excel [presentation] |
Andrew Howell |
source |
29 |
| SGF |
2014 |
Text Mining Reveals the Secret of Success: Identification of Sales Determinants Hidden in Customers' Opinions |
Rafal Wojdan |
source |
18 |
| WUSS |
2013 |
Creating Excel-lent SAS Data Sets |
Ben Cochran |
source |
6 |
| SESUG |
2013 |
Basketball Analytics: Optimizing the Official Basketball Box-Score (Play-by-Play) |
William H. Cade |
source |
7 |
| SESUG |
2013 |
Instant Disaggregation: Using the macro language to provide reports with parallel structure across different subsets of the data set |
Daniel Ralyea |
source |
7 |
| PHUSE EU |
2013 |
Creating define.xml from a SAS Program [presentation] |
Joergen Iversen |
source |
39 |
| PHUSE EU |
2013 |
Proc Import Diagnostic Macro |
Shan Lee |
source presentation source |
8 |
| MWSUG |
2013 |
Copy and Paste from Excel to SAS |
Arthur S. Tabachneck, Matthew J. Kastin |
|
4 |
| MWSUG |
2013 |
Getting Excel-lent Data: Generating SAS Datasets from a Directory of Spreadsheets |
Ben Cochran |
|
6 |
| MWSUG |
2013 |
SAS Automation - From Password Protected Excel Raw Data To Professional-Looking PowerPoint Report |
Jeff Hao |
|
13 |
| NESUG |
2013 |
Bring it in and turn it around and around: Importing multiple excel sheets into SAS Performing a simple double transpose |
Hezekiah Bunde |
|
10 |
| NESUG |
2013 |
Using SAS PROC IMPORT to Read CMS Hospital Compare and HCAHPS Data in Support of a Hospital Pay-for-Performance Program |
Michael Cunningham, Don Colarosa |
|
13 |
| SGF |
2013 |
Time Series Data: Anatomy of an ETL Project |
Leonard Polak |
source |
7 |
| NESUG |
2012 |
"There's an App for That": It's Called SAS ODS! Mobile Data Entry and Reporting via SAS ODS |
Michael Drutar |
|
11 |
| NESUG |
2012 |
Automatically Generating SAS Code from Client Specifications |
Stanley E. Legum |
|
14 |
| NESUG |
2012 |
Integrating SAS and Excel: An Overview and Comparison of Three Methods for Using SAS to Create and Access Data in Excel |
Nathan Clausen, Edmond Cheng |
|
14 |
| NESUG |
2012 |
Loading Metadata to the IRS Compliance Data Warehouse (CDW) Website: From Spreadsheet to Database Using SAS Macros and PROC SQL |
Robin Rappaport, Jeffrey S. Butler |
|
7 |
| SESUG |
2012 |
"There's an App for That": It's Called SAS ODS! Mobile Data Entry and Reporting via SAS ODS |
Michael Drutar |
source |
11 |
| SESUG |
2012 |
We Can Import It For You Wholesale: How to Use SAS Macros to Import Hundreds of Excel Files |
Matthew Gyory |
source |
6 |
| SESUG |
2012 |
Why Does SAS Say That? What Common DATA Step and Macro Messages Are Trying to Tell You |
Charles E. Mullin, Kevin Russell |
source |
17 |
| MWSUG |
2012 |
Copy and Paste Almost Anything |
Arthur S. Tabachneck, Randy Herbison, John Henry King, Richard A. DeVenezia, Nathaniel Derby, Ben Powell |
|
17 |
| MWSUG |
2012 |
Reading and Processing the Contents of a Directory |
Ben Cochran |
|
6 |
| WUSS |
2012 |
Biology research data cleaning technical |
Kai Yang |
source |
12 |
| WUSS |
2012 |
Import Excel: Go Beyond The Wizard With Data-Driven Programming |
Renato G. Villacorte |
source |
7 |
| WUSS |
2012 |
SAS Programming Basics: Getting Your Data In and Understanding the Data Step |
Helen D. Carey |
source |
13 |
| PharmaSUG |
2012 |
Importing Excel File using Microsoft Access in SAS |
Ajay Gupta |
source |
8 |
| PharmaSUG |
2012 |
Why Does SAS Say That? What Common DATA Step and Macro Messages Are Trying to Tell You |
Charles E. Mullin, Kevin Russell |
source |
17 |
| SGF |
2012 |
"There's an App for That": It's Called SAS ODS! Mobile Data Entry and Reporting via SAS ODS |
Michael Drutar |
source |
11 |
| SGF |
2012 |
Copy and Paste Almost Anything |
Arthur S. Tabachneck, John Henry King, Nathaniel Derby, Randy Herbison, Richard A. DeVenezia, Ben Powell |
source |
16 |
| SGF |
2012 |
Go Beyond the Wizard with Data-Driven Programming |
Renato G. Villacorte |
source |
7 |
| SGF |
2012 |
Import and Output XML Files with SAS |
Yi Zhao |
source |
6 |
| SGF |
2012 |
Moving Data and Results Between SAS and Microsoft Excel |
Harry Droogendyk |
source |
22 |
| SGF |
2012 |
Why Does SAS Say That? What Common DATA Step and Macro Messages Are Trying to Tell You |
Charles E. Mullin, Kevin Russell |
source |
17 |
| SESUG |
2011 |
Let SAS Do the Downloading: Using Macros to Generate FTP Script Files |
Arthur Furnia |
source |
12 |
| SESUG |
2011 |
Loading Metadata to the IRS Research Compliance Data Warehouse (CDW) Website: From Excel Spreadsheet to SQL Server Relational Database Using SAS Macro and PROC SQL |
Robin Rappaport, Jeffrey S. Butler |
source |
7 |
| SESUG |
2011 |
Show Me The Folder |
Brandon Barrett, Human Genome |
source |
3 |
| WUSS |
2011 |
Creating SAS Datasets from Varied Sources |
Sofia Shamas, Mansi Singh |
source |
8 |
| MWSUG |
2011 |
An EXCEL-ent Method to %INCLUDE SAS Code |
Irvin Snider |
|
10 |
| MWSUG |
2011 |
How to Use SDTM Definition and ADaM Specifications Documents to Facilitate SAS Programming |
Yan Liu |
|
5 |
| MWSUG |
2011 |
Import and Output XML Files with SAS |
Yi Zhao |
|
6 |
| MWSUG |
2011 |
You Can't Spell 'Assume' without S.A.S. |
Mike D. Tangedal |
|
8 |
| NESUG |
2011 |
The Beginnings of Creating a Civil Partnership Between SAS and Excel |
Kathleen M. Siemborski |
|
6 |
| PharmaSUG |
2011 |
A Recursive SAS Macro to Automate Importing Multiple Excel Worksheets into SAS Data Sets |
Wenyu Hu, Liping Zhang |
source |
6 |
| PharmaSUG |
2011 |
Reading Title and Footnote from RTF Output into SAS utilizing Microsoft Excel |
Ajay Gupta |
source |
6 |
| PharmaSUG |
2011 |
Smart Import/Append Data in Excel Sheets |
Zhengping Ma, Liping Liu |
source |
8 |
| SGF |
2011 |
Taking PROC SUMMARY a Step Beyond |
Priya Suresh |
source |
7 |
| WUSS |
2010 |
Moving from Windows to Super-computing: The 5% Solution |
AnnMaria De Mars |
source |
9 |
| WUSS |
2010 |
What Every SAS Programmer Should Know: Importing Files |
Renato G. Villacorte |
source |
4 |
| MWSUG |
2010 |
Choosing the Right Tool from Your SAS and Microsoft Excel Tool Belt |
Jennifer F. First, Steven J. First |
|
18 |
| MWSUG |
2010 |
SAS Macro Application Using Microsoft Excel As Both Control File and Process Documentation |
Mike D. Tangedal |
|
5 |
| MWSUG |
2010 |
Turning Raw Data into Polished Reports |
Lora D. Delwiche, Susan J. Slaughter |
|
18 |
| SESUG |
2010 |
Customizing Proc Import Code |
Carolyn D. Williams |
source |
3 |
| PharmaSUG |
2010 |
Importing Data from RTF Output into SAS utilizing Microsoft Access/Word in an intriguing, efficient way |
Ajay Gupta |
|
8 |
| SGF |
2010 |
Choosing the Right Tool from Your SAS and Microsoft Excel Tool Belt |
Jennifer F. First, Steven J. First |
source |
18 |
| SGF |
2010 |
Taming the Herd: Wrangling Unruly Text Files in SAS |
Taylor R. Young |
source |
9 |
| SESUG |
2009 |
Exchanging data between SAS and Microsoft Excel |
Yuqing Xiao |
source |
8 |
| MWSUG |
2009 |
Dietary Glycemic Load and Risk of Colon Cancer: A Guide to Data Management |
Svetlana Zelenskiy, Lauren Byrne, Cheryl L. Thompson, Thomas C. Tucker, David Bruckman, Li Li |
|
16 |
| MWSUG |
2009 |
Mail Merge using SAS |
Michael Stout |
|
10 |
| NESUG |
2009 |
Techniques for Labeling SAS Variables |
Paulette W. Staum |
|
6 |
| PharmaSUG |
2009 |
Automating the pooling of variables across multiple datasets using Proc SQL and SAS Macro |
Sanjiv Ramalingam |
|
10 |
| PharmaSUG |
2009 |
Importing Data from Microsoft Word into SAS |
Jay Zhou |
|
5 |
| SGF |
2009 |
Automatic Generation of Titles, Footnotes, and Superscripts for Tables with Macros and PROC REPORT |
Paul Cascagnette |
source |
11 |
| SGF |
2009 |
SAS and Microsoft Excel: Two Extreme Worlds. Learn How SAS Works with Excel Data and How Excel Exploits the Power of SAS |
Henri Theuwissen |
source |
20 |
| SGF |
2009 |
SAS/ACCESS to PC Files Data Access Demystified |
Howard Plemmons Jr. |
source |
10 |
| SGF |
2009 |
Tales from the Help Desk 3: More Solutions for Common SAS Mistakes |
Bruce F. Gilsen |
source |
10 |
| SESUG |
2008 |
Automated Data Converting of Character into Numeric Fields |
Mila Chiflikyan |
source |
11 |
| SESUG |
2008 |
Using External Files to Maintain An Application |
Edgar Adams |
source |
8 |
| PHUSE EU |
2008 |
Efficiency Issues in Evaluating Pharmacogenetic Data With SAS |
Volker Harm, Stephan Lehr |
source |
10 |
| MWSUG |
2008 |
A Comparison between Correlated ROC Curves Using SAS and DBM MRMC: A Case Study in Image Comparison |
Dachao Liu |
|
10 |
| NESUG |
2008 |
Extending the Power of SAS with Java |
Joseph Belice, Kevin C. Harper, Steven Schwartz |
|
20 |
| NESUG |
2008 |
Methodologies for converting Excel Spreadsheets to SAS datasets |
Karin LaPann |
|
8 |
| PharmaSUG |
2008 |
Creating and Maintaining large Metadata EXCEL files |
John H. Adams, Boehringer Ingelheim |
|
11 |
| NESUG |
2007 |
Working with Messy EXCEL Files |
Nat H. Wooding Jr. |
|
12 |
| PHUSE EU |
2007 |
Preparing real world data in Excel sheets for stats analysis |
Volker Harm |
source |
6 |
| SCSUG |
2007 |
How to Excel with SAS |
Keith Cranford |
|
12 |
| SCSUG |
2007 |
How to Import a Text File with a Large Number of Variables But The Layout Stored in a Separate File? |
Mu Hu, Steven Yan |
|
5 |
| PharmaSUG |
2007 |
Taking the Proc Summary a Step Beyond |
Priya Suresh |
|
7 |
| SGF |
2007 |
Using Dynamic Data Exchange and Table-Driven Programming to Manage Microsoft Excel Files |
Xiaoming Liang |
source |
10 |
| SESUG |
2006 |
Taking the Proc Summary a Step Beyond |
Priya Suresh |
source |
7 |
| NESUG |
2006 |
Excellent Dating in SAS |
James Zeitler |
|
3 |
| NESUG |
2006 |
Tales from the Help Desk 3: More Solutions for Simple SAS Mistakes |
Bruce F. Gilsen |
|
10 |
| PharmaSUG |
2006 |
Drawkcab Gnimmargorp: Test-Driven Development with FUTS |
Jeff Wright |
|
12 |
| PharmaSUG |
2006 |
External Data Utility (EDU), a SAS Tool to Manage Data from Acquisition to Database Release |
Margaret Hung, Mohit Goel, Sheila Moody |
|
11 |
| SUGI |
2006 |
Drawkcab Gnimmargorp: Test-Driven Development with FUTS |
Jeff Wright |
source |
12 |
| SUGI |
2006 |
Make the Invisible Visible: A Case Study of Importing Multiple Worksheet Files By Using the SAS9 LIBNAME Engine in Microsoft Excel |
Zizhong (James) Fan |
source |
7 |
| NESUG |
2005 |
Dude, Where's My Zero? Using DDE to Read Microsoft Excel Files Containing Leading Zeros |
Kevin Dietz |
|
2 |
| NESUG |
2005 |
From 500 Spreadsheets to One SAS Data Set in Three Easy Steps: Driving IMPORT with Data-Driven Macro Variables |
Christianna S. Williams |
|
10 |
| PharmaSUG |
2005 |
Data Transfer from Microsoft Access to SAS Made Easy |
Zaizai Lu |
|
5 |
| SUGI |
2005 |
PROC IMPORT with a Twist |
Gary M. McQuown |
source |
4 |
| SUGI |
2005 |
Turning Raw Data into Polished Reports |
Susan J. Slaughter, Lora D. Delwiche |
source |
18 |
| NESUG |
2004 |
Many MS Excel Worksheets - Read Them Without Typing Their Names |
Ravi Vaylay |
|
5 |
| NESUG |
2004 |
Transporting Data in the SAS Universe |
John Malloch, Jayne May Miller |
|
4 |
| WUSS |
2004 |
Turning Raw Data into Polished Reports |
Lora D. Delwiche, Susan J. Slaughter |
source |
18 |
| PharmaSUG |
2004 |
SAS and Microsoft Excel for Tracking and Managing Clinical Trial Data: Methods and Applications for Information Delivery |
Na Li |
|
11 |
| SUGI |
2004 |
Building a Purchasing Data Warehouse for SRM from Disparate Procurement Systems |
Zeph G. Stemle |
source |
10 |
| SUGI |
2004 |
Using Text Files to Enhance SAS Code |
David J. Austin |
source |
11 |
| WUSS |
2003 |
Merging Large Internet And Paper Survey Datasets For A 22-Year Longitudinal Cohort Study |
Thomas E Corbeil, Tyler C. Smith, Besa Smith, Margaret A. K. Ryan |
source |
5 |
| NESUG |
2003 |
CSV: A Macro Which Writes SAS Programs to Read csv-Files |
Victor Kamensky |
|
8 |
| PharmaSUG |
2003 |
Generating Data Definition Tables for Electronic NDA Submissions |
Robert D. Abelson |
|
4 |
| SUGI |
2003 |
How to Access PC File Data Objects Directly from UNIX |
Howard Plemmons Jr. |
source |
4 |
| SUGI |
2003 |
So Many Files, So Little Time (or Inclination) to Type Their Names: Spreadsheets by the Hundreds |
So Little Time |
source |
4 |
| SESUG |
2002 |
So Many Files, So Little Time to Type Their Names |
Francis J. Kelley |
source |
4 |
| WUSS |
2002 |
A New User's Journey in Using PROC IMPORT and ODS: An Application in the Electricity Market |
David L. Wang, Azharul Islam |
source |
3 |
| PharmaSUG |
2002 |
%Qexcel Tackles the Challenges of Converting Data to SAS from Excel |
Jay Zhou |
|
6 |
| SUGI |
2002 |
A New User's Journey in Using PROC IMPORT and ODS: An Application in the Electricity Market |
David L. Wang, M. Azharul Islam |
source |
3 |
| SUGI |
2002 |
Data Socket Adapters |
Sigurd W. Hermansen |
source |
5 |
| WUSS |
2001 |
Considerations for Multi-Platform Data Analysis and Delivery |
Paul A. Choate |
source |
5 |
| WUSS |
2001 |
Using SAS V8 to Modify Microsoft EXCEL Spreadsheets |
Michael J. Yee |
source |
2 |
| SESUG |
2001 |
Advanced Methods to Introduce External Data into the SAS System |
Andrew T. Kuligowski |
source |
10 |
| SCSUG |
2001 |
Advanced Methods to Introduce External Data into the SAS System |
Andrew T. Kuligowski |
|
10 |
| SUGI |
2001 |
Introducing External Data to the SAS System - The Interactive Session |
Andrew T. Kuligowski |
source |
10 |
| WUSS |
2000 |
Bringing Rhyme and Reason to Your Data: A Beginner's Guide to Creating Reports that Communicate and Impress |
Lora D. Delwiche, Susan J. Slaughter |
source |
10 |
| WUSS |
2000 |
SAS Version 8 Interface (Display Manager) |
Dana Rafiee |
source |
42 |
| SUGI |
2000 |
Bringing Rhyme and Reason to Your Data: A Beginner's Guide to Creating Reports that Communicate and Impress |
Lora D. Delwiche, Susan J. Slaughter |
source |
10 |
| SUGI |
2000 |
Flexibility in Data Management Through the SAS System |
Shawn P. Thomas, Brandon L. Welch, Keely P. Casey |
source |
6 |
| WUSS |
1999 |
An Everyday Guide to Versions 7 and 8 of the SAS System |
Susan J. Slaughter, Lora D. Delwiche |
source |
10 |
| NESUG |
1999 |
The Redmond to Cary Express - A Comparison of Methods to Automate Data Transfer Between SAS and Microsoft Excel |
Micahel T Mumma |
|
9 |
| SUGI |
1999 |
An Everyday Guide to Version 7 of the SAS System |
Susan J. Slaughter, Lora D. Delwiche |
source |
8 |
| WUSS |
1998 |
Accessing Data from Your PC Using Version 7 of the SAS System |
Roger Sanders |
source |
5 |
| WUSS |
1998 |
The Programmer's Solution to Import/Export Wizard |
Lora D. Delwiche, Susan J. Slaughter |
source |
6 |
| SEUGI |
1998 |
Using CIDS, a SAS/AF software application, to build a data warehouse and to provide OLAP tools for managers at PTT Post |
Harm Schipper |
source |
10 |