2381－SGF2018－Comparisons_of_Large_Complex_Data_Sets_with_Matching_Common_Dimensions_to_catch_any_Changes_using_SAS.pptx

Comparisons of Large Complex Data Sets with Matching Common Dimensions to catch any Changes using SAS? Enterprise GuideKaiqing Fan, Mastech Digital Inc., Brecksville, OhioSAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ? indicates USA registration. Other brand and product names are trademarks of their respective companies.CONCLUSIONSComparisons of Large Complex Data Sets with Matching Common Dimensions to catch any Changes using SAS? EGKaiqing Fan, Mastech Digital Inc.AbstractKey wordsToday, with the tremendous size of data files and frequent changes, comparing complex, large data files is a growing challenge. It is impossible to only use PROC COMPARE to catch the differences between current and previous large, complex data files with same data structure but different numbers of observations and lots of changes. Fortunately, SAS offers a simple solution. We split the current and previous data into three parts: 1) the common dimensions with modified values exists in current and previous data files; 2) an additional part new added into current data file; and 3) an additional part dropped from previous data file. Then we can compare the common dimensions, catch what was modified; and catch the additional parts in current and previous data.PROC COMPARE large and complex data files comparison, Red: the additional part new added into current data;Green: the additional part dropped from previous data;Yellow: the common dimensions part modified in both data files;SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ? indicates USA registration. Other brand and product names are trademarks of their respective companies.Comparisons of Large Complex Data Sets with Matching Common Dimensions to catch any Changes using SAS? EGCONCLUSIONSKaiqing Fan, Mastech Digital In