WW14
Merging, Combining, and Subsetting Files (Tricks, Traps, Techniques)
Sun, PM
Malachy J. Foley
University of North Carolina at Chapel Hill
Email: Foley@UNC.EDU
Abstract:
This workshop is for anyone who manipulates SAS data sets. It covers a wide range of topics including subsetting, concatenations, the IN= data set option, BY groups, FIRST.variable, one-to-one merges, match merges, and fuzzy merges.
The workshop starts wit
h the basics and builds up to complex and tricky examples of data set manipulation. The only prerequisite for the course is a working knowledge of the DATA step, but this workshop will give intermediate and advanced programmers a great review and some surp
rises. Come see what mysteries lurk in manipulating SAS files!
Biography:
Mal Foley is currently a Senior SAS Programmer/Analyst with the University of North Carolina at Chapel Hill. His career includes being an international computing consultant, a university professor, a manager of several computing departments, and the CEO of
his own computing company. Mal has consulted to IBM, Dow Chemical, the Ford-Rockefeller Foundation, the United Nations, the US Department of Agriculture, the US Agency for International Development, and many universities. He has taught dozens of computer
programming courses at the undergraduate, graduate, and professional levels. Mal regularly publishes papers and gives presentations at SUGI and regional SAS User Groups.