ABLFL = Y, then BASE must equal AVAL - need more understanding

v Venkata

on March 4, 2013

Hello support team -

I did ADAM BDS datasets fro questionarie datsets - here is need of analysis is

1. we have two types of questionarie - 1). Pre questions and 2). post questions.

2. we are intreatsed see PRE vs POST.

3. so here BASE and AVAL wonot be same.

Could you please let me know your thoughts and I appreciate your swift help.

Thanks,

Venkata

Forums: ADaM

m Michael

on March 4, 2013

AVAL and BASE - AD0152

Read over ADaM IG 1.0 page 28 for descriptions of the fields. This idea is that a patient can have n records for a specific paramcd. You can mark which record is the baseline value. For analysis, the baseline value is maintained in its own column so you can do calculations against it. Therefore any record marked as the baseline value must have both the AVAL and BASE as the same. In this example, the only record that would fail is the last one. AVAL and BASE must be equal because that record is marked as the basellne record. Records 2 and 3 don't match, but they good because they aren't the baseline records.

STUDYID	USUBJID	PARAMCD	ABLFL	AVAL	AVALC	BASE	BASEC	CHG
0123-456	10001	MIGRAINE	Y	1	Mild Pain	1	Severe	0
0123-456	10001	MIGRAINE		2	Mild Pain 2	1	Severe	-1
0123-456	10001	MIGRAINE		3	Mild Pain 3	1	Severe	-2
0123-456	30001	MIGRAINE	Y	2	Mild Pain 2	9999	Really Bad	0

v Venkata

on March 4, 2013

AVAL and BASE - AD0152

Thanks for the mail.

we have two set of questionaries in the dataset

1. PRE Self assessment - collected only @ Baseline - contains 7 set of questions.

2. POST Self assessment - collected Baseline and post baseline visits - contains 27 set of questions (it includes 7 similar questions of PRE assessment).

Our analysis requirement is:

we want to compare the score of 7 PRE questions vs similat & post questions - and we want to see change and percent change for PRE baseline vs POST baseline scores.

due to above analysis need post 7 questions AVAL score comes from POST self assessment and BASE score comes from PRE self assessment - so both are diffrent.

I hope it clarifies, if not then do let me know, thanks for ur help:)

Venakata