SQL: How Do You Do This in SAS? (Chrome Web Store)

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 about SQL, illustrated by code samples which can be sent by email directly from the app. The series of ebooks has been designed to encourage users to contribute questions some of which will be included in future versions of the app.

Description

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 about SQL, illustrated by code samples which can be sent by email directly from the app. The series of ebooks has been designed to encourage users to contribute questions some of which will be included in future versions of the app. An email client must have been installed and set up prior to the first use of this app, otherwise the features involving email will cause the app the terminate!

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=

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: