myCSG © |Area: ADaM| Concept: C1004 : ADaM BDS Derived Parameters Creation | Lesson: L101 : Creation of a New Parameter to Handle a Transformation (Log transformation of weight) |

  • We have weight of the subjects collected over time
  • For analysis purposes, we need to transform the reported weight logarithm values by using LOG 10 function
  • So, we are creating a new set of rows with a different parameter name to store the log transformed values

 

Weight      
Weight      
Weight      
Weight      
Log10 Weight      
Log10 Weight      
Log10 Weight      
Log10 Weight      

 

VARIABLE_NAMEVARIABLE_LABELDERIVATION
ADT Analysis Date 1. Derive this variable using VS.VSDTC
2. Extract the date portion from VSDTC and convert it to numeric value.
PARAM Parameter A. For source parameters:
1. Derive this variable using VS.VSTEST and VS.VSSTRESU
2. When VSTESTCD in ('HEIGHT' 'WEIGHT') then set PARAM as VSTEST||" ("||VSSTRESU||")"
B. Create a derived paramter 'Log10(Weight (kg))' using the source parameter 'Weight (kg)'.
PARAMCD Parameter Code A. For the source parameters, set to VS.VSTESTCD
B. For the derived paramter 'Log10(Weight (kg))' set to 'L10WT'
AVAL Analysis Value A. For the source parameters set to VS.VSSTRESN
B. For the derived parameter 'Log10(Weight (kg))':
1. Set AVAL to Log10(AVAL) where PARAMCD="WEIGHT"
2. Round the AVAL to two decimals
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