As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Quick Results with Proc SQL

From sasCommunity
Jump to: navigation, search

Quick Results with PROC SQL.jpg

by Sunil Gupta


New SAS e-Guide

Quick Results with Proc SQL

(Line-by-Line SAS Examples by Tasks)

(Useful to prepare for the SAS Advanced Certification Exam)

New - iPad compatible with Apple ibook


Order and Download this e-Guide or hard copy book now (free preview).


See why SAS Programmers want this new e-Guide Media:Flyer_Proc_SQL_eGuide.pdf


Hands-On Workshop Attendee Quotes
- "I attended your informative workshop on Proc SQL.", Kirby Cossey, ICS, Government
- "I enjoyed attending your Hands-on Workshop on Proc SQL very much.", Esther Kwan, SAS Programmer
- "While I use Proc SQL quite extensively, your presentation was direct and concise on ideas on how to make SQL work better. (The 'calculated' in the order by was worth the price of the conference!). Thanks again for your insights!", Brian K Chapman, CBF0, Research Analyst, Marketing and Sales Integration, From a company leader in the insurance industry


See book review by Susan J. Slaughter, Avocet Solutions, Co-Author of the popular The Little SAS Book [1]

See book review by Phil Holland, VIEWS newsletter, number 52 2010 4Q [2]


Using Proc SQL, can you identify: (See the promotional flyer for answers)
- at least four ways to select variables?
- at least six ways to create variables?
- at least five ways to create macro variables?
- at least five ways to create or modify table structure?
- at least five ways to change table content?


Ready to revolutionize your approach to Proc SQL with the single most concise and productivity e-Guide available?

- "Whenever you have to go away from PROC SQL for awhile, you will know you can quickly get back up to speed having the Quick Guide as your companion. Most of what you will need is contained within its 9 pages. Need to know how to assign a constant value to a variable? Just go to “5 options for creating variables”. Want to know how to use the CASE statement in PROC SQL? Check out “Six Options for Creating Columns”. Still have questions? Hyperlinks are conveniently located throughout the Guide. Still stumped? Just copy and paste code that confuses you into a SAS program and take a look at the output. For example, if you run the pasted code below you will see exactly how “re-merging” works in PROC SQL!"
Perry Watts, Author of Multiple-Plot Displays: Simplified with Macros

 proc sql;
   create table mytable as
   select *, ((weight/sum(weight))*100) as wpercnt
   from sashelp.class;
 quit;


- “A new concept SAS e-book with both referencing and direct results capabilities merged into one. Extremely useful to keep one on hand for users who needs quick results without the hassles of going through SAS documentation and Google search.”

"Using this SAS e-Guide saved me time from ‘re-inventing the wheel’ by locating the correct SAS syntax to apply. With repeated usage over time, I expect more than 2 hours should be saved. In general, the examples in this SAS e-Guide represent up to 80% of my normal SAS programming challenges. Specifically, I was able to apply this SAS e-Guide to become more productive by saving time from referring to the help list and getting to my answers faster."
Murphy Choy, Risk Analyst, Standard Chartered Bank, Singapore


- "This is truly a very unique and novel approach to providing a tutorial and reference guide to using PROC SQL. It provides 9 pages of great examples and explanations to the various parts of the SQL procedure. This is an excellent tool to have in your toolkit for the beginner to the advance SAS user."
Charles Patridge, ISO Innovative Analytics


- "A One-stop guide for all your PROC SQL needs. From a beginners to a novice programmers, there are some excellent tips you get from this. This is will be my PROC SQL cheat sheet."
Rajesh Venkkataram, Quintiles


- "The e-guide for PROC SQL looks really good. It’s very handy for someone who like to learn SQL alone or use it with SAS also."
Satya Medapati, Amgen


- "A treasure trove of very useful information, concisely displayed."
Yesvy Gustasp, Chair DC SAS User Group


- "This e-guide is very helpful for learning or reviewing SQL. I learned several new commands and it helped remind me of the flexibility and clarity of SQL."
Chris Weiner, Simulstat, Inc


- "Quick Results With Proc SQL should be a primary tool in every SAS user's arsenal, regardless of experience. I have come to view the this e-guide as my "pocket quick reference", as it is full of readily-applicable examples. Keep this one close at hand!"
Mike Vagnier, Healthways


- "I did read through the entire guide and found the organization very good and logical. I really like the layouts you use to graphically describe the JOIN table sections. I found these quite insightful."
Gabe Cano, Senior Analyst, Altarum Institute


- "Thanks for guidance and I will follow as per you. I am learning SAS and this guidance is very helpful to me."
C.Deenadhayalan, Lambda Therapeutic Research Limited, India


- “These SAS e-books will also be useful for beginners to have a quick look of the options.”
Sandeep Kottam, 7 year SAS User


- "This is an excellent guide for new and experience SQL users."
William Murphy, Howard M. Proskin & Associates


- "Nice product!"
Wei Cheng, Webmaster for Prochelp.com


- "Thanks for doing the work and presenting all this good information."
Joe Whitehurst, SAS Business Intelligence Consultant


Expect new book reviews from:
- Andre Wielki, National Institute for Demographic Studies
- Kirk Lafler, Author of PROC SQL: Beyond the Basics
- Charlie Shipp, JMP Consultant
- Chevell Parker, ODS Expert, SAS Institute
- Rao V. Nagubadi, School of Forestry & Wildlife Sciences Auburn University, AL
- David Meyer, SAS Programmer
- Phil Mason, Author of SAS Tips from Around the World
- Michael Raithel, Author of The Complete Guide to SAS Indexes
- Frank Fan, Clinova
- William Todd, Synteract
- Katharne Jenes, Synteract
- Mika Nagamine, Thomson Medstat
- Liyam Liu, Kaiser Permanente
- Stephanie Sanchez, VMSI
- Chris Lighty, Sunny Sloples
- Theresa Gulley-Reed, Office of Applied Research and Analysis Branch California Department of Alcohol and Drug Programs
- Fred Hoehler, Biostatistician
- Nate Derby, Stakana Analytics
- Steve First, Systems Seminar Consultants
- Yongyin Wang, Medtronic
- Philip Wright, ICPSR, University of Michigan
- Kriss Harris, GlaxoSmithKline, UK
- Barbara Okerson, HMC
- Jayesh Soneji, Senior SAS Consultant
- Jay Jaffee, Author of Mastering the SAS System


Learn and apply multiple SAS programming options through task-based examples in one centralized location. Table of contents includes table access, retrieval, structure and content, creating macro variables, and connecting to relational databases. This e-Guide hyperlinks contents, key books, relevant webinars and podcasts and key SAS technical papers for more effective understanding and programming.


Quick Results with Proc SQL e-Guide Table of Contents

1. Table Access and Retrieval
2. Table Structure
3. Table Content
4. Creating Macro Variables
5. Connecting to Relational Databases


Sunil’s top 20 recommended Proc SQL Technical Papers

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.

Search/Cut/Paste SAS code in your SAS program.

Order and Download this e-Guide now (free preview).

With purchase, e-mail Sunil to receive free update pdf versions and to be included on his e-mail distribution list


More articles and books by Sunil Gupta [3].