Transcription of Advanced Match Merging: Techniques, Tricks, and Traps
{{id}} {{{paragraph}}}
Example: bachelor of science
Advanced Match Merging: Techniques, Tricks, and Traps
AdvancedMATCH- Merging: Techniques, tricks , ,NCABSTRACTM atch- merging ,orBYmerging,isthemostcommon mergingtechniqueusedinSAS**.Yet, snuancesandsubtleties,givesexamplesofmer geswhereevenexperiencedprogrammershavebe entrippedup, ,attheoffice, : TheSASmergeisasubtlething ;or Mergeshouldbemadetoworkbetterinthissitua tion ;or Beverycarefidwithusingmergeinthiscasebec auseyougetunexpectedresults! ,sortedmeansthattheinputfileshaveacommon keyandthattherecordsineachfileareordered accordingtothekeyfield(s).Considerthefol lowingtwoinputfiles, !MA04FA05 KAYAlOJIM11 MEvenwiththissimpleexample, (fileONE)andA04(fileTWO) :PROCSORTOATA=ONE:BYIO:RUN;PROCSORTOATA= TWO:BYIO:RUN:OATAONETWO;tllR~~ONETWO;RUN : Thiscodeissimpleenough, ,forsure,thattheinputdatasetsarealreadys ortedthentheSAScodecouldbereducedto:DATA ONETWO;t44R~~ONETWO;RUN; Now,whatcouldbesimpler?Well, , ;MERGELINETWO:RUN; (AY47 FAlOJIM11 MNoticethattheA05 IDislostinthismergeandtheNameKayismovedf i-omID=A05toID=A04, ,ontheotherhand, , , , ~ ,thereisonlyonekeyvariableanditidentifie stheunitofdatatherecordisassociatedwith, suchasapatient,accountnumber,transaction number,household,interviewee, ,goodBYvariablesarekeyvariablesthatEXACT LY identi~ , , :(1)theBYvariabledoesnotuniquelyidentifi therecord(ambiguousidentification);and(2 ) ,time,anddateareambiguous, ,thesetypesofitemsdonotreliablyidenti~ ,forexample, ,l)
Advanced MATCH-MERGING: Techniques, Tricks, and Traps Malachy J. Foley University of North Carolina at Chapel Hill, NC ABSTRACT Match-merging, or BY merging, is the most common
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: