Sunil Gupta is a best-selling SAS® author and global corporate trainer. Gupta has been the Principal Consultant at Gupta Programming since 1994. He provides many client services, including customized SAS programming and business analytics classes; project management; and SAS consulting. Most recently, Gupta launched five new SAS e-guides: Quick Results with PROC SQL; Quick Results with PROC REPORT; A to Z Analysis and Validation using PROC TABULATE; Compare and Conquer SAS Programming Techniques; and Automating Tasks using SAS Macro Programming. He offers these SAS e-guides and monthly SAS programming tips to the SAS Savvy (SASSavvy.com) members he mentors. He has been using SAS software for more than 20 years and is a SAS Certified Base Programmer. He is also the author of the books, Quick Results with the Output Delivery System, Data Management and Reporting Made Easy with SAS Learning Edition 2.0 and Sharpening Your SAS Skills.
How long have you been using SAS®?
What SAS products have you used in the past? What products and solutions are you currently using?
I have used and mastered these SAS products: SAS® Enterprise Guide®, Base SAS, SAS/ODS®, PROC TABULATE, PROC REPORT, PROC SQL, SAS/STAT®, SAS/GRAPH®, SAS/ACCESS® and SAS macros.
What is a problem you have solved using SAS?
I use SAS to solve problems in clinical data management, statistical analysis and publication report generation. Once ODS was introduced, I embraced it and took advantage of style and table templates to enhance my table formats.
What is the most innovative way you have used SAS?
I've used SAS to become more productive within the pharmaceutical industry. I developed simple, yet effective macros to standardize and automate repetitive tasks. In addition, because I wanted to master each of the main analytical SAS procedures such as PROC SQL, PROC REPORT and PROC TABULATE, I developed SAS e-guides for each of these procedures that contain examples of each type of task or table, as well as the most important and common options. This helped me prevent "reinventing the wheel."
What is your most memorable SAS moment?
One of the most memorable SAS moments was when I was working on a challenging client project and we needed to dynamically create hundreds of PROC TABULATE tables using MS Excel files as source data. The client was impressed because we standardized and automated the project.
How has SAS changed in the time you have been using it?
I have been happy to see improvements in Base SAS and SAS Enterprise Guide since they were first introduced. I embrace new technology to streamline the process of analysis and documentation. SAS Enterprise Guide, for example, empowered me to focus more on program development since it was easier to debug and troubleshoot data issues.
Have you ever attended a SAS users group meeting or SAS Global Forum? If yes, please list them.
Since presenting and winning two awards for my first SAS presentations at WUSS in 1995, I actively participate as section chair and as a code doctor at many local, regional and international SAS users group meetings. I think it is important to share my knowledge and passion with other SAS users. In 1998, I was honored to serve as the Conference Program Chair for WUSS in Oakland, CA.
Has your work with SAS been influenced by any other members of the SAS community?
A few of the SAS experts who have mentored me as I was learning more about SAS and consulting are Kirk Paul Lafler, Charlie Shipp and Art Carpenter. From my first lunch meeting with Kirk, for example, I was impressed with his vast knowledge of how SAS can be effectively applied to solve real-world business problems. I also admire Charlie and Art for their accomplishments using SAS and their willingness to share their expertise and support.
If you could point a new SAS user to one resource, what would it be?
I think one of the most important resources I keep referring to is the book, Sharpening Your SAS Skills, which I wrote with Curt Edmonds. Originally, I wrote this book to help me prepare for the SAS Base Certification exam in 2003. Since then, I use it along with The Little SAS Book as my survival/quick syntax books. I also use another great book, SAS Applications Guide (no longer in print), since it contains examples of overcoming real-world challenges.