Items related to PROC SQL by Example: Using SQL within SAS
Synopsis
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.
"synopsis" may belong to another edition of this title.
About the Author
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.
"About this title" may belong to another edition of this title.
- PublisherSAS Institute
- Publication date2008
- ISBN 10 1599942976
- ISBN 13 9781599942971
- BindingPaperback
- LanguageEnglish
- Number of pages304
Search results for PROC SQL by Example: Using SQL within SAS
Stock Image
PROC SQL by Example : Using SQL Within SAS
Seller: Better World Books, Mishawaka, IN, U.S.A.
Seller rating 5 out of 5 stars
Condition: Very Good. Used book that is in excellent condition. May show signs of wear or have minor defects. Seller Inventory # 17147025-6
Quantity: 1 available
Stock Image
PROC SQL by Example: Using SQL Within SAS
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. No Jacket. Former library book; May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1.22. Seller Inventory # G1599942976I4N10
Quantity: 1 available
Stock Image
PROC SQL by Example: Using SQL Within SAS
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1.22. Seller Inventory # G1599942976I4N00
Quantity: 1 available
Stock Image
PROC SQL by Example: Using SQL Within SAS
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 1.22. Seller Inventory # G1599942976I3N00
Quantity: 1 available
Stock Image
PROC SQL by Example: Using SQL within SAS
Seller: Reuseabook, Gloucester, GLOS, United Kingdom
Seller rating 5 out of 5 stars
paperback. Condition: Used; Very Good. Dispatched, from the UK, within 48 hours of ordering. Though second-hand, the book is still in very good shape. Minimal signs of usage may include very minor creasing on the cover or on the spine. Grubby book may have mild dirt or some staining, mostly on the edges of pages. Seller Inventory # CHL10426330
Quantity: 1 available
Seller Image
PROC SQL by Example: Using SQL within SAS
Seller: Goodwill of Greater Milwaukee and Chicago, Racine, WI, U.S.A.
Seller rating 5 out of 5 stars
Condition: acceptable. Book is considered to be in acceptable condition. The actual cover image may not match the stock photo. Book may have one or more of the following defects: noticeable wear on the cover dust jacket or spine; curved, dog eared or creased page s ; writing or highlighting inside or on the edges; sticker s or other adhesive on cover; CD DVD may not be included; and book may be a former library copy. Seller Inventory # SEWV.1599942976.A
Quantity: 1 available
Seller Image
Proc SQL by Example : Using SQL Within SAS
Seller: GreatBookPricesUK, Woodford Green, United Kingdom
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # 5972143-n
Quantity: Over 20 available
Stock Image
PROC SQL by Example: Using SQL Within SAS
Seller: Chiron Media, Wallingford, United Kingdom
Seller rating 5 out of 5 stars
PF. Condition: New. Seller Inventory # 6666-IUK-9781599942971
Quantity: 10 available
Stock Image
PROC SQL by Example: Using SQL within SAS
Seller: Ria Christie Collections, Uxbridge, United Kingdom
Seller rating 5 out of 5 stars
Condition: New. In. Seller Inventory # ria9781599942971_new
Quantity: Over 20 available
Stock Image
PROC SQL by Example Using SQL within SAS
Print on DemandSeller: PBShop.store UK, Fairford, GLOS, United Kingdom
Seller rating 4 out of 5 stars
PAP. Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # L0-9781599942971
Quantity: Over 20 available