PROC SQL by Example: Using SQL within SAS (Perfect Paperback)

Howard Schreier

  • 出版商: SAS Press
  • 出版日期: 2008-09-01
  • 售價: $2,410
  • 貴賓價: 9.5$2,290
  • 語言: 英文
  • 頁數: 304
  • 裝訂: Perfect Paperback
  • ISBN: 1599942976
  • ISBN-13: 9781599942971
  • 相關分類: SQL
  • 下單後立即進貨 (約1週~2週)

買這商品的人也買了...

商品描述

In PROC SQL by Example: Using SQL within SAS, author Howard Schreier illustrates the use of PROC SQL in the context of the SAS DATA step and other SAS procedures (such as SORT, FREQ, MEANS, SUMMARY, APPEND, DATASETS, and TRANSPOSE) whose functionality overlaps and complements that of SQL.

Using a side-by-side approach, this concise reference guide includes many extensively explained examples showing equivalent DATA step and SQL code, enabling SAS users to take advantage of existing SAS skills and knowledge while learning about SQL. Discussions cover the differences between SQL and the DATA step as well as situations where SQL and the DATA step are used together to benefit from the strengths of each.

Topics addressed include working with joins and merges; using subqueries; understanding set operators; using the Macro Facility with PROC SQL; maintaining tables; working with views; using PROC SQL as a report generator; and more.

This text is ideal for SAS programmers seeking to add PROC SQL to their SAS toolkits as well as SQL programmers striving to better integrate the SAS DATA step and SQL.

商品描述(中文翻譯)

在《PROC SQL by Example: Using SQL within SAS》一書中,作者Howard Schreier以SAS DATA步驟和其他SAS程序(如SORT、FREQ、MEANS、SUMMARY、APPEND、DATASETS和TRANSPOSE)的背景下,演示了如何使用PROC SQL。這些程序的功能與SQL重疊並互補。這本簡明參考指南使用並列的方式,包含了許多詳細解釋的例子,展示了等效的DATA步驟和SQL代碼,讓SAS用戶能夠利用現有的SAS技能和知識來學習SQL。討論的內容包括SQL和DATA步驟之間的差異,以及在哪些情況下可以將SQL和DATA步驟結合使用,以充分發揮各自的優勢。主題涵蓋了處理連接和合併的方法,使用子查詢,了解集合運算符,使用Macro Facility與PROC SQL,維護表格,使用視圖,將PROC SQL用作報表生成器等等。這本書非常適合希望將PROC SQL添加到其SAS工具包中的SAS程序員,以及希望更好地整合SAS DATA步驟和SQL的SQL程序員。