myCSG © |Area: ADaM| Concept: C1006 : ADaM BDS - Baseline Concepts | Lesson: L101 : Creation of baseline flag, last record on or prior to treatment start |

  • Lets say that one or more collections is possible prior to treatment start
  • We want to use the latest available result to compare it with the post treatment assessments
  • So, we flag the latest available result record with Y in ABLFL variable
SYSBP    
SYSBP   Y
SYSBP    
SYSBP    
SYSBP    
SYSBP    

In this lesson,

  • We will see how to identify the pre-treatment records
  • How to identify the latest record
  • How to use the information present on latest record to populate ABLFL as Y in parent dataset
 
VARIABLE_NAMEVARIABLE_LABELDERIVATION
USUBJID Unique Subject Identifier Equals to the value of VS.USUBJID
ADT Analysis Date Extract the date portion from VSDTC and convert it to numeric value
PARAM Parameter Set to propcase(VSPOS)||VSTEST||" ("||VSSTRESU||")
PARAMCD Parameter Code If VSPOS="SITTING" and VSTESTCD="SYSBP" then set to "STSBP",
Else if VSPOS="SITTING" and VSTESTCD="DIABP" then set to "STDBP"
PARAMN Parameter (N) If PARAMCD="STSBP" then set to 1,
Else if PARAMCD="STDBP" then set to 2.
AVAL Analysis Value Set to VSSTRESN
AVISIT Analysis Visit A. For the source records:
     If VS.VISIT="SCREEN" then set to "Screening",
     Else set to propcase(VS.VISIT)
B. For the record with ABLFL="Y" set to "Baseline"
AVISITN Analysis Visit (N) A. For the source records:
     If VS.VISIT="SCREEN" then set to -1,      Else Set to VS.VISITNUM
B. For the record with ABLFL="Y" set to 0
ABLFL Baseline Record Flag Set to "Y" on the latest record with non-missing result on or before treatment start date for each parameter within a subject
Complete SAS code to generate the output is available for registered users!

Already registered! Login
Not registered, you can signup here! Signup

Dont want to register?
You can directly purchase this lesson (code+input data) here


You can purchase this lesson (code+input data) here

If you are looking to purchase subscription for full access to data and programs for all lessons (TASKS+SDTM+ADaM+TFLs), you can send us a message on +91-7330--77--66--49-- on Whatsapp.
R data is available only for R subscribers.
You can contact us on +91-7330--77--66---49 for purchasing subscription to R programs and data
R codes are available only for R subscribers.
You can contact us on +91-7330--77--66---49 for purchasing subscription to R programs and data