SQL: How Do You Do This in SAS? is one of a series of eBooks about SAS software programming focusing on frequently asked questions…
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.
The questions, with answers, included are:
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=