Data Steps: How Do You Do This in SAS?

This app, "Data Steps: 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. Carrying forward a non-missing value to following observations

  4. Separating duration data into periods

  5. Populating arrays with data values

  6. Processing a mixture of missing and non-missing values

  7. Rearranging variable values in a SAS data set

  8. Updating data with related records

  9. Reading Excel dates into SAS

  10. Selecting variables beginning with 'S'

  11. Creating and converting date/time values

  12. Using look-up tables with Data Step Merge

  13. Using look-up tables with SAS Formats

  14. Using look-up tables with generated IF..THEN..ELSE statements

  15. Using look-up tables with generated SELECT..WHEN..OTHERWISE statements

  16. How do you find out which numeric variable has an input error

  17. How do you find out which date/time variable has an input error

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

There is also an index of key words from version 2.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 2.0.3 onwards.