Home
Contact
SAS:MWSUG papers
SAS:NESUG papers
SAS:PharmaSUG papers
SAS:PharmaSUG China papers
SAS:PhUSE papers
FDA/PhUSE CSS posters
SAS:PNWSUG papers
SAS:SCSUG papers
SAS:SESUG papers
SAS:SeUGI papers
SAS:SUGI papers
SAS:VIEWS papers
SAS:WUSS papers
SAS:CDISC papers
Fortune records
Marsh 1001
India
South America

Powered by SAS® 9.01.01M3P02162005.

Valid XHTML 1.0 Transitional

Titles
Loading
SAS SUGI proceedings: Quick Tips (SUGI 31 and later), 114 papers

SAS Global Forum 2017   April 2-5, 2017 - Orlando, Florida

Quick Tip

tweet!  Create a Unique Datetime Stamp for Filenames or Many Other Purposes
Joe DeShon 
Keywords: SAS Macro Datetime stamp datestamp timestamp
Pages: 11 Size: 287 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Using the New ODS EXCEL Destination in SAS® 9.4 When Working with Remote Servers
Thomas Bugg 
Pages: 7 Size: 57 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Some Tricks in Graph Template Language
Amos Shu 
Pages: 6 Size: 363 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Accelerate Your Data Prep with SAS® Code Accelerator
Paul Segal 

    resource Additional resource: Watch on Demand Video

tweet!  Using the SYMPUT Function to Automatically Choose Reference for Bivariate Cox Proportional Models
Zhongjie Cai 
Keywords: Cox Proportional Hazards model MACRO format reference survival analysis
Pages: 3 Size: 159 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Formats Are Your Friends
Anita Measey  Lei Sun 
Pages: 9 Size: 510 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  SAS® Macros for Binning Predictors with a Binary Target
Bruce Lund 
Keywords: cumulative logit model macro
Pages: 13 Size: 553 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Instant Formats in a Blink with PROC FORMAT CNTLIN=
Christopher Boniface 
Pages: 6 Size: 481 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  ODS TAGSETS.EXCELXP and ODS EXCEL Showdown
Christopher Boniface 
Pages: 6 Size: 578 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Something for Nothing? Adding Flag Variables Using Group Descriptive Statistics and PROC SQL
Sunil Gupta 
Keywords: SQL
Pages: 8 Size: 768 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Find Daylight Saving Time and Forget It
Chao-Ying Hsieh 
Keywords: Daylight Saving Time Date Automation macro time series data
Pages: 4 Size: 169 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Snail Mail to Auto-Emails: Generating Emails from SAS® with Attachments
Crystal Carel 
Pages: 7 Size: 136 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Use Internal SAS Metadata User and Authentication Domain to Connect to an FTP Server
Sebastian Scanzi 
Pages: 5 Size: 126 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  A Step-by-Step Solution to Create a Customized Graph for Grouped Data Using Graph Template Language
Elva Chen 
Pages: 11 Size: 718 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Run It in Parallel: Improving the Flow of Windows Services
David Kratz 
Pages: 7 Size: 116 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Fitting a Cumulative Logistic Regression
Shana Kelly 
Pages: 5 Size: 321 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Using Hash Tables for Creating Electronic Code Books
Raghav Adimulam 
Pages: 7 Size: 457 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Advanced, Dynamic, and Effective Dashboarding with SAS® Visual Analytics
Abhilasha Tiwari 
Pages: 11 Size: 687 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  A SAS® Macro for Covariate Specification in Linear, Logistic, and Survival Regression
Sai Liu 
Keywords: macro
Pages: 19 Size: 977 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  String Search in SAS® Visual Analytics Records
robbert rahamat 
Pages: 4 Size: 148 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  SAS® Abbreviations: Shortcuts for Remembering Complicated Syntax
Yaorui Liu 
tweet!  Stored Processes or How to Make You Use SAS® Without Even Knowing It!
Edmund Lee 
Pages: 13 Size: 748 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Yet Another Lookup Method: Updatable Indexed Data Sets
Jack Hamilton 
Pages: 15 Size: 44 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Writing SAS® Code on the Fly Using SAS Code as Character Variables
Peter Timusk 
Pages: 4 Size: 188 Kb 

    resource Additional resource: Watch on Demand Video


SAS Global Forum 2016   April 18-21, 2016 - Las Vegas, Nevada

Quick Tip

tweet!  Creating a Q-gram Algorithm to Determine the Similarity of Two Character Strings
Joe DeShon 
Pages: 7 Size: 252 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Name That Tune--Writing Music with SAS®
Dan Bretheim 
Pages: 8 Size: 38 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Automating Load for Multiple Tables in SAS® Visual Analytics
Swetha Vuppalanchi 
Pages: 12 Size: 262 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Macro Variables in SAS® Enterprise Guide®
Khoi To 
Keywords: macro enterprise guide
Pages: 7 Size: 132 Kb    Download the data filedownload (.zip, 45 Kb)

    resource Additional resource: Watch on Demand Video

tweet!  Using PROC TABULATE and LAG(n) Function for Rates of Change
Khoi To 
Keywords: tabulate
Pages: 7 Size: 147 Kb    Download the data filedownload (.zip, 32 Kb)

    resource Additional resource: Watch on Demand Video

tweet!  Quantitle Regression versus Ordinary Least Squares Regression
Ruth Croxford 
Pages: 10 Size: 465 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Restricted Cubic Spline Regression: A Brief Introduction
Ruth Croxford 
Pages: 5 Size: 130 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  A SAS® Macro for Generating a Ternary Graph in a Ceramics Industry Process
IGOR NASCIMENTO  Zacarias Linhares  ROBERTO SOARES 
Keywords: macro
Pages: 9 Size: 682 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Three Methods to Dynamically Assign Colors to Plots Based on Group Value
Amos Shu 
Pages: 2 Size: 246 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  The Combination of SAS® and VBA Makes Life Easier
Zhu Yanrong 
Pages: 5 Size: 105 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Processing CDC and SCD Type 2 for Sources without CDC: A Hybrid Approach
Vishant Bhat  Tony Blanch 
Pages: 8 Size: 847 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Omitting Records with Invalid Default Values
Lily Yu 
Pages: 6 Size: 55 Kb    Download the data filedownload (.zip, 1 Kb)

    resource Additional resource: Watch on Demand Video

tweet!  How to STRIP Your Data: Five Go-To Steps to Assure Data Quality
Michael Santema  Fagen Xie 
Pages: 6 Size: 165 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  File Management Using Pipes and X Commands in SAS®
Emily Sisson 
Pages: 5 Size: 848 Kb    Download the data filedownload (.zip, 1 Kb)

    resource Additional resource: Watch on Demand Video

tweet!  Efficiently Create Rates over Different Time Periods (PROC MEANS and PROC EXPAND)
Thomas Gant 
Pages: 9 Size: 196 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  FASHION, STYLE "GOTTA HAVE IT" COMPUTE DEFINE BLOCK
Chris Boniface 
Pages: 6 Size: 476 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  All Aboard! Next Stop is the Destination Excel
William E Benjamin Jr 
Pages: 15 Size: 756 Kb    Download the data filedownload (.zip, 146 Kb)

    resource Additional resource: Watch on Demand Video

tweet!  How to Create Data-Driven Lists
Kate Burnett-Isaacs 
Pages: 8 Size: 293 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Cleaning Up Your SAS® Log: Note Messages
Jennifer Srivastava 
Pages: 8 Size: 294 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Performing Efficient Wide-to-Long Transposes on Teradata Tables Using SAS® Explicit Pass-Through
Tao Cheng 
Pages: 13 Size: 416 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  A Macro That Can Fix Data Length Inconsistency and Detect Data Type Inconsistency
Ting Sa 
Keywords: macro
Pages: 7 Size: 224 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Instant Interactive SAS® Log Window Analyzer
Amarnath Vijayarangan  PALANISAMY MOHAN 
Pages: 7 Size: 586 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  On The Fly SAS® Reports
Ron Palanca 
Pages: 5 Size: 353 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  You Can Bet on It: Missing Observations Are Preserved with the PRELOADFMT and COMPLETETYPES Options
Chris Boniface  Janet Wysocki 
Pages: 7 Size: 443 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  The Path Length: Parent-Child De-lineage with PROC TREE and ODS
Can Tongur 
Pages: 10 Size: 299 Kb 
tweet!  Key Features in ODS Graphics for Efficient Clinical Graphing
Yuxin (Ellen) Jiang 
Keywords: clinical
Pages: 7 Size: 577 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Running Projects for the Average Joe
Jennifer Davies 
Pages: 14 Size: 278 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Four Lines of Code: Using Merge and Colons to Construct Historical Data from Status Tables
Jingyu She 
Pages: 2 Size: 98 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Setting Up Winning Conditions for a Migration of SAS® from a PC Environment to a Server Environment
Mathieu Gaouette 
Pages: 5 Size: 210 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  How to Move Data among Client Hard Disk, the Hadoop File System, and SAS® LASR™ Analytic Server
Yue Qi 
Pages: 4 Size: 109 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  The Scheduler: Give Your Punch Data a New Dimension
Ariel Kumpinsky 
Pages: 7 Size: 480 Kb 
tweet!  Releasing the Power of SAS® into Microsoft SharePoint
Xiaogang Tang 
Pages: 8 Size: 412 Kb    Download the data filedownload (.zip, 1387 Kb)

    resource Additional resource: Watch on Demand Video

tweet!  Can You Decipher the Code? If You Can, Maybe You Can Break It
Jay Iyengar 
Pages: 7 Size: 242 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Comparative Study of PROC EXPORT and Output Delivery System
Saurabh Nandy 
Keywords: ods
Pages: 9 Size: 366 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Uncommon Techniques for Common Variables
Christopher Bost 
Pages: 10 Size: 251 Kb 

    resource Additional resource: Watch on Demand Video

tweet!  Using the DOCUMENT Procedure to Expand the Output Flexibility of the Output Delivery System with Very Little Programming Effort
Roger Muller 
Keywords: ods
Pages: 8 Size: 473 Kb 

    resource Additional resource: Watch on Demand Video


SAS Global Forum 2013   April 28 - May 1, 2013 - San Francisco, California

Quick Tips

tweet!  Automating the Flow of Presentations in Coder's Corner or Quick Tips
Erik Tilanus 
Pages: 4 Size: 115 Kb 
tweet!  Implementing Metadata-driven Reports with SAS® Stored Processes
Toby Hill 
Pages: 10 Size: 268 Kb 
tweet!  Time Series Data: Anatomy of an ETL Project
Leonard Polak 
Pages: 7 Size: 81 Kb 
tweet!  CLISTS: Improve Efficiency of TSO Applications Using Mainframe SAS®
Russell Hendel 
Pages: 6 Size: 71 Kb 
tweet!  Efficient Extraction of JSON Information in SAS® Using the SCANOVER Function
Kyong Jin Shim  Murphy Choy 
Pages: 6 Size: 110 Kb 
tweet!  Back Up Your Sources During Development: A Stack of Base SAS® Scripts
Hans Sempel 
Pages: 7 Size: 272 Kb 
tweet!  FCMP -- Why?
Lisa Eckler 
Pages: 5 Size: 90 Kb 
tweet!  Data Review Information: N-Levels or Cardinality Ratio
Ronald Fehd 
Pages: 6 Size: 107 Kb 
tweet!  Healthcare Claims Processing with Base SAS® through Denormalization of ANSI 837 Format
Roberto Valverde  Victor Shigaev 
Keywords: healthcare
Pages: 7 Size: 589 Kb 
tweet!  Building SAS® Programs from Dynamically Retrieved Files by Filename Pipe Command
Jingxian Zhang 
Pages: 1 Size: 94 Kb 
tweet!  Something for Nothing? Adding Group Descriptive Statistics Using PROC SQL Subqueries
Sunil Gupta 
Keywords: SQL
Pages: 8 Size: 568 Kb 
tweet!  Running SAS® Programs Using Skype
Romain Miralles 
Pages: 6 Size: 352 Kb 
tweet!  Accessing SAS® Code via Visual Basic for Applications
Jennifer Davies 
Pages: 5 Size: 100 Kb 
tweet!  OUT= Is on the Way Out - Use ODS OUTPUT Instead
Stanley Fogleman 
Pages: 4 Size: 45 Kb 
tweet!  A Simple Approach to Generate Page Numbers in X of Y Format in ODS RTF Output
Amos Shu 
Pages: 3 Size: 174 Kb 
Best Contributed Paper
tweet!  Graph Your SAS® Off
Karena Kong 
Pages: 5 Size: 137 Kb 
tweet!  Adding Graph Visualization on SAS® ODS Output
Goutam Chakraborty  Miriam McGaugh  Shirmeen Virji  Yu Fu 
Pages: 4 Size: 219 Kb 
tweet!  "How May I Help?" The SAS® Enterprise Guide® Analyze Program Feature
Ramya Purushothaman 
Keywords: enterprise guide
Pages: 9 Size: 591 Kb 
tweet!  Some Useful Utilities on UNIX Platform
Kevin Chung 
Pages: 12 Size: 79 Kb 
tweet!  PC and UNIX SAS® Reunited
Sarwanjeet Singh  Shiva Kalidindi 
Pages: 6 Size: 167 Kb 
tweet!  SAS® Code to Make Excel Files Section 508 Compliant
Christopher Boniface  Hung Pham  Nora Szeto 
Pages: 5 Size: 456 Kb 
tweet!  Reading an Excel Spreadsheet with Cells Containing Line Endings
Larry Hoyle 
Pages: 6 Size: 149 Kb 
tweet!  Maintaining Formats When Exporting Data from SAS® into Microsoft Excel
Colleen McGahan  Nate Derby 
Keywords: SAS Excel export formats
Pages: 11 Size: 1032 Kb 
tweet!  Don’t Let the Number of Columns Hold You Back!
Douglas Liming 
Pages: 3 Size: 201 Kb 
tweet!  Reordering Columns after PROC TRANSPOSE (or Anytime You Want, Really)
Sau Yiu 
Pages: 4 Size: 45 Kb 
tweet!  Reporting Tips for No Observations
Wuong Jodi Auyuen 
Pages: 6 Size: 272 Kb 
tweet!  Wide-to-Tall: A Macro to Automatically Transpose Wide SAS® Data into Tall SAS Data
James R Brown 
Keywords: macro
Pages: 10 Size: 44 Kb 
tweet!  What's in a SAS® Variable? Get Answers with a V!
William Murphy 
Pages: 5 Size: 58 Kb 
tweet!  Quick and Easy Techniques for Fast Data Extraction
Chris Greni  Deepa Sarkar  Jason Yang  Mythili Rajamani 
Pages: 7 Size: 364 Kb 
tweet!  Dealing with Duplicates
Christopher Bost 
Pages: 5 Size: 210 Kb 
tweet!  Not Dividing by Zero: The Last of the Low-Hanging Efficiency Fruit
Bruce Gilsen 
Pages: 4 Size: 31 Kb 
tweet!  An Overview of Syntax Check Mode and Why It Is Important
Thomas Billings 
Pages: 9 Size: 286 Kb 
tweet!  Converting Thousands of Variables from Character to Numeric: The One-Hour Fix
Kamya Khanna  Wen Song 
Pages: 6 Size: 415 Kb 
tweet!  Resources for Getting the 2010 US Census Summary Files into SAS®
Rebecca Ottesen 
Pages: 5 Size: 44 Kb 
tweet!  Array, Hurray, Array: Consolidate or Expand Your Input Data Stream Using Arrays
William Benjamin 
Keywords: array
Pages: 11 Size: 549 Kb 
tweet!  10-Minute JMP®
George Hurley 
Pages: 11 Size: 684 Kb 
tweet!  Cool Views
Elizabeth Axelrod 
Pages: 7 Size: 600 Kb 
tweet!  Nifty Tips For Data Change Tracking
Julie Kilburn  Rebecca Ottesen 
Pages: 7 Size: 226 Kb 
tweet!  Programs? How to Process Your Inputs Faster
Jason Wachsmuth 
Pages: 4 Size: 58 Kb 
tweet!  Checking Out Your Dates with SAS®
Christopher Bost 
Pages: 5 Size: 244 Kb 
tweet!  We All Have Bad Dates Once in a While...
Patrick Kelly  Randall Deaton 
Pages: 4 Size: 135 Kb 
tweet!  A Macro to Verify a Macro Exists
Rick Langston 
Keywords: macro
Pages: 5 Size: 149 Kb 
tweet!  You’ve Got SASMAIL! A Simple SAS® Macro for Sending e-Mails
Rajbir Chadha 
Keywords: macro
Pages: 11 Size: 832 Kb 
tweet!  %GetReviews: A SAS® Macro to Retrieve User Reviews in JSON Format from Review Websites and Create SAS® Data Sets
Ganesh Badisa  Goutam Chakraborty  Siddhartha Reddy Mandati 
Keywords: macro internet
Pages: 9 Size: 311 Kb 
tweet!  Writing Macro Do Loops with Dates from Then to Now
Ronald Fehd 
Keywords: macro
Pages: 13 Size: 161 Kb 
tweet!  A Macro to Read in Medi-Span Text Format Database by Data Dictionary
Sijian Zhang 
Keywords: macro
Pages: 8 Size: 594 Kb 
tweet!  Using SAS® to Assess Individuals’ Best Performance in Multiple Dimensions
Aude Pujula  David Maradiaga 
Pages: 5 Size: 248 Kb 
tweet!  The SAS® Versus R Debate in Industry and Academia
Chelsea Lofland  Rebecca Ottesen 
Pages: 6 Size: 155 Kb 
tweet!  Using SAS® to Dynamically Generate SAS® Code in Order to Display Both Variable Label and Name as Column Header in PROC REPORT and PROC PRINT
Heli Ghandehari  Victor Lopez 
Pages: 5 Size: 76 Kb 
tweet!  Best Practices: PUT More Errors and Warnings in My Log, Please!
Kirk Paul Lafler  Mary Rosenbloom 
Keywords: SAS Error Errors error errors Warning Warnings warning warnings SAS Log log put Rosenbloom Mary Rosenbloom Lafler Kirk Lafler Kirk Paul Lafler sasNerd
Pages: 5 Size: 292 Kb 
tweet!  The Surprisingly "Sym"ple Alternative to Hardcoding
Rachel Carlson  Ruchi Sharma 
Pages: 6 Size: 417 Kb 
tweet!  On a First-Name Basis with SAS: Creating Personalized Error Messages Using SAS 9.2
Andrew Clapson  Valerie Hastings 
Pages: 4 Size: 86 Kb 
tweet!  SASY Codes for Lazy people
Prashanthi Selvakumar 
Pages: 5 Size: 54 Kb 
tweet!  Increase Your Productivity by Doing Less
Arthur Tabachneck  Joe Whitehurst  Robert Virgile  Xia Keshan 
Pages: 5 Size: 301 Kb 

    resource Additional resource: sasCommunity.org

Powered by SAS®.
SUGI and SAS Global Forum Proceedings are copyrighted to SAS Institute Inc. All rights are reserved.
Any unauthorized reproductions are prohibited.
SAS® and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries.
Copyright © 1999-2017 Lex Jansen. All rights reserved.