SAS course: PROC SQL (Amazon Appstore)

This app, “SAS course: PROC SQL”, is one of a series of SAS course eBooks, illustrated by code samples which can be sent by email directly from the app. It is designed to encourage users to contribute topics some of which will be included in future versions of the app. There are controls to select specific topics, move to the previous or next topic, decrease or increase the font to suit the user's preference, and send emails requesting topics not yet included in that version of the eBook.

Categories: , , Tags: , , , , , , , , , , , , ,

Description

Loading

This app, “SAS course: PROC SQL”, is one of a series of SAS course eBooks, illustrated by code samples which can be sent by email directly from the app. It is designed to encourage users to contribute topics some of which will be included in future versions of the app. There are controls to select specific topics, move to the previous or next topic, decrease or increase the font to suit the user’s preference, and send emails requesting topics not yet included in that version of the eBook.

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 topics included are:

  1. Introduction
  2. About the Author: Philip R Holland
  3. [F1] What is PROC SQL?
  4. [F2] SELECT & FROM
  5. [F3] ORDER BY
  6. [F4] GROUP BY, HAVING & summary functions
  7. [F5.1] Joins, WHERE & ON – Introduction
  8. [F5.2] Joins, WHERE & ON – JOIN & UNION
  9. [F5.3] Joins, WHERE & ON – Sub-queries
  10. [F6] DISTINCT
  11. [F7] CREATE
  12. [F8] DROP
  13. [F9] DELETE FROM
  14. [F10] INSERT INTO
  15. [F11] UPDATE
  16. [F12] ALTER TABLE
  17. [F13] Limitations

Reviews

There are no reviews yet.

Be the first to review “SAS course: PROC SQL (Amazon Appstore)”

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

Related products

  • Macros: How Do You Do This in SAS? (Amazon Appstore)

    Macros: How Do You Do This in SAS? (Amazon Appstore)

    This app, “Macros: 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 SAS macros, 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.

    Buy product
    Quick View

  • SAS Programming and Data Visualization Techniques (Amazon.com)

    SAS Programming and Data Visualization Techniques (Amazon.com)

    SAS Programming and Data Visualization Techniques: A Power User’s Guide brings together a wealth of ideas about strategic and tactical solutions to everyday situations experienced when transferring, extracting, processing, analyzing, and reporting data. Most of the solutions can be achieved using the SAS components you already license, eliminating the need to throw money at the problems.

    Buy product
    Quick View

  • SAS Programming and Data Visualization Techniques (Amazon.co.uk)

    SAS Programming and Data Visualization Techniques (Amazon.co.uk)

    SAS Programming and Data Visualization Techniques: A Power User’s Guide brings together a wealth of ideas about strategic and tactical solutions to everyday situations experienced when transferring, extracting, processing, analyzing, and reporting data. Most of the solutions can be achieved using the SAS components you already license, eliminating the need to throw money at the problems.

    Buy product
    Quick View

  • Saving Time and Money using SAS (Amazon.co.uk)

    Saving Time and Money using SAS (Amazon.co.uk)

    Get the most from your SAS software! In this expert collection of strategic and tactical solutions, author Philip Holland shows you how to save time and money by making the most of your SAS software. You'll gain a deeper knowledge of your existing SAS components, improve your coding efficiency, and learn how to develop applications that are easier to maintain. Filled with invaluable tips and hints and with coding examples that can be adapted to your specific projects, this book is the ultimate reference source that you will reach for again and again as you develop your business processes.

    Buy product
    Quick View