SUPP	VARIABLE_NAME	VARIABLE_LABEL	TYPE	GENERAL_COMMENT	FORM_EQ5D3L
_	STUDYID	Study Identifier	Char	Populate as 'statschoice'
_	DOMAIN	Domain Abbreviation	Char	Populate as 'QS'
_	USUBJID	Unique Subject Identifier	Char	Concatenate the value of STUDYID variable to SUBJECT variable with a hyphen in between.
_	QSSEQ	Sequence Number	Num	Sort the records by USUBJID, QSCAT, QSTESTCD, QSDTC and set to 1 on the first record for each subject, and increment by 1 for each subsequent record within the subject
_	QSTESTCD	Question Short Name	Char		The responses to each question item is collected in a separate variable. We need to transform the data such that we a create a row for each question Create a record with QSTESTCD=EQ5D0101 to store the result from EQ5D3L_1. Create a record with QSTESTCD=EQ5D0102 to store the result from EQ5D3L_2. Create a record with QSTESTCD=EQ5D0103 to store the result from EQ5D3L_3. Create a record with QSTESTCD=EQ5D0104 to store the result from EQ5D3L_4. Create a record with QSTESTCD=EQ5D0105 to store the result from EQ5D3L_5. Create a record with QSTESTCD=EQ5D0106 to store the result from EQ5D3L_6.
_	QSTEST	Question Name	Char		Populate as 'EQ5D01-Mobility' when QSTESTCD=EQ5D0101. Populate as 'EQ5D01-Self-Care' when QSTESTCD=EQ5D0102. Populate as 'EQ5D01-Usual Activities' when QSTESTCD=EQ5D0103. Populate as 'EQ5D01-Pain/Discomfort' when QSTESTCD=EQ5D0104. Populate as 'EQ5D01-Anxiety/Depression' when QSTESTCD=EQ5D0105. Populate as 'EQ5D01-EQ VAS Score' when QSTESTCD=EQ5D0106.
_	QSCAT	Category of Question	Char		Populate as "EQ-5D-3L".
_	QSORRES	Finding in Original Units	Char		Populate using EQ5D3L_1 when creating row for QSTESTCD=EQ5D0101. Populate using EQ5D3L_2 when creating row for QSTESTCD=EQ5D0102. Populate using EQ5D3L_3 when creating row for QSTESTCD=EQ5D0103. Populate using EQ5D3L_4 when creating row for QSTESTCD=EQ5D0104. Populate using EQ5D3L_5 when creating row for QSTESTCD=EQ5D0105. Populate using EQ5D3L_6 when creating row for QSTESTCD=EQ5D0106. . Note for questions 1 to 5, use only the second component from the result variables when hyphen is the delimiter.
_	QSORRESU	Original Units	Char		Set to null
_	QSSTRESC	Character Result/Finding in Std Format	Char		Populate using EQ5D3L_1 when creating row for QSTESTCD=EQ5D0101. Populate using EQ5D3L_2 when creating row for QSTESTCD=EQ5D0102. Populate using EQ5D3L_3 when creating row for QSTESTCD=EQ5D0103. Populate using EQ5D3L_4 when creating row for QSTESTCD=EQ5D0104. Populate using EQ5D3L_5 when creating row for QSTESTCD=EQ5D0105. Populate using EQ5D3L_6 when creating row for QSTESTCD=EQ5D0106. . Note for questions 1 to 5, use only the first component from the result variables when hyphen is the delimiter.
_	QSSTRESN	Numeric Finding in Standard Units	Num	Populate using QS.QSSTRESC.
_	QSSTRESU	Standard Units	Char		Set to null
_	QSLOBXFL	Last Observation Before Exposure Flag	Char	Populate as "Y" on the latest record with non-missing result on or prior to DM.RFXSTDTC for each subject and test.
_	QSEVAL	Evaluator	Char		Populate as "STUDY SUBJECT"
_	VISITNUM	Visit Number	Num		Populate with the value from FOLDERSEQ
_	VISIT	Visit Name	Char		Populate with the value from FOLDERNAME
_	QSDTC	Date/Time of Finding	Char		Populate using QSDAT_RAW after converting to ISO8601 format.
_	QSDY	Study Day of Finding	Num	Populate using QS.QSDTC and DM.RFSTDTC. If QSDTC is on or after RFSTDTC then populate with the resulting value of QSDTC-RFSTDTC+1. Else if QSDTC is before RFSTDTC then populate with the resulting value of QSDTC-RFSTDTC.
_	QSEVINTX	Evaluation Interval Text	Char		Populate as "TODAY"

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

---