SQL: How Do You Do This in SAS?

This app, "SQL: How Do You Do This In SAS?", is one of a series of eBooks about SAS software programming focusing on frequently asked questions and answers, illustrated by code samples which can be sent by email directly from the app. It is designed to encourage users to contribute questions some of which will be included in future versions of the app. There are controls to select specific questions, move to the previous or next question, decrease or increase the font to suit the user's preference, and send emails requesting answers to questions not yet included in that version of the eBook.

It uses controls to select specific questions (click on the button or drop-down next to the title), move to the previous [Pg-] or next [Pg+] question, decrease [A-] or increase [A+] the font to suit the user's preference, and send emails requesting answers to questions not yet included in that version of the eBook [Ask ?]. The code samples that can be sent via email have white backgrounds, and open the email client when clicked.

The questions, with answers, included are:

• 1. Introduction

  2. About the Author: Philip R Holland

  3. Updating data with related records

  4. Merging data using ranges

  5. Finding duplicate observations

  6. Selecting variables beginning with 'S'

  7. Using look-up tables with PROC SQL

  8. What is the difference between DROP and DROP=, and KEEP and KEEP=

There is also an index of key words from version 1.0 onwards.

The app can be downloaded from Amazon Appstore and Google Play (Android Market). The app on Google Play uses Google Play Licensing from version 1.0.2 onwards.