Sarika-QC-DM

10 views
Skip to first unread message

Sarika

unread,
Feb 9, 2015, 2:49:33 PM2/9/15
to anova...@googlegroups.com

The SAS System

The COMPARE Procedure                                                                                                                                                                                                                                           
Comparison of SDTM102.DM with WORK.FINAL_DM                                                                                                                                                                                                                     
(Method=EXACT)                                                                                                                                                                                                                                                  
                                                                                                                                                                                                                                                                
Data Set Summary                                                                                                                                                                                                                                                
                                                                                                                                                                                                                                                                
Dataset                 Created          Modified  NVar    NObs                                                                                                                                                                                                 
                                                                                                                                                                                                                                                                
SDTM102.DM     19DEC14:17:49:01  19DEC14:17:49:01    15      60                                                                                                                                                                                                 
WORK.FINAL_DM  09FEB15:14:40:06  09FEB15:14:40:06    23      60                                                                                                                                                                                                 
                                                                                                                                                                                                                                                                
                                                                                                                                                                                                                                                                
Variables Summary                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                                
Number of Variables in Common: 15.                                                                                                                                                                                                                              
Number of Variables in WORK.FINAL_DM but not in SDTM102.DM: 8.                                                                                                                                                                                                  
                                                                                                                                                                                                                                                                
                                                                                                                                                                                                                                                                
Observation Summary                                                                                                                                                                                                                                             
                                                                                                                                                                                                                                                                
Observation      Base  Compare                                                                                                                                                                                                                                  
                                                                                                                                                                                                                                                                
First Obs           1        1                                                                                                                                                                                                                                  
First Unequal       1        1                                                                                                                                                                                                                                  
Last  Unequal      60       60                                                                                                                                                                                                                                  
Last  Obs          60       60                                                                                                                                                                                                                                  
                                                                                                                                                                                                                                                                
Number of Observations in Common: 60.                                                                                                                                                                                                                           
Total Number of Observations Read from SDTM102.DM: 60.                                                                                                                                                                                                          
Total Number of Observations Read from WORK.FINAL_DM: 60.                                                                                                                                                                                                       
                                                                                                                                                                                                                                                                
Number of Observations with Some Compared Variables Unequal: 60.                                                                                                                                                                                                
Number of Observations with All Compared Variables Equal: 0.                                                                                                                                                                                                    
                                                                                                                                                                                                                                                                
                                                                                                                                                                                                                                                                
Values Comparison Summary                                                                                                                                                                                                                                       
                                                                                                                                                                                                                                                                
Number of Variables Compared with All Observations Equal: 13.                                                                                                                                                                                                   
Number of Variables Compared with Some Observations Unequal: 2.                                                                                                                                                                                                 
Number of Variables with Missing Value Differences: 1.                                                                                                                                                                                                          
Total Number of Values which Compare Unequal: 120.                                                                                                                                                                                                              
Maximum Difference: 140.                                                                                                                                                                                                                                        
                                                                                                                                                                                                                                                                
                                                                                                                                                                                                                                                                
Variables with Unequal Values                                                                                                                                                                                                                                   
                                                                                                                                                                                                                                                                
Variable  Type  Len   Label    Ndif   MaxDif  MissDif                                                                                                                                                                                                           
                                                                                                                                                                                                                                                                
AGE       NUM     8   Age        60      140        0                                                                                                                                                                                                           
COUNTRY   CHAR    3   Country    60                60                                                                                                                                                                                                           
                                                                                                                                                                                                                                                                

The SAS System

The COMPARE Procedure                                                                                                                                                                                                                                           
Comparison of SDTM102.DM with WORK.FINAL_DM                                                                                                                                                                                                                     
(Method=EXACT)                                                                                                                                                                                                                                                  
                                                                                                                                                                                                                                                                
Value Comparison Results for Variables                                                                                                                                                                                                                          
                                                                                                                                                                                                                                                                
__________________________________________________________                                                                                                                                                                                                      
           ||  Age                                                                                                                                                                                                                                              
           ||       Base    Compare                                                                                                                                                                                                                             
       Obs ||        AGE        AGE      Diff.     % Diff                                                                                                                                                                                                       
 ________  ||  _________  _________  _________  _________                                                                                                                                                                                                       
           ||                                                                                                                                                                                                                                                   
        1  ||    36.0000   -36.0000   -72.0000  -200.0000                                                                                                                                                                                                       
        2  ||    63.0000   -63.0000  -126.0000  -200.0000                                                                                                                                                                                                       
        3  ||    31.0000   -31.0000   -62.0000  -200.0000                                                                                                                                                                                                       
        4  ||    37.0000   -37.0000   -74.0000  -200.0000                                                                                                                                                                                                       
        5  ||    31.0000   -31.0000   -62.0000  -200.0000                                                                                                                                                                                                       
        6  ||    32.0000   -32.0000   -64.0000  -200.0000                                                                                                                                                                                                       
        7  ||    61.0000   -61.0000  -122.0000  -200.0000                                                                                                                                                                                                       
        8  ||    43.0000   -43.0000   -86.0000  -200.0000                                                                                                                                                                                                       
        9  ||    39.0000   -39.0000   -78.0000  -200.0000                                                                                                                                                                                                       
       10  ||    59.0000   -59.0000  -118.0000  -200.0000                                                                                                                                                                                                       
       11  ||    31.0000   -31.0000   -62.0000  -200.0000                                                                                                                                                                                                       
       12  ||    62.0000   -62.0000  -124.0000  -200.0000                                                                                                                                                                                                       
       13  ||    68.0000   -68.0000  -136.0000  -200.0000                                                                                                                                                                                                       
       14  ||    31.0000   -31.0000   -62.0000  -200.0000                                                                                                                                                                                                       
       15  ||    42.0000   -42.0000   -84.0000  -200.0000                                                                                                                                                                                                       
       16  ||    52.0000   -52.0000  -104.0000  -200.0000                                                                                                                                                                                                       
       17  ||    44.0000   -44.0000   -88.0000  -200.0000                                                                                                                                                                                                       
       18  ||    50.0000   -50.0000  -100.0000  -200.0000                                                                                                                                                                                                       
       19  ||    39.0000   -39.0000   -78.0000  -200.0000                                                                                                                                                                                                       
       20  ||    29.0000   -29.0000   -58.0000  -200.0000                                                                                                                                                                                                       
       21  ||    36.0000   -36.0000   -72.0000  -200.0000                                                                                                                                                                                                       
       22  ||    56.0000   -56.0000  -112.0000  -200.0000                                                                                                                                                                                                       
       23  ||    70.0000   -70.0000  -140.0000  -200.0000                                                                                                                                                                                                       
       24  ||    40.0000   -40.0000   -80.0000  -200.0000                                                                                                                                                                                                       
       25  ||    31.0000   -31.0000   -62.0000  -200.0000                                                                                                                                                                                                       
       26  ||    43.0000   -43.0000   -86.0000  -200.0000                                                                                                                                                                                                       
       27  ||    47.0000   -47.0000   -94.0000  -200.0000                                                                                                                                                                                                       
       28  ||    33.0000   -33.0000   -66.0000  -200.0000                                                                                                                                                                                                       
       29  ||    40.0000   -40.0000   -80.0000  -200.0000                                                                                                                                                                                                       
       30  ||    45.0000   -45.0000   -90.0000  -200.0000                                                                                                                                                                                                       
       31  ||    33.0000   -33.0000   -66.0000  -200.0000                                                                                                                                                                                                       
       32  ||    44.0000   -44.0000   -88.0000  -200.0000                                                                                                                                                                                                       
       33  ||    37.0000   -37.0000   -74.0000  -200.0000                                                                                                                                                                                                       
       34  ||    53.0000   -53.0000  -106.0000  -200.0000                                                                                                                                                                                                       
       35  ||    49.0000   -49.0000   -98.0000  -200.0000                                                                                                                                                                                                       
       36  ||    43.0000   -43.0000   -86.0000  -200.0000                                                                                                                                                                                                       
       37  ||    49.0000   -49.0000   -98.0000  -200.0000                                                                                                                                                                                                       
       38  ||    38.0000   -38.0000   -76.0000  -200.0000                                                                                                                                                                                                       
       39  ||    29.0000   -29.0000   -58.0000  -200.0000                                                                                                                                                                                                       
       40  ||    32.0000   -32.0000   -64.0000  -200.0000                                                                                                                                                                                                       
       41  ||    54.0000   -54.0000  -108.0000  -200.0000                                                                                                                                                                                                       
       42  ||    38.0000   -38.0000   -76.0000  -200.0000                                                                                                                                                                                                       
       43  ||    43.0000   -43.0000   -86.0000  -200.0000                                                                                                                                                                                                       
       44  ||    42.0000   -42.0000   -84.0000  -200.0000                                                                                                                                                                                                       
       45  ||    64.0000   -64.0000  -128.0000  -200.0000                                                                                                                                                                                                       

The SAS System

The COMPARE Procedure                                                                                                                                                                                                                                           
Comparison of SDTM102.DM with WORK.FINAL_DM                                                                                                                                                                                                                     
(Method=EXACT)                                                                                                                                                                                                                                                  
                                                                                                                                                                                                                                                                
Value Comparison Results for Variables                                                                                                                                                                                                                          
                                                                                                                                                                                                                                                                
__________________________________________________________                                                                                                                                                                                                      
           ||  Age                                                                                                                                                                                                                                              
           ||       Base    Compare                                                                                                                                                                                                                             
       Obs ||        AGE        AGE      Diff.     % Diff                                                                                                                                                                                                       
 ________  ||  _________  _________  _________  _________                                                                                                                                                                                                       
           ||                                                                                                                                                                                                                                                   
       46  ||    55.0000   -55.0000  -110.0000  -200.0000                                                                                                                                                                                                       
       47  ||    60.0000   -60.0000  -120.0000  -200.0000                                                                                                                                                                                                       
       48  ||    50.0000   -50.0000  -100.0000  -200.0000                                                                                                                                                                                                       
       49  ||    58.0000   -58.0000  -116.0000  -200.0000                                                                                                                                                                                                       
       50  ||    55.0000   -55.0000  -110.0000  -200.0000                                                                                                                                                                                                       
                                                                                                                                                                                                                                                                
NOTE: The MAXPRINT=50 printing limit has been reached for the variable AGE. No more values will be printed for this comparison.                                                                                                                                 
__________________________________________________________                                                                                                                                                                                                      
                                                                                                                                                                                                                                                                
                                                                                                                                                                                                                                                                
__________________________________________________________                                                                                                                                                                                                      
           ||  Country                                                                                                                                                                                                                                          
           ||  Base Value           Compare Value                                                                                                                                                                                                               
       Obs ||  COUNTRY               COUNTRY                                                                                                                                                                                                                    
 ________  ||  ___                   ___                                                                                                                                                                                                                        
           ||                                                                                                                                                                                                                                                   
        1  ||  USA                                                                                                                                                                                                                                              
        2  ||  USA                                                                                                                                                                                                                                              
        3  ||  USA                                                                                                                                                                                                                                              
        4  ||  USA                                                                                                                                                                                                                                              
        5  ||  USA                                                                                                                                                                                                                                              
        6  ||  USA                                                                                                                                                                                                                                              
        7  ||  USA                                                                                                                                                                                                                                              
        8  ||  USA                                                                                                                                                                                                                                              
        9  ||  USA                                                                                                                                                                                                                                              
       10  ||  USA                                                                                                                                                                                                                                              
       11  ||  USA                                                                                                                                                                                                                                              
       12  ||  USA                                                                                                                                                                                                                                              
       13  ||  USA                                                                                                                                                                                                                                              
       14  ||  USA                                                                                                                                                                                                                                              
       15  ||  USA                                                                                                                                                                                                                                              
       16  ||  USA                                                                                                                                                                                                                                              
       17  ||  USA                                                                                                                                                                                                                                              
       18  ||  USA                                                                                                                                                                                                                                              
       19  ||  USA                                                                                                                                                                                                                                              
       20  ||  USA                                                                                                                                                                                                                                              
       21  ||  USA                                                                                                                                                                                                                                              
       22  ||  USA                                                                                                                                                                                                                                              
       23  ||  USA                                                                                                                                                                                                                                              
       24  ||  USA                                                                                                                                                                                                                                              
       25  ||  USA                                                                                                                                                                                                                                              
       26  ||  USA                                                                                                                                                                                                                                              
       27  ||  USA                                                                                                                                                                                                                                              
       28  ||  USA                                                                                                                                                                                                                                              
       29  ||  USA                                                                                                                                                                                                                                              

The SAS System

The COMPARE Procedure                                                                                                                                                                                                                                           
Comparison of SDTM102.DM with WORK.FINAL_DM                                                                                                                                                                                                                     
(Method=EXACT)                                                                                                                                                                                                                                                  
                                                                                                                                                                                                                                                                
Value Comparison Results for Variables                                                                                                                                                                                                                          
                                                                                                                                                                                                                                                                
__________________________________________________________                                                                                                                                                                                                      
           ||  Country                                                                                                                                                                                                                                          
           ||  Base Value           Compare Value                                                                                                                                                                                                               
       Obs ||  COUNTRY               COUNTRY                                                                                                                                                                                                                    
 ________  ||  ___                   ___                                                                                                                                                                                                                        
           ||                                                                                                                                                                                                                                                   
       30  ||  USA                                                                                                                                                                                                                                              
       31  ||  USA                                                                                                                                                                                                                                              
       32  ||  USA                                                                                                                                                                                                                                              
       33  ||  USA                                                                                                                                                                                                                                              
       34  ||  USA                                                                                                                                                                                                                                              
       35  ||  USA                                                                                                                                                                                                                                              
       36  ||  USA                                                                                                                                                                                                                                              
       37  ||  USA                                                                                                                                                                                                                                              
       38  ||  USA                                                                                                                                                                                                                                              
       39  ||  USA                                                                                                                                                                                                                                              
       40  ||  USA                                                                                                                                                                                                                                              
       41  ||  USA                                                                                                                                                                                                                                              
       42  ||  USA                                                                                                                                                                                                                                              
       43  ||  USA                                                                                                                                                                                                                                              
       44  ||  USA                                                                                                                                                                                                                                              
       45  ||  USA                                                                                                                                                                                                                                              
       46  ||  USA                                                                                                                                                                                                                                              
       47  ||  USA                                                                                                                                                                                                                                              
       48  ||  USA                                                                                                                                                                                                                                              
       49  ||  USA                                                                                                                                                                                                                                              
       50  ||  USA                                                                                                                                                                                                                                              
                                                                                                                                                                                                                                                                
NOTE: The MAXPRINT=50 printing limit has been reached for the variable COUNTRY. No more values will be printed for this comparison.                                                                                                                             
__________________________________________________________                                                                                                                                                                                                      
Reply all
Reply to author
Forward
0 new messages