Is SDTM102.dm updated from source side?

15 views
Skip to first unread message

kardekardeepa

unread,
Feb 12, 2015, 6:06:14 PM2/12/15
to anova...@googlegroups.com
Hi Vikas , I was doing proc compare on source dm ie


proc compare data= sdtm102.dm compare= qcdm listall;
run;

I am still getting the discrepancies in source and  QC number of variables.  Please see below screenshot.
The SAS System

The COMPARE Procedure

Datasets

The COMPARE Procedure                                                                                                                                                                                                                                           
Comparison of SDTM102.DM with WORK.QCDM                                                                                                                                                                                                                         
(Method=EXACT)                                                                                                                                                                                                                                                  
                                                                                                                                                                                                                                                                
Data Set Summary                                                                                                                                                                                                                                                
                                                                                                                                                                                                                                                                
Dataset              Created          Modified  NVar    NObs                                                                                                                                                                                                    
                                                                                                                                                                                                                                                                
SDTM102.DM  19DEC14:17:49:01  19DEC14:17:49:01    15      60                                                                                                                                                                                                    
WORK.QCDM   12FEB15:17:57:55  12FEB15:17:57:55    23      60                                                                                                                                                                                                    
                                                                                                                                                                                                                                                                
                                                                                                                                                                                                                                                                
Variables Summary                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                                
Number of Variables in Common: 15.                                                                                                                                                                                                                              
Number of Variables in WORK.QCDM but not in SDTM102.DM: 8.                                                                                                                                                                                                      
Number of Variables with Differing Attributes: 2.      


and also there are more discrepancies like Site Id values are different in both the datasets.

                                                                                                                                                                                                                                                                
                                                                                                                                                                                                                                                                
Value Comparison Results for Variables                                                                                                                                                                                                                          
                                                                                                                                                                                                                                                                
__________________________________________________________                                                                                                                                                                                                      
           ||  Study Site Identifier                                                                                                                                                                                                                            
           ||  Base Value           Compare Value                                                                                                                                                                                                               
       Obs ||  SITEID                SITEID                                                                                                                                                                                                                     
 ________  ||  _______               _______                                                                                                                                                                                                                    
           ||                                                                                                                                                                                                                                                   
        1  ||  100                   123                                                                                                                                                                                                                        
        2  ||  100                   123                                                                                                                                                                                                                        
        3  ||  100                   123                                                                                                                                                                                                                        
        4  ||  100                   123                                                                                                                                                                                                                        
        5  ||  100                   123                                                                                                                                                                                                                        
        6  ||  100                   123                                                                                                                                                                                                                        
        7  ||  200                   123                                                                                                                                                                                                                        
        8  ||  200                   123                                                                                                                                                                                                                        
        9  ||  200                   123                                                                                                                                                                                                                        
       10  ||  200                   123                                                                                                                                                                                                                        
       11  ||  200                   123                                                                                                                                                                                                                        
       12  ||  200                   123                                                                                                                                                                                                                        
       13  ||  300                   123                                                                                                                                                                                                                        
       14  ||  300                   123                                                                                                                                                                                                                        
       15  ||  300                   123                                                                                                                                                                                                                        
       16  ||  300                   123                                                                                                                                                                                                                        
       17  ||  300                   123                                                                                                                                                                                                                        
       18  ||  300                   123                                                                                                                                                                                                                        
       19  ||  400                   123                                                                                                                                                                                                                        
       20  ||  400                   123                                                                                                                                                                                                                        
       21  ||  400                   123                                                                                                                                                                                                                        
       22  ||  400                   123                                                                                                                                                                                                                        
       23  ||  400                   123                                                                                                                                                                                                                        
       24  ||  400                   123                                                                                                                                                                                                                        
       25  ||  500                   123                                                                                                                                                                                                                        
       26  ||  500                   123                                                                                                                                                                                                                        
       27  ||  500                   123                                                                                                                                                                                                                        
       28  ||  500                   123                                                                                                                                                                                                                        
       29  ||  500                   123          



Am I using the updated SDTM102.DM from source side? As I remember you worked on your code in class and saved it on feb9th 2015 .
Can you please suggest me , if I am following some wrong steps here.
You can take a look on my code under    /folders/myshortcuts/deepa/AG102/qcprog/sdtm/DM.sas


Thanks,
Deepa.

Anova Groups

unread,
Feb 13, 2015, 2:32:47 PM2/13/15
to anova...@googlegroups.com
The updated one in batch5 regular folder, copy this program to your directory and rerun source and qc.
/folders/myshortcuts/batch5/AG102/prog/sdtm/DM.sas

Thirumagal manivannan

unread,
Feb 13, 2015, 6:57:49 PM2/13/15
to anova...@googlegroups.com
Deepa,
This is Thiru.
Please use sdtm102.dm from Batch5 folder. Not from DEEPA folder. If you have a question, please call me.
Thiru
Reply all
Reply to author
Forward
0 new messages