「SASコース:PROCのSQLは」アプリは電子メールで送信することができ、コードとSASのコース電子ブックです
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.
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