Proc SQL by Example: Using SQL Within SAS (Paperback)

The Rewards Program that Pays for Itself
  • EARN 5 to 40%
    Earn 5% in Club O Rewards on every order & up to 40% on select items.
  • FREE SHIPPING Every Order, Every Day*
    No matter how big or small, your order always ships for free.
  • VIP ACCESS
    Dedicated customer service and early access to exclusive deals.
  • RISK FREE
    Club O pays for itself, or we make up the difference
Today: $46.73
ITEM# 11493695
  • Delivery Estimate

    Select a Product Option to view shipping

    • Product Alerts

      Stay in the know! Choose which alerts you’d like to receive on this product.

    Proc SQL by Example: Using SQL Within SAS (Paperback)
    CHOOSE A LIST
    • Wishlists
    • Save for Later

    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 ...

    Details

    ITEM#: 11493695

    Howard Schreier, an independent consultant and trainer, has been a SASĀ® user since 1981. He has presented numerous papers at various SAS user group meetings, and has served as section chair at several SAS conferences. He has contributed around 7,000 posts to the SAS-L mailing list over 20 years, and is a member of the SAS-L Hall of Fame. Howard received his BA in Economics from the University of Michigan in 1976 and his MPh in Economics from The George Washington University in 1983.
    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. SAS Products and Releases: Base SAS: 9.2 Operating Systems: All

    Specs

    ISBN 9781599942971
    Genre COMPUTERS / Mathematical & Statistical Software
    Format Paperback
    Pages 284
    Publisher Date 2008-09-22 00:00:00.0
    Publisher Sas Inst
    Copyright Year 2008
    Height 8.75 in
    Wdth 7.25 in
    Thickness 0.25 in
    Unit weight 1.1 lb
    Language English
    Subtitle Using SQL Within SAS
    Audience College/higher education
    Authors Schreier, Howard

    Product Reviews

    Questions & Answers

    Yay! Be the first to ask a question about this product.
    Get your product questions answered right here.
    Guidelines

    Shopping Tips & Inspiration

    Shipping & Returns

    Shipping:

    This item will be delivered to you via USPS Trackable Media Mail or UPS Mail Innovations and will take from 2 days to 3 weeks from the time the item leaves our warehouse. *

    Standard Return Policy:

    Items must be returned in new or unused condition and contain all original materials included with the shipment. More Details

    FINAL SALE EXCLUSION: Items marked as FINAL SALE are not returnable unless the problem you experience is the result of our error.

    * For your protection, all orders are screened for security purposes. If your order is selected for review, our Loss Prevention Team may contact you by phone or email. There may be a two business day delay to process your order.

    ** Most Oversize orders are delivered within 1-4 weeks. Some orders may take 6 weeks to be delivered.