Tag: Book

Unexpected results from missing values with PROC SQL

SAS SQL handles missing values differently than the ANSI standard for SQL. PROC SQL follows the SAS convention for handling missing values: numerical missing values are always interpreted as less or smaller than all nonmissing values. My first blog showed that missing values can be troublemakers in non-grouped descriptive statistics. […]

Unexpected results from missing values with PROC SQL was published on SAS Users.

Meet our SAS Press Author of the Month — Jane Eslinger

We publish a lot of books by SAS experts at SAS Press, but how does someone become an expert in the first place? Becoming certified is one step, but who develops the certifications in the first place? Those are the true experts. They have to have a deep understanding of […]

Meet our SAS Press Author of the Month — Jane Eslinger was published on SAS Users.

Meet our SAS Press Author of the Month – Ron Cody

Recently, the SAS Press team moved to a new building on the SAS campus. And when the SAS Press team moves, we bring a lot of books with us! Packing and organizing all of our books gave us a chance to appreciate all of our authors’ hard work during the […]

Meet our SAS Press Author of the Month – Ron Cody was published on SAS Users.

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

Why learn SQL? was published on SAS Users.

Fun with Ciphers (Part 1)

This blog serves two purposes: the main purpose is to show you some useful SAS coding techniques, and the second is to show you an interesting method of creating a Beale cipher. TJ Beale is famous in Virginia for leaving behind three ciphers, supposedly describing the location of hidden gold […]

Fun with Ciphers (Part 1) was published on SAS Users.

You can’t teach an old dog new tricks… or can you?

When we moved out to the country with our two dogs, our oldest dog Todd suddenly decided he liked to howl…. And he would do so every time we left the house. Maybe it was the country air? Maybe it was a time-lapse gene? Maybe he just wanted to learn […]

You can’t teach an old dog new tricks… or can you? was published on SAS Users.

Two macros for detecting data errors

Last year, I wrote a blog demonstrating how to use the %Auto_Outliers macro to automatically identify possible data errors. This blog demonstrates a different approach—one that is useful for variables for which you can identify reasonable ranges of values for each variable. For example, you would not expect resting heart […]

Two macros for detecting data errors was published on SAS Users.

Top Books for SAS Programmers

The Day of the Programmer is not enough time to celebrate our favorite code-creators. That’s why at SAS, we celebrate an entire week with SAS Programmer Week! If you want to extend the fun and learning of SAS Programmer Week year-round, SAS Press is here to support you with books […]

Top Books for SAS Programmers was published on SAS Users.