Transcription of 178-2008: Joining Data: DATA Step Merge or SQL?
{{id}} {{{paragraph}}}
Example: marketing
178-2008: Joining Data: DATA Step Merge or SQL?
1 Paper 178- 2008 Joining data : data step Merge or SQL? Harry Droogendyk, Stratia Consulting Inc., Lynden, ON Faisal Dosani, RBC Royal Bank, Toronto, ON ABSTRACT This paper explores the Joining of datasets / tables using both the data step Merge and PROC SQL. Similarities between the two methods are identified and occasions when one method might be preferred over the other are discussed. Specific issues relating to INNER, OUTER and FULL joins are covered, as are the vagaries of the SQL ON vs. WHERE clauses. An array of examples will illustrate exactly how joins are accomplished in both data step and SQL environments.
Dec 14, 2007 · 2 THE DATA This paper will use two different sets of data to illustrate the join dynamics using data step MERGE and SQL JOIN. The initial data is a small subset ( found in the Appendix A ) used to illustrate the effect of the various
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
PE Pipe Joining Procedures, Together, Joining together, Joining, MERGING vs. JOINING: Comparing the DATA Step, 30: Merging versus Joining: Comparing the, GOVERNMENT OF RAJASTHAN FINANCE DEPARTMENT, Government of rajasthan finance department rules division, JOINING OF PLASTICS AND COMPOSITES, Opening Activity/Dialogue