Proc Compare to Validate Datasets
Proc Compare to Validate Datasets Angelina Cecilia Casas , PPD Development, Research Triangle Park, NC. Variables Summary Number of Variables in Common: 3. ABSTRACT. Comparison of two Datasets is a technique used to know that two Observation Summary Datasets are equal or if they have discrepancies. This method can be used to Validate that a dataset has been created correctly Observation Base Compare or that the changes in a dataset are only those that are expected. observations were added or removed or corrections were First Obs 1 1. done. Last Obs 4 4. Number of Observations in Common: 4. INTRODUCTION Total Number of Observations Read from Proc Compare is a procedure that allows two Datasets to be : 4. compared for properties, number of observations, number of Total Number of Observations Read from variables, and properties of the Datasets . : 4. For a variable, you can get output about differences in: Number of Observations with Some Compared Variables Type, length, formats, informats and label(s).
proc compare data=demog compare=compare transpose; id unique ; run; Unique=20110: Variable Base Value Compare Diff. % Diff WEIGHTKG 85.7 85.0 -0.700000 -0.816803 dob 09/17/1949 09/14/1949 -3.000000 0.079830 Unique=20120: Variable Base Value Compare Diff. % Diff WEIGHTKG 101.6 101.0 -0.600000 -0.590551 dob 08/19/1949 08/16/1949 -3.000000 0 ...
Download Proc Compare to Validate Datasets
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: