On GameFAQs: The top 10 strangest game bosses
BNET Business Network:
BNET
TechRepublic
ZDNet

FREE Registration is required

Overview:

Merging two data sets horizontally is a routine data manipulation task that SAS programmers perform almost daily. CPU time, I/O, and memory usage are factors that SAS programmers need to consider before data sets with large volumes are merged. This paper outlines different SAS merging techniques for both a many-to-one match, and a many-to-many match. For a many-to-one match, MERGE, PROC SQL JOIN, FORMAT, ARRAY, and the HASH object were investigated, and their performances were benchmarked. For a many-to-many match, PROC SQL join and MATCH-CROSSING methods were discussed, and their performances were compared. This paper shows that the HASH object is the best choice to perform a many-to-one match no matter single value or multiple values are retrieved from lookup table.

(Is this item miscategorized? Does it need more tags? Let us know.)

Format:PDFSize:48 KB
Date:Feb 2009
Pages:9

Top results from Programming Languages

White Paper Designing High Availability for Internet Information Services
White Paper Citizants: Bringing IT In-House
White Paper Surviving and Thriving in the Customer-Driven Age
White Paper The Pursuit of a Standardized Solution for Secure Enterprise RBAC
White Paper Supporting Employees Anytime, Anywhere

» View all Programming Languages listings

Top results from Knowledge and Data Management

White Paper Business Continuity Planning - IT Survival Guide
White Paper Total Economic Impact of SQL Server 2008 Upgrade
White Paper Twelve Ways to Reduce Costs with Microsoft® SQL Server® 2008
White Paper Techical Whitepaper: Configuring Deduplication for High Performance
White Paper Whitepaper: Fast, Reliable Data protection from Dell and CommVault

» View all Knowledge and Data Management listings

advertisement

White Papers, Webcasts, and Resources

Featured Training Courses

advertisement

Enterprise Applications

  • Check out some of the easiest and most powerful ways to boost productivity while saving money on your application infrastructure. See ZDNet's comprehensive Enterprise Application resource center, now!
  • New Online Dashboard
  • Read about top issues IT decision-makers face every day, plus get cost effective solutions to real life IT problems. Oracle Topline

Returning users: Log In Here!

Already registered on BNET, TechRepublic, or ZDNet? Simply log in.

Free Membership: Sign Up Now!

Sign up for a free membership today and get instant and unlimited access to one of the largest databases of white papers, webcasts, and casestudies anywhere. Your FREE membership allows you to:

  • Download an unlimited amount of content, including classic and current white papers, case studies, webcasts and more
  • Track content on your chosen topics of interest
  • Receive targeted email alerts when your favorite content is added
  • Save content for future reading
  • Receive our member newsletter

When you register to access this library, you allow us to share your information with companies that produce products or services featured in the library--so that such companies may contact you with information and offers regarding their products and services. This enables us to keep the library a free service. As a library registrant, you will receive a complimentary subscription to the ZDNet white paper newsletter and e-mail Must-Read News Alerts. You can unsubscribe from these at any time. By clicking the Sign up button, you indicate that you agree to our Terms and Conditions and have read and understand our Privacy Policy (updated).