Sunil Gupta
From sasCommunity
Contact Information
Sunil Gupta, Senior SAS Consultant, Gupta Programming
- SAS Global Forum Section Co-Chair 2011: Posters [1]
- Information Quality Applied Best Practices Award for improved clinical data quality [2]
- Top 100 Notable People in the Medical Device Industry 2008 [3]
- Editorial Board Member of Good Programming Practices for Clinical Trials [4]
- Subject Matter Expert for Edit Check Design Principles Chapter in Good Clinical Data Management Practices (GCDMP)
- CDISC for Medical Device Team (Industry Expert)
- SAS Customer Advisory Panel
- Listen to Sunil's recent interview SAS Global Forum 2010:[5]
- Invite Sunil to speak at your next SAS User Group Meeting: [6]
- GuptaProgramming.com Web Site: [7]
Better prepare for the SAS Programming Base Certification Exam:
Register for my next popular Sharpening Your SAS Skills half day class at WUSS: [[8]]
New SAS e-Guides! Order and download now.
Quick Results with Proc SQL
Compare_and_Conquer_SAS_Programming_Techniques
Search/Cut/Paste SAS code in your SAS program.
View Presentation Now: Practice Makes Perfect: Training and Performing in the Pharmaceutical Industry
SAS Global Forum, March 2009 [9]
- Now OnDemand - "Effective Clinical Data Acceptance Testing" [10]
Book Titles
Quick_Results_with_Proc_SQL (New SAS e-Guide)
See promotional flyer Media:Flyer_Proc_SQL_eGuide.pdf
Compare_and_Conquer_SAS_Programming_Techniques (New SAS e-Guide)
Quick Results with the Output Delivery System
Data Management and Reporting Made Easy with SAS Learning Edition
(Useful for Enterprise Guide Users also!)
Sharpening Your SAS Skills by Sunil Gupta and Curt Edmonds
(Useful to prepare for the SAS Base Certification Exam)
See my quote about SAS Certification on SAS Institute's web site
[11]
[12]
SAS Authorline Interview with Sunil Gupta [13]
Book Reviews
Quick Results with Proc SQL
- Susan J. Slaughter, Avocet Solutions [14].
Quick Results with the Output Delivery System
- Lesley Harschnitz, Toronto-Area SAS Society [15].
- Susan J. Slaughter, Avocet Solutions, William Hewitt, Ph.D., West Chester University [16].
Data Management and Reporting Made Easy with SAS Learning Edition
(Useful for Enterprise Guide Users also!)
- Charles Patridge, SCONSIG.COM [17].
- Business Intelligence SAS User Group Newsletter [18]
Sharpening Your SAS Skills
(Useful to prepare for the SAS Base Certification Exam)
- SESUG Fall 2007 Newsletter [19].
- Frank DiIorio, CodeCrafters, Inc. [20].
- Charles Patridge, SCONSIG.COM [21].
- The American Statistican, vol. 60, No. 4, 346-346(1), November 2006. Media: American_Stat_Review_Sharpening_Your_SAS Skills.pdf
- Journal of Applied Statistics, vol. 33, No. 6, 641-644, July 2006. Media: Applied_Statistics_SAS_Skills_Book_Review_2006.pdf
- Biometrial Journal, vol. 50, 324 (2008). Media: Biometrical_Journal_SAS_Skills_Review_2008.pdf
- SciTech Book News, 9/1/2005. [22]
- DMReview.com’s Top Books in Data Management, Data Analysis and Query and Reporting [23].
Popular SAS Classes
Best Practices in SAS Statistical Programming for Regulatory Submission Media: Brochure_Best_Practices_SAS_Statistical_Programming_2010.pdf
Best_Practices_in_SAS_Statistical_Programming_for_Regulatory_Submission
Inquire about new special college student offer
- Download invited clinical presentation and paper, "Clinical-Data Acceptance Testing Procedure" [24]
Now available on demand, any time:
- Best Practices in SAS Statistical Programming for Regulatory Submission: Understanding and Applying the QC Plan to Validate Summary Tables [25]
- Best Practices in SAS Statistical Programming for Regulatory Submission: Creating Publication-Quality Summary Tables [26]
- Effective Clinical Data Acceptance Testing [27]
These courses are offered through The Center for Professional Advancement, an organization which is CEU accredited.
New: Available on demand, any time for special price of $48 per class:
Complete set of course notes and handouts.
- Sharpening Your SAS Skills: Preparing for SAS Certification [28]
(Topics: Accessing Data, Creating Data Structures, Managing Data, Generating Reports, Handling Errors) See Detail Outline [29]
E-mail Sunil with any questions
Class Student Quotes
- "Thank you again for your time and great contribution to all SAS users.",
Qing Zheng, Senior Statistical Analyst
Sharpening Your SAS Skills:
- "Even though I've been a SAS user for a few years, I never felt comfortable with data management in SAS until I read Sunil's book. Step by step process and extensive examples in each chapter give you a deep sense of data structure in SAS. In addition, the wide range of questions at the end of each chapter provides an opportunity to put your understanding to the test.",
Arash Mahdian, University of Illinois at Urbana-Champaign, PhD student in Economics
- "Very knowledgeable instructor; Excellent handouts"
- "Reviewing concepts for SAS Certification"
- "Many practical examples and questions"
- "Good review for common SAS skills"
- "I enjoyed your class and look forward to applying what I'm learning from your book Sharpening Your SAS Skills"., WUSS 2007
Best Practices in SAS Statistical Programming for Regulatory Submission:
- "Your course was excellent!"
Luc Fortin, Scientific Director, Biometry, Charles River, Quebec, Canada, SAS Global Forum, Seattle 2010
- "The course was very interesting and it will be of great help to understand and analyze my data and to become more productive. Your course is exactly what I was looking for, as well as, material, books etc. Thank you very much for the experience. I hope to meet you in another course."
Silvia Trevisan, Data Management & Statistics, IBSA - R&D Dept., October 19-20, 2009 Amsterdam, The Netherlands
- "Very competent teacher, documents were very complete."
Chantel Kersten, Kinesis Pharma, The Netherlands, October 19-20, 2009, Amsterdam, The Netherlands
- "It was a pleasure taking the class you taught. The class will help me
implement new standards immediately and will aid in creating a
programming environment where planning and validation are integral in
developing submission tables and listings sufficient for regulatory
review and audits."
Craig Wesselman, Biostatistics Supervisor, Tolmar, Fort Collins, CO, March 26-27, 2009 New Brunswick, New Jersey
- "The class is very helpful in our daily programming activities, especially on QC part.", PharmaSUG 2008
- "The right information I need to know; practical usages."
- "Liked the overview of the whole programming process."
- "Good instructor; like course content, clarity of information"
- "Your class was excellent! I found the class very helpful and upto date.",
Don Hurst, Senior Statistical Programmer, ZymoGenetics, WUSS 2007
- "This was my first WUSS and I took 3-4 training classes, I liked yours as the best!
Thank you for following up quickly with the reference material.",
Devendra Patel, Project Lead, Clinical Programming Baxter, WUSS 2007
General Class Quotes:
- "I enjoyed your class, I certainly learned some new things!" "Thank you for being one of my best instructors. I always learn a lot from your classes. SANDS 2002
- "I can immediately implement or apply any of the concepts and/or techniques.", "Presentation meets my expectations.", WUSS 2006
- "You are an excellent teacher and do a great job!", WUSS 2004
- "I thank you for providing us with such valuable information and wish to attend further of those in the future.", ODS class 2004
- "You are a wonderful teacher, very patient and helpful.", Pharmaceutical Corporate Client, 2004
- "Your book was very thorough and helpful." WUSS 2003
- "Great seminar yesterday, and great turn out too!", UCLA, 2003
- "Your presentation was great, nicely polished, easy to understand, and paced just right. People really appreciated it.", SVSUGS 2002
Download Popular SAS Hands On Workshops and Papers
- Practice Makes Perfect: Training and Performing in the Pharmaceutical Industry [30]
- Clinical Data Acceptance Testing Procedure
[31]
- Quick Results with the Output Delivery System [32]
- ODS Technology for Todays Decision Makers
[33]
- Enterprise Guide for Business Analysts
[34]
- DATA Step vs. PROC SQL: Issues with common variables when combining data sets [35]
- WHERE vs. IF Statements: Knowing the Difference in How and When to Apply
[36]
- Download all Sunil Gupta's SAS conference papers, presentations and hands-on workshops
[37]
Industry-related Articles
Standards for Clinical Data Quality and Compliance Checks,
Data Basics, Society for Clinical Data Management, Winter 2008 newsletter, [38]
Clinical-Data Acceptance Testing Procedure, Pharmaceutical Programming, 2nd issue, 2008, [39]
Practice Makes Perfect: Making the Most of Training for Statistical Programmers, European Pharmaceutical Contractor Magazine, March 2008,
Media: Practice_Makes_Perfect.pdf
Know Your Industry: Developers in Health Care, Certification Magazine, July 2006,
Media: Know_Your_Industry_Developers_in_Health_Care.pdf
Applications Developers: The Artists of Technology - Provided Expert Interview, Certification Magazine article, March 2006.
Must-Have Tools for Developers – Provided Expert Interview, Certification Magazine article, January 2006, Media: Must_Have_Tools_for_Developers.pdf
On-the-Job Training Improves Job Performance, Guest Editorial article in Certification Magazine, May 2005 issue, Media: On_the_Job.doc.
Point-N-Click, Drag-N-Drop to Produce Great Reports, No SAS Programming Required! – Business Intelligence SAS Users Group, February 2006, [40].
DATA Step vs. PROC SQL: Issues with common variables when combining data sets - SAS Technical Tip – November 2005 [41].
WHERE vs. IF Statements: Knowing the Difference in How and When to Apply – SAS Technical Tip – June 2005 [42].
Sunil's Top 10 PROC SQL Papers
Quick_Results_with_Proc_SQL (See new SAS e-Guide)
Sunil's Top 10 PROC COMPARE Papers
Proving It Works: Using PROC COMPARE to Verify an Analysis Converted into SAS Software, Lauren Haworth [43]
"How Does Your Data Compare?" SAS’s COMPARE PROCEDURE, Jenna Heyen [44]
An Easy, Concise Way to Summarize Multiple PROC COMPAREs Using the SYSINFO Macro Variable, Lex Fennell
Finally-An Easy Way To Compare Two SAS Files!, Doug Zirbel [45]
Comparing Two SAS Data Sets: Start At the Top, Ann Olmsted
The Supplement of the COMPARE Procedure, WeiQin Pan [46]
Sunil's Top 10 SAS Macro Papers
Nine Steps to Get Started using SAS Macros, Jane Stroupe [47]
Storing and Using a List of Values in a Macro Variable, Arthur L. Carpenter [48]
Five Ways to Create Macro Variables: A Short Introduction to the Macro Language, Arthur L. Carpenter
SAS Macros: Beyond the Basics, Jay A. Jaffe [49]
Advanced Macro Topics, Steven First [50]
A Serious Look Macro Quoting, Ian Whitlock [51]
How to Develop User-Friendly Macros, Sy Truong
Advanced Macro Language Techniques, Destiny Corporation
Developing a SAS System Autocall Macro Library as an Effective Toolkit, Steven A. Wilson
Sunil's Top 10 SAS Data Dictionary Tables Papers
A Quick and Easy Data Dictionary Macro, Pete Lund [52]
Programming Squared (Writing Programs that Write Programs), Jim Johnson
Data About Data: An Introduction to Dictionary Tables, Frank C. Dilorio
SAS DICTIONARY: Step by Step, Patrick Thornton
Meta Data That You (Probably) Didn’t Know That You Had: A Beginners’ Guide to Using SAS Dictionaries and Automatic Macro Variables, Richard F. Pless
Sunil's Top 10 SAS DATA Step/MERGE Papers
The Program Data Vector As an Aid to DATA step Reasoning, Marianne Whitlock
Advanced MATCH-MERGING: Techniques, Tricks, and Traps, Malachy J. Foley [53]
How to Think Through the SAS DATA Step, Ian Whitlock [54]
Danger: Merge Ahead! Warning: BY Variable with Multiple Lengths!, Bob Virgile [55]
Manipulating SAS Datasets: An Introduction, Richard Alonso
The Secret Life of the DATA Step, Thomas Miron [56]
DATA Step Internals: Compile and Execute, Neil Howard
SAS Essentials, Neil Howard
More Tales from the Help Desk: Solutions for Simple SAS Mistakes, Bruce Gilsen [57]
Sunil's Top 10 SAS Date Papers
A Beginners Guide to SAS Date and Time Handling, Wayne Finley [58]
Looking for a Date? A Tutorial on Using SAS Dates and Times, Arthur L. Carpenter [59]
Sunil's Top 10 SAS Debugging Papers
(To be added soon)
