{"product_id":"proc-sql-by-example-using-sql-within-sas","title":"PROC SQL by Example: Using SQL within SAS","description":"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.\nUsing 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.\nTopics 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.\nThis 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.\u003cbr\u003eASIN: 1599942976\u003cbr\u003eVSKU: BVV.1599942976.A\u003cbr\u003eCondition: Acceptable\u003cbr\u003eAuthor\/Artist:Schreier, Howard\u003cbr\u003eBinding: Paperback\u003cbr\u003e\u003cb\u003eNote:\u003c\/b\u003e Any images shown are stock photographs and product may differ from what is shown.  \u003cbr\u003e\u003cb\u003eCondition Notes\u003c\/b\u003e: The item is very worn but is perfectly usable. Signs of wear can include aesthetic issues such as scratches, dents, worn and creased covers, folded page corners and minor liquid stains. All pages and the cover are intact, but the dust cover may be missing. Pages may include moderate to heavy amount of notes and highlighting, but the text is not obscured or unreadable. Page edges may have foxing  age related spots and browning . May NOT include discs, access code or other supplemental materials.  \u003cbr\u003e","brand":"Blue Vase Books","offers":[{"title":"Default Title","offer_id":43337014411325,"sku":"BVV.1599942976.A","price":7.62,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0589\/4225\/9261\/files\/1599942976-0.jpg?v=1783816414","url":"https:\/\/www.bluevasebooks.com\/products\/proc-sql-by-example-using-sql-within-sas","provider":"Blue Vase Books","version":"1.0","type":"link"}