Transcription of 149-2012: Queries, Joins, and WHERE Clauses, Oh …
{{id}} {{{paragraph}}}
SAS Global Forum 2012 Hands-on Workshops Paper 149-2012. queries , joins , and WHERE clauses , Oh My!! Demystifying PROC SQL. Christianna S. Williams, Chapel Hill, NC. ABSTRACT. Subqueries, inner joins , outer joins , HAVING expressions, set operators just the terminology of PROC SQL might intimidate SAS programmers accustomed to getting the DATA step to do our bidding for data manipulation. Nonetheless, even DATA step die-hards must grudgingly acknowledge that there are some tasks, such as the many- to-many merge or the "not-quite-equi-join," requiring Herculean effort to achieve with DATA steps, that SQL can accomplish amazingly concisely, even elegantly. Through increasingly complex examples, this workshop illustrates each of PROC SQL's clauses , with particular focus on problems difficult to solve with traditional SAS code.
Paper 149-2012 Queries, Joins, and WHERE Clauses, Oh My!! Demystifying PROC SQL Christianna S. Williams, Chapel Hill, NC ABSTRACT Subqueries, inner joins, outer joins, HAVING expressions, set operators…just the terminology of PROC SQL might
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}
Step-by-Step Introduction to PROC, Step-by-Step Introduction to PROC REPORT, PROC REPORT, Introduction, Report, PROC Report PROC, PROC, Step, Using the COMPUTE Block in PROC REPORT, To PROC REPORT, Understanding the SAS® DATA Step, PROC REPORT: Compute Block Basics --, PROC REPORT: Compute Block Basics – Part, By-Step Programming with Base SAS Software, By-Step Programming with Base SAS® Software