Tag: proc sql

Programming Tips
Why learn SQL?

SQL (Structured Query Language) is the most widely used programming language for relational databases worldwide. No other programming language produces more hits for a web search than SQL and interest is growing rapidly. In June 2010, Google showed 135 million hits versus 586 million hits in June 2020. SQL is

Learn SAS
Shelly Goodin 0
SAS author's tip: displaying integrity constraints

Kirk Lafler and his book PROC SQL: Beyond the Basics Using SAS are the source of this week's tip. PROC SQL was the very first book that I promoted when joining SAS. Kirk was the perfect first SAS Press author to work with and he remains a favorite. And his book continues to appeal to users--whether they're online or at conferences.

Learn SAS
SAS Jedi 0
Jedi SAS Tricks: Some Experience Required

As a Master Chief in US Navy submarines, one of my favorite sayings was “Good judgment comes from experience, and experience comes from poor judgment.”  I've always had difficulty solidly learning new programming techniques in a traditional classroom.  The new techniques and theories I've learned don’t really take root until I've used them to solve

Learn SAS
Shelly Goodin 0
SAS author’s tip: SQL pass-through

Consultant Frederick Pratter continues his winning streak with this third edition of Web Development with SAS by Example. Web programmers of all levels will appreciate Frederick's many real-world examples and clean delivery. Speaking of delivery, I'd encourage those of you who attend SAS Global Forum and regional user group conferences to seek out Frederick if

Learn SAS
Shelly Goodin 0
SAS author's tip: views in PROC SQL

This week's SAS author's tip is perfect for SAS programmers using PROC SQL. Author Howard Schreier is a member of the SAS-L Hall of Fame, an independent consultant and trainer, and has been using SAS since 1981. His book PROC SQL by Example: Using SQL within SAS is also an