Sunil Gupta

From sasCommunity
Jump to: navigation, search

Contents

Contact Information

Sunil Gupta, Senior CDISC Global Trainer

- Make Smarter SAS Searches (Join new SAS blog) - SAS Savvy.

- SAS Savvy Live Training on popular topics such as CDISC and SAS Macros, See how to attend for free [1]

- Download free preview of popular Quick Results with Proc SQL e-guide [2]

- SAS Blog Post - Look for new article on 'Something for Nothing? Adding Group Descriptive Statistics' [3]


- Recognized as a sasCommunity.org Guru [4]

- SAS Global Forum Section Co-Chair 2011: Posters [5]

- Information Quality Applied Best Practices Award for improved clinical data quality [6]

- Subject Matter Expert for Edit Check Design Principles Chapter in Good Clinical Data Management Practices (GCDMP)

- SAS Customer Advisory Panel



- Listen to Sunil's interview at WUSS 2010, San Diego: [7]

- Listen to Sunil's interview at SAS Global Forum 2010:[8]

- View Sunil's Output Deivery System tips on YouTube: [9]


- Invite Sunil to speak at your next SAS User Group Meeting: [10]

- New Free Web Conferencing and Question/Answer Real-Time Support for Remote and International Sessions


- E-mail Sunil to be included on his e-mail distribution list and to receive special book and class promotions

- Gupta Programming - GuptaProgramming.com Web Site: [11]


New SAS e-Guides! Order and download now.
Quick Results with Proc SQL
Anatomy of SAS Macros
Compare_and_Conquer_SAS_Programming_Techniques
Search/Cut/Paste SAS code in your SAS program.



Now OnDemand Classes
"Compare and Conquer SAS Programming Techniques for FDA Submissions" [12]

"Best Practices in Being 'On-Call' for FDA Submission Audits" [13]

"Effective Clinical Data Acceptance Testing" [14]

Book Titles

See Sunil's Storefront to download SAS books and ebooks (free preview) [15]


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
(Limited Time Offer - Download first chapter for reviewing before buying.)


Sharpening Your SAS Skills by Sunil Gupta and Curt Edmonds
(Limited Time Offer - Download first chapter for reviewing before buying. Useful to prepare for the SAS Base Certification Exam)


Data Management and Reporting Made Easy with SAS Learning Edition
(Useful for Enterprise Guide Users also!)


See my quote about SAS Certification on SAS Institute's web site [16] [17]

SAS Authorline Interview with Sunil Gupta [18]

Book Reviews

Quick Results with Proc SQL

- Susan J. Slaughter, Avocet Solutions [19].


Quick Results with the Output Delivery System

- Lesley Harschnitz, Toronto-Area SAS Society [20].

- Susan J. Slaughter, Avocet Solutions, William Hewitt, Ph.D., West Chester University [21].


Data Management and Reporting Made Easy with SAS Learning Edition

(Useful for Enterprise Guide Users also!)

- Charles Patridge, SCONSIG.COM [22].

- Business Intelligence SAS User Group Newsletter [23]


Sharpening Your SAS Skills

(Useful to prepare for the SAS Base Certification Exam)

- SESUG Fall 2007 Newsletter [24].

- Frank DiIorio, CodeCrafters, Inc. [25].

- Charles Patridge, SCONSIG.COM [26].

- 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. [27]

- DMReview.com’s Top Books in Data Management, Data Analysis and Query and Reporting [28].

Popular SAS Classes

A. Pharmaceutical Industry


B. SAS Programming
(Ask how you can leverage your SAS investment with customized classes using your sample data in my new Maximizing Productivity and Efficiency using PROC SQL class. A free e-guide is included for each student.)


C. SAS Base and Advanced Certification


A. 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 higher education offer


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 [29]

- Best Practices in SAS Statistical Programming for Regulatory Submission: Creating Publication-Quality Summary Tables [30]

- Effective Clinical Data Acceptance Testing [31]


These courses are offered through The Center for Professional Advancement, an organization which is CEU accredited.


New: Available on demand, any time for one special low price per class: complete set of course notes, handouts and SAS program. One free web conferencing and real-time question and answer session included for remote and international SAS users.


- B. SAS Programming
SAS Essentials (Introduction to SAS Programming)
Customized Reports with SAS Output Delivery System
Utilizing SAS Enterprise Guide for more effective Project Management
Maximizing Productivity and Efficiency using PROC SQL
Quick Results with PROC Report
Quick Results with PROC Tabulate
Automating Tasks using SAS Macro Programming


- C. Sharpening Your SAS Skills: Preparing for SAS Certification [32]

(Topics: Accessing Data, Creating Data Structures, Managing Data, Generating Reports, Handling Errors) See Detail Outline [33]


E-mail Sunil with any questions

SAS Programmers and Class Students Quotes

- "Thank you again for your time at the conference and the continuing contribution you make to our community – this is invaluable to us!",
Michael Vagnier, Sr. Outcomes Analyst


- "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


- "I really enjoyed your classes and found them very helpful. I also watched your archived presentations "Best Practices in SAS Statistical Programming for Regulatory Sumission".

Colleen Kelly, Ph.D., President, Kelly Statistical Consulting, San Diego, Online June 2011 classes - Compare and Conquer SAS Programming Techniques for FDA Submissions and Best Practices in Being 'On-Call' for FDA Submission Audits


- "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

Download free preview of popular Quick Results with Proc SQL e-guide [34]

To better serve my SAS user base and to better manage the list of top SAS papers, I have created a new web site, SAS Savvy. Please take a brief moment to review this new online SAS resource and sign up to join the mailing list.

Pharmaceutical Industry-related Articles

Standards for Clinical Data Quality and Compliance Checks,

Data Basics, Society for Clinical Data Management, Winter 2008 newsletter


Clinical-Data Acceptance Testing Procedure, Pharmaceutical Programming, 2nd issue, 2008


Applications Developers: The Artists of Technology - Provided Expert Interview, Certification Magazine article, March 2006.


On-the-Job Training Improves Job Performance, Guest Editorial article in Certification Magazine, May 2005 issue.


Point-N-Click, Drag-N-Drop to Produce Great Reports, No SAS Programming Required! – Business Intelligence SAS Users Group, February 2006, [35].


DATA Step vs. PROC SQL: Issues with common variables when combining data sets - SAS Technical Tip – November 2005 [36].


WHERE vs. IF Statements: Knowing the Difference in How and When to Apply – SAS Technical Tip – June 2005 [37].

Common SAS Programming FAQ Index to SAS Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - Please take a brief moment to review this unique online SAS resource.

Sunil's Top 10 DATA Step/MERGE Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 10 PROC COMPARE Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 10 PROC EXPAND/SAS Date Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 10 PROC FORMAT Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 10 PROC MEANS/SUMMARY Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 15 PROC REPORT Papers

General Syntax of PROC REPORT:

COLUMNS <VAR1> <VAR2>;
DEFINE <VAR1>;
DEFINE <VAR2>;
COMPUTE;
BREAK;
RBREAK;

RUN;


To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 15 PROC SQL Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource. See SAS Savvy to download HOW Proc SQL Summary Sheet.


Basic Structure of SELECT statement:

SELECT name, sex
FROM sashelp.class
WHERE sex = 'F'
GROUP BY sex
HAVING weight > avg(weight)
ORDER BY name;


Quick_Results_with_Proc_SQL (See new SAS e-Guide)

(Useful to prepare for the SAS Advanced Certification Exam)

Sunil's Top 15 PROC TABULATE Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 10 PROC TRANSPOSE Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 10 SAS Access to External Files Papers/Databases

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 15 SAS Access to Microsoft® Excel Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 15 SAS Business Intelligence and ETL Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 10 SAS Certification Exam Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sharpening Your SAS Skills by Sunil Gupta and Curt Edmonds
(Useful to prepare for the SAS Base Certification Exam)


Quick_Results_with_Proc_SQL
Anatomy_of_SAS_Macros
(Useful to prepare for the SAS Advanced Certification Exam)

SAS Base Certification Questions PDF and Exam Summary with Syllabus
SAS Base Certification Questions and Online Practice exams (A00-201)
A00-212: SAS Certified Advanced Programmer Questions and online practice exams for SAS 9
A00-240: SAS Certified Statistical Business Analyst Questions and Online Practice Exams Using SAS 9 - Regression and Modeling

E-mail Sunil to be included on his e-mail distribution list to receive a free copy of the SAS Professional Agencies directory for contacts to open SAS positions.

Sunil's Top 10 SAS Debugging Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 10 SAS Dictionary Tables Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 20 SAS Enterprise Guide Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

See Data Management and Reporting Made Easy with SAS Learning Edition

Sunil's Top 10 SAS Functions/Informats/Formats Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 30 SAS Macro Programming Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Anatomy_of_SAS_Macros (See new SAS e-Guide)

(Useful to prepare for the SAS Advanced Certification Exam)

Sunil's Top 10 SAS ODS Basics, Style and Table Template Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 10 SAS ODS Statistical Graph Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Quick Results with the Output Delivery System
(Limited Time Offer - Download first chapter for reviewing before buying.)

Sunil's Top 10 SAS PC Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 10 SAS Program Efficiency Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 10 SAS Programming Style Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 10 SAS Statistical Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 10 SAS Technical Tips Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 10 SAS Version 9.2 Papers

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 75 Pharmaceutical Industry Papers and Links

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 20 SAS Links

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.

Sunil's Top 15 Other SAS Links

To better serve my SAS user base and to better manage the list of top SAS papers and more, I have created a new SAS blog, SAS Savvy. Make smarter SAS searches - please take a brief moment to review this unique online SAS resource.