SAS course: PROC SQL - Philip R Holland (February 2018)

This PDF ebook is a copy of the topics in the PROC SQL section of the SAS course in the SAS Programming Forum on the blog site and is available from Lulu.com. All code included in the PDF ebook can be copied and pasted into SAS to try it out yourself.

There are also Android apps available from Google Play and Amazon Appstore, which include the same course notes.

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:

• • Introduction

  • About the Author: Philip R Holland

  • [F1] What is PROC SQL?

  • [F2] SELECT & FROM

  • [F3] ORDER BY

  • [F4] GROUP BY, HAVING & summary functions

  • [F5.1] Joins, WHERE & ON - Introduction

  • [F5.2] Joins, WHERE & ON - JOIN & UNION

  • [F5.3] Joins, WHERE & ON - Sub-queries

  • [F6] DISTINCT

  • [F7] CREATE

  • [F8] DROP

  • [F9] DELETE FROM

  • [F10] INSERT INTO

  • [F11] UPDATE

  • [F12] ALTER TABLE

  • [F13] Limitations

Other related links:

• • Lulu.com page: www.lulu.com/shop/ebook/product-23528322.html

  • Google Play Store page: play.google.com/store/apps/details?id=com.hollandnumerics.sasprocsqla

  • Amazon Appstore pages: www.amazon.com/dp/B079112ZK9, www.amazon.co.uk/dp/B079112ZK9