results: By groupingId and groupValue

This example shows the definition and results for a single analysis, "Summary of Subjects with TEAEs by Treatment, System Organ Class and Preferred Term", including the definitions of the grouping factors and method referenced by the analysis. This example illustrates the use of the groupingId and groupValue attributes of the ResultGroup class to associate results with groups in data-driven, results-by-group groupings.

Lines 1-29:	Show the definition of the 3 grouping factors referenced by the analysis. Lines 2-19: Show the definition of the "Treatment" grouping factor, which has 3 groups: "Placebo", "Xanomeline Low Dose", and "Xanomeline High Dose". This grouping factor is not data-driven (dataDriven = false on line 6). Lines 20-24: Show the definition of the "System Organ Class" grouping factor, for which group values are found in the ADAE AESOC variable specified in the groupingDataset and groupingVariable attributes on lines 22 and 23. This grouping factor is data-driven (dataDriven = true on line 24). Lines 25-29: Show the definition of the "Preferred Term" grouping factor, for which group values are found in the ADAE AEDECOD variable specified in the groupingDataset and groupingVariable attributes on lines 27 and 28. This grouping factor is data-driven (dataDriven = true on line 29).
Lines 31-44:	Show the definition of the method referenced by the analysis, "Summary by group of a categorical variable", which has 2 operations: Lines 34-38: Show the definition of the "Count of subjects" operation. Lines 39-43: Show the definition of the "Percent of subjects" operation.
Lines 46-61:	Show the definition of the analysis: Lines 49-50: Show that this is an analysis of the USUBJID variable in the ADSL dataset. Line 51: Shows the reference to the "Summary by group of a categorical variable" method. Lines 52-61: Show the references to the 3 grouping factors, both of which are marked as producing a result for each group in the grouping factor (resultsByGroup = true, shown on lines 54, 57 and 60).
Lines 62-183	Show a list of a subset of the results for the analysis. Each entry in the list (starting with the operationId attribute preceded by a hyphen) represents an instance of the OperationResult class and contains: The identifier value of the statistical operation performed, which is in the operationId attribute. In the resultGroups attribute, a reference to both grouping factor groups associated with the result (indicated by the values of the groupingId attribute and: groupId for the "Treatment" grouping factor (which has predefined groups) groupValue for the other 2 data-driven groupings factors. The raw result value in the rawValue attribute, and In the formattedValue attribute, the result value formatted according to the pattern specified in the resultPattern attribute of the operation referenced by the operationId value. The specified patterns are shown on rows 38 and 43.

YAML Example

analysisGroupings:
- id: AnlsGrouping_01_Trt
  name: Treatment
  groupingDataset: ADSL
  groupingVariable: TRT01A
  dataDriven: false
  groups:
  - id: AnlsGrouping_01_Trt_1
    name: Placebo
    order: 1
    ...
  - id: AnlsGrouping_01_Trt_2
    name: Xanomeline Low Dose
    order: 2 
    ...
  - id: AnlsGrouping_01_Trt_3
    name: Xanomeline High Dose
    order: 3 
    ...
- id: AnlsGrouping_06_Soc
  name: System Organ Class
  groupingDataset: ADAE
  groupingVariable: AESOC
  dataDriven: true
- id: AnlsGrouping_07_Pt
  name: Preferred Term
  groupingDataset: ADAE
  groupingVariable: AEDECOD
  dataDriven: true
methods:
- id: Mth01_CatVar_Summ_ByGrp
  name: Summary by group of a categorical variable
  operations:
  - id: Mth01_CatVar_Summ_ByGrp_1_n
    name: Count of subjects
    label: n
    order: 1
    resultPattern: XXX
  - id: Mth01_CatVar_Summ_ByGrp_2_pct
    name: Percent of subjects
    label: '%'
    order: 2
    resultPattern: ( XX.X)
    ...
analyses:
- id: An07_10_SocPt_Summ_ByTrt
  name: Summary of Subjects with TEAEs by Treatment, System Organ Class and Preferred Term
  version: 1
  dataset: ADAE
  variable: USUBJID
  methodId: Mth01_CatVar_Summ_ByGrp
  orderedGroupings:
  - order: 1
    resultsByGroup: true
    groupingId: AnlsGrouping_01_Trt
  - order: 2
    resultsByGroup: true
    groupingId: AnlsGrouping_06_Soc
  - order: 3
    resultsByGroup: true
    groupingId: AnlsGrouping_07_Pt
  results:
  - operationId: Mth01_CatVar_Summ_ByGrp_1_n
    resultGroups:
    - groupingId: AnlsGrouping_01_Trt
      groupId: AnlsGrouping_01_Trt_1
    - groupingId: AnlsGrouping_06_Soc
      groupValue: CARDIAC DISORDERS
    - groupingId: AnlsGrouping_07_Pt
      groupValue: ATRIAL FIBRILLATION
    rawValue: '1'
    formattedValue: '1'
  - operationId: Mth01_CatVar_Summ_ByGrp_2_pct
    resultGroups:
    - groupingId: AnlsGrouping_01_Trt
      groupId: AnlsGrouping_01_Trt_1
    - groupingId: AnlsGrouping_06_Soc
      groupValue: CARDIAC DISORDERS
    - groupingId: AnlsGrouping_07_Pt
      groupValue: ATRIAL FIBRILLATION
    rawValue: '1.1628'
    formattedValue: (  1.2)
  - operationId: Mth01_CatVar_Summ_ByGrp_1_n
    resultGroups:
    - groupingId: AnlsGrouping_01_Trt
      groupId: AnlsGrouping_01_Trt_1
    - groupingId: AnlsGrouping_06_Soc
      groupValue: GASTROINTESTINAL DISORDERS
    - groupingId: AnlsGrouping_07_Pt
      groupValue: DIARRHOEA
    rawValue: '9'
    formattedValue: '9'
  - operationId: Mth01_CatVar_Summ_ByGrp_2_pct
    resultGroups:
    - groupingId: AnlsGrouping_01_Trt
      groupId: AnlsGrouping_01_Trt_1
    - groupingId: AnlsGrouping_06_Soc
      groupValue: GASTROINTESTINAL DISORDERS
    - groupingId: AnlsGrouping_07_Pt
      groupValue: DIARRHOEA
    rawValue: '10.4651'
    formattedValue: ( 10.5)
  - operationId: Mth01_CatVar_Summ_ByGrp_1_n
    resultGroups:
    - groupingId: AnlsGrouping_01_Trt
      groupId: AnlsGrouping_01_Trt_2
    - groupingId: AnlsGrouping_06_Soc
      groupValue: CARDIAC DISORDERS
    - groupingId: AnlsGrouping_07_Pt
      groupValue: ATRIAL FIBRILLATION
    rawValue: '1'
    formattedValue: '1'
  - operationId: Mth01_CatVar_Summ_ByGrp_2_pct
    resultGroups:
    - groupingId: AnlsGrouping_01_Trt
      groupId: AnlsGrouping_01_Trt_2
    - groupingId: AnlsGrouping_06_Soc
      groupValue: CARDIAC DISORDERS
    - groupingId: AnlsGrouping_07_Pt
      groupValue: ATRIAL FIBRILLATION
    rawValue: '1.1905'
    formattedValue: (  1.2)
  - operationId: Mth01_CatVar_Summ_ByGrp_1_n
    resultGroups:
    - groupingId: AnlsGrouping_01_Trt
      groupId: AnlsGrouping_01_Trt_2
    - groupingId: AnlsGrouping_06_Soc
      groupValue: GASTROINTESTINAL DISORDERS
    - groupingId: AnlsGrouping_07_Pt
      groupValue: DIARRHOEA
    rawValue: '4'
    formattedValue: '4'
  - operationId: Mth01_CatVar_Summ_ByGrp_2_pct
    resultGroups:
    - groupingId: AnlsGrouping_01_Trt
      groupId: AnlsGrouping_01_Trt_2
    - groupingId: AnlsGrouping_06_Soc
      groupValue: GASTROINTESTINAL DISORDERS
    - groupingId: AnlsGrouping_07_Pt
      groupValue: DIARRHOEA
    rawValue: '4.7619'
    formattedValue: (  4.8)
  - operationId: Mth01_CatVar_Summ_ByGrp_1_n
    resultGroups:
    - groupingId: AnlsGrouping_01_Trt
      groupId: AnlsGrouping_01_Trt_3
    - groupingId: AnlsGrouping_06_Soc
      groupValue: CARDIAC DISORDERS
    - groupingId: AnlsGrouping_07_Pt
      groupValue: ATRIAL FIBRILLATION
    rawValue: '3'
    formattedValue: '3'
  - operationId: Mth01_CatVar_Summ_ByGrp_2_pct
    resultGroups:
    - groupingId: AnlsGrouping_01_Trt
      groupId: AnlsGrouping_01_Trt_3
    - groupingId: AnlsGrouping_06_Soc
      groupValue: CARDIAC DISORDERS
    - groupingId: AnlsGrouping_07_Pt
      groupValue: ATRIAL FIBRILLATION
    rawValue: '3.5714'
    formattedValue: (  3.6)
  - operationId: Mth01_CatVar_Summ_ByGrp_1_n
    resultGroups:
    - groupingId: AnlsGrouping_01_Trt
      groupId: AnlsGrouping_01_Trt_3
    - groupingId: AnlsGrouping_06_Soc
      groupValue: GASTROINTESTINAL DISORDERS
    - groupingId: AnlsGrouping_07_Pt
      groupValue: DIARRHOEA
    rawValue: '4'
    formattedValue: '4'
  - operationId: Mth01_CatVar_Summ_ByGrp_2_pct
    resultGroups:
    - groupingId: AnlsGrouping_01_Trt
      groupId: AnlsGrouping_01_Trt_3
    - groupingId: AnlsGrouping_06_Soc
      groupValue: GASTROINTESTINAL DISORDERS
    - groupingId: AnlsGrouping_07_Pt
      groupValue: DIARRHOEA
    rawValue: '4.7619'
    formattedValue: (  4.8)
    ...
 ...

The results for this analysis could be represented in tabular format as shown in the following table, where the value of the id attribute of the analysis is shown in the "analysisId" column and the groupingId and groupId or groupValue values from the 3 instances of the ResultGroup class found in the resultGroups attribute for each result are represented in separate pairs of columns ("groupingId1"/"groupId1", "groupingId2"/"groupValue2" and "groupingId3"/"groupValue3") so that each result is represented on a single row:

analysisId	operationId	groupingId1	groupId1	groupingId2	groupValue2	groupingId3	groupValue3	rawValue	formattedValue
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_1_n	AnlsGrouping_01_Trt	AnlsGrouping_01_Trt_1	AnlsGrouping_06_Soc	CARDIAC DISORDERS	AnlsGrouping_07_Pt	ATRIAL FIBRILLATION	1	1
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_2_pct	AnlsGrouping_01_Trt	AnlsGrouping_01_Trt_1	AnlsGrouping_06_Soc	CARDIAC DISORDERS	AnlsGrouping_07_Pt	ATRIAL FIBRILLATION	1.1628	( 1.2)
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_1_n	AnlsGrouping_01_Trt	AnlsGrouping_01_Trt_1	AnlsGrouping_06_Soc	GASTROINTESTINAL DISORDERS	AnlsGrouping_07_Pt	DIARRHOEA	9	9
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_2_pct	AnlsGrouping_01_Trt	AnlsGrouping_01_Trt_1	AnlsGrouping_06_Soc	GASTROINTESTINAL DISORDERS	AnlsGrouping_07_Pt	DIARRHOEA	10.4651	( 10.5)
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_1_n	AnlsGrouping_01_Trt	AnlsGrouping_01_Trt_2	AnlsGrouping_06_Soc	CARDIAC DISORDERS	AnlsGrouping_07_Pt	ATRIAL FIBRILLATION	1	1
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_2_pct	AnlsGrouping_01_Trt	AnlsGrouping_01_Trt_2	AnlsGrouping_06_Soc	CARDIAC DISORDERS	AnlsGrouping_07_Pt	ATRIAL FIBRILLATION	1.1905	( 1.2)
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_1_n	AnlsGrouping_01_Trt	AnlsGrouping_01_Trt_2	AnlsGrouping_06_Soc	GASTROINTESTINAL DISORDERS	AnlsGrouping_07_Pt	DIARRHOEA	4	4
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_2_pct	AnlsGrouping_01_Trt	AnlsGrouping_01_Trt_2	AnlsGrouping_06_Soc	GASTROINTESTINAL DISORDERS	AnlsGrouping_07_Pt	DIARRHOEA	4.7619	( 4.8)
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_1_n	AnlsGrouping_01_Trt	AnlsGrouping_01_Trt_3	AnlsGrouping_06_Soc	CARDIAC DISORDERS	AnlsGrouping_07_Pt	ATRIAL FIBRILLATION	3	3
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_2_pct	AnlsGrouping_01_Trt	AnlsGrouping_01_Trt_3	AnlsGrouping_06_Soc	CARDIAC DISORDERS	AnlsGrouping_07_Pt	ATRIAL FIBRILLATION	3.5714	( 3.6)
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_1_n	AnlsGrouping_01_Trt	AnlsGrouping_01_Trt_3	AnlsGrouping_06_Soc	GASTROINTESTINAL DISORDERS	AnlsGrouping_07_Pt	DIARRHOEA	4	4
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_2_pct	AnlsGrouping_01_Trt	AnlsGrouping_01_Trt_3	AnlsGrouping_06_Soc	GASTROINTESTINAL DISORDERS	AnlsGrouping_07_Pt	DIARRHOEA	4.7619	( 4.8)

Alternatively, to aid readability, each of the identifier values could be used to retrieve and include the name or label (or any other descriptive information) from the definitions of the operations, grouping factors, and predefined groups:

analysisId	operationId	operation_label	groupingId1	grouping_name1	groupId1	group_name1	groupingId2	grouping_name2	groupValue2	groupingId3	grouping_name3	groupValue3	rawValue	formattedValue
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_1_n	n	AnlsGrouping_01_Trt	Treatment	AnlsGrouping_01_Trt_1	Placebo	AnlsGrouping_06_Soc	System Organ Class	CARDIAC DISORDERS	AnlsGrouping_07_Pt	Preferred Term	ATRIAL FIBRILLATION	1	1
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_2_pct	%	AnlsGrouping_01_Trt	Treatment	AnlsGrouping_01_Trt_1	Placebo	AnlsGrouping_06_Soc	System Organ Class	CARDIAC DISORDERS	AnlsGrouping_07_Pt	Preferred Term	ATRIAL FIBRILLATION	1.1628	( 1.2)
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_1_n	n	AnlsGrouping_01_Trt	Treatment	AnlsGrouping_01_Trt_1	Placebo	AnlsGrouping_06_Soc	System Organ Class	GASTROINTESTINAL DISORDERS	AnlsGrouping_07_Pt	Preferred Term	DIARRHOEA	9	9
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_2_pct	%	AnlsGrouping_01_Trt	Treatment	AnlsGrouping_01_Trt_1	Placebo	AnlsGrouping_06_Soc	System Organ Class	GASTROINTESTINAL DISORDERS	AnlsGrouping_07_Pt	Preferred Term	DIARRHOEA	10.4651	( 10.5)
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_1_n	n	AnlsGrouping_01_Trt	Treatment	AnlsGrouping_01_Trt_2	Xanomeline Low Dose	AnlsGrouping_06_Soc	System Organ Class	CARDIAC DISORDERS	AnlsGrouping_07_Pt	Preferred Term	ATRIAL FIBRILLATION	1	1
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_2_pct	%	AnlsGrouping_01_Trt	Treatment	AnlsGrouping_01_Trt_2	Xanomeline Low Dose	AnlsGrouping_06_Soc	System Organ Class	CARDIAC DISORDERS	AnlsGrouping_07_Pt	Preferred Term	ATRIAL FIBRILLATION	1.1905	( 1.2)
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_1_n	n	AnlsGrouping_01_Trt	Treatment	AnlsGrouping_01_Trt_2	Xanomeline Low Dose	AnlsGrouping_06_Soc	System Organ Class	GASTROINTESTINAL DISORDERS	AnlsGrouping_07_Pt	Preferred Term	DIARRHOEA	4	4
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_2_pct	%	AnlsGrouping_01_Trt	Treatment	AnlsGrouping_01_Trt_2	Xanomeline Low Dose	AnlsGrouping_06_Soc	System Organ Class	GASTROINTESTINAL DISORDERS	AnlsGrouping_07_Pt	Preferred Term	DIARRHOEA	4.7619	( 4.8)
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_1_n	n	AnlsGrouping_01_Trt	Treatment	AnlsGrouping_01_Trt_3	Xanomeline High Dose	AnlsGrouping_06_Soc	System Organ Class	CARDIAC DISORDERS	AnlsGrouping_07_Pt	Preferred Term	ATRIAL FIBRILLATION	3	3
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_2_pct	%	AnlsGrouping_01_Trt	Treatment	AnlsGrouping_01_Trt_3	Xanomeline High Dose	AnlsGrouping_06_Soc	System Organ Class	CARDIAC DISORDERS	AnlsGrouping_07_Pt	Preferred Term	ATRIAL FIBRILLATION	3.5714	( 3.6)
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_1_n	n	AnlsGrouping_01_Trt	Treatment	AnlsGrouping_01_Trt_3	Xanomeline High Dose	AnlsGrouping_06_Soc	System Organ Class	GASTROINTESTINAL DISORDERS	AnlsGrouping_07_Pt	Preferred Term	DIARRHOEA	4	4
An07_10_SocPt_Summ_ByTrt	Mth01_CatVar_Summ_ByGrp_2_pct	%	AnlsGrouping_01_Trt	Treatment	AnlsGrouping_01_Trt_3	Xanomeline High Dose	AnlsGrouping_06_Soc	System Organ Class	GASTROINTESTINAL DISORDERS	AnlsGrouping_07_Pt	Preferred Term	DIARRHOEA	4.7619	( 4.8)

Page tree

results: By groupingId and groupValue