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
Seller Image
PROC SQL by Example: Using SQL within SAS
Seller: Books for Life, LAUREL, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: good. Book is in good condition. Minimal signs of wear. It May have markings or highlights, but kept to only a few pages. May not come with supplemental materials if applicable. Seller Inventory # LFM.5NBP
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: 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-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: HPB-Red, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_381760601
Quantity: 1 available
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
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
Stock Image
PROC SQL by Example: Using SQL within SAS
Seller: Grumpys Fine Books, Tijeras, NM, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: very good. little wear and tear. Seller Inventory # Grumpy1599942976
Quantity: 1 available
Stock Image
PROC SQL by Example: Using SQL within SAS
Seller: Lucky's Textbooks, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # ABLIING23Mar2811580102940
Quantity: Over 20 available
Seller Image
Proc SQL by Example : Using SQL Within SAS
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # 5972143-n
Quantity: Over 20 available