Tag: 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

Programming Tips
Ron Cody 0
Fuzzy Matching

The term "fuzzy matching" describes a method of comparing two strings that might have slight differences, such as misspelling or a middle initial in a name included or not included. One of my favorite functions to compare the "closeness" of two strings is the SPEDIS (spelling distance) function. Have you

David Pope 0
Why SAS programmers love SAS

SAS provides solutions that have analytics integrated into reports that deliver insight into what will happen in the future, not just report on what has happened in the past.  Who wouldn't love that? However, what makes the SAS programming environment so useful to end users is how efficient and effective

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.

Waynette Tubbs 0
Rick Langston has SASonality

This is the fifth post in the SASonality series. In this week’s post, I’ve interviewed Rick Langston, a man most SAS users have met or read about. He’s been with SAS for 30 years and attended nearly every SUGI/SAS Global Forum. In the photo at the right, Rick is the

Waynette Tubbs 0
The Code Doctor is in …

Does your SAS code lack energy? Are your macros not 'mending'? Is your data out of sorts? Not to fear, because here at SAS Global Forum, we have emergency treatment for your SAS code. The new Code Doctors section allows you to bring your problematic SAS programs to a SAS