In clinical trials, we collect data at predetermined timepoints
These predetermined timepoints are called visits
Sometimes, the data could not be collected/reported at some visits for reasons like subject refused for a test or collected sample damaged etc
For analysis purposes, we may want to have all data available for each visit for all subjects
One approach to fill in the missing data is to assume that result would have been the same as previous available collection/result
This is technically called as 'last observation carried forward' and the newly 'filled' (created) record is called an imputed record/result
We fill in the missing visits with the results from the previous available result
ADaM implementation
CDISC ADaM standard allows for this kind of data imputation
As per the standard, we can create new derived records within the parameter
These new records have to be differentiated from the source records by populating the DTYPE variable
The value in DTYPE variable has to be 'LOCF' if we are using the 'last observation carried forward' approach
VARIABLE_NAME
VARIABLE_LABEL
DERIVATION
AVISIT
Analysis Value
SYSBP is collected every week from week 1 to week 5. For the subjects who do not have a result present in any analysis week from week 1 to week 5, create a new record for the missed analysis week by using the record which is closest to the missing analysis week.
DTYPE
Derivation Type
Set to 'LOCF' on the imputed record.
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