QC of DM in AG102

[Anova Groups Forum]

There are few variables missing from the source side as given below. I they are all required/expected so I have added them in our specs, please review and add these variables to your dataset.

                                                                                                                                                                                                                                                                
Listing of Variables in WORK.FINAL_DM but not in SDTM102.DM                                                                                                                                                                                                     
                                                                                                                                                                                                                                                                
Variable  Type  Length  Label                                                                                                                                                                                                                                   
                                                                                                                                                                                                                                                                
RFXSTDTC  Char      16  Date/Time of First Study Treatment                                                                                                                                                                                                      
RFXENDTC  Char      16  Date/Time of Last Study Treatment                                                                                                                                                                                                       
RFICDTC   Char      16  Date/Time of Informed Consent                                                                                                                                                                                                           
RFPENDTC  Char      16  Date/Time of End of Participation                                                                                                                                                                                                       
DTHDTC    Char      16  Date/Time of Death                                                                                                                                                                                                                      
DTHFL     Char       2  Subject Death Flag                                                                                                                                                                                                                      
ACTARMCD  Char       8  Actual Arm Code                                                                                                                                                                                                                         
ACTARM    Char      40  Description of Actual Arm Code  

[Anova Groups]

Sarika,

Thanks for catching these issues. I found that you missed some information which I have highlighted in red. Please check and confirm the updates. 

Thanks,

Vikas

[Anova Groups]

Thanks for the update. I have reviewed your changes and they look good to me. Please let me know when I can run my QC program.

[Anova Groups]

Sarika,

I have udpated my program as per the specs, please run your qc program and let me know if any other discrepancies.

Thanks,

Vikas

[Anova Groups]

I think we are close, we are matching all the variables expect RFPENDTC which qc needs to be derived based on new specs. I will update you tomorrow once I have that in my code.

[Sarika]

Hello Vikas,

After updating my code with RFPENDTC, all values do match.

Thank you.

Sarika.

Observation Summary                                                                                                                                                                                                                                             
                                                                                                                                                                                                                                                                
Observation      Base  Compare                                                                                                                                                                                                                                  
                                                                                                                                                                                                                                                                
First Obs           1        1                                                                                                                                                                                                                                  
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: 0.                                                                                                                                                                                                 
Number of Observations with All Compared Variables Equal: 60.                                                                                                                                                                                                   
                                                                                                                                                                                                                                                                
NOTE: No unequal values were found. All values compared are exactly equal.