ppt课件-preventingdatalosswhencombiningsasdatasets.pptVIP

Preventing data loss when combining SAS datasets. John Cantrell Univ. North Carolina Chapel Hill, NC SAS has powerful tools for dataset combination Proc SQL SAS data step SAS data step Datastep methods use SET, MERGE, and BY statements The workhorses: Matched merge concatenation. Data twothree; merge two three;run; Forgot BY statement, yields 1 to 1 merge instead of matched merge LOG: errors, warnings notes Unintentional 1 to 1 merge caught with “options mergenoby=error;” Error messages in the LOG help to find mistakes Not all problems yield error messages: the note, “repeats of BY v