...
The results for this analysis could be represented in tabular format as shown in the following table where the groupingId and groupId from the 2 two instances of the ResultGroup class found in the resultGroups attribute for each each result are represented in separate pairs of columns ("resultGroup1_groupingId"/"resultGroup1_groupId" and "resultGroup2_groupingId"/"resultGroup2_groupId"):
Dataset2 |
---|
analysis_id | operationId | resultGroup1_groupingId | resultGroup1_groupId | resultGroup2_groupingId | resultGroup2_groupId | rawValue | formattedValue |
---|
An03_03_Sex_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_1 | AnlsGrouping_02_Sex | AnlsGrouping_02_Sex_1 | 33 | 33 | An03_03_Sex_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_1 | AnlsGrouping_02_Sex | AnlsGrouping_02_Sex_2 | 53 | 53 | An03_03_Sex_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_2 | AnlsGrouping_02_Sex | AnlsGrouping_02_Sex_1 | 34 | 34 |
An03_03_Sex_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_2 | AnlsGrouping_02_Sex | AnlsGrouping_02_Sex_2 | 50 | 50 | An03_03_Sex_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_1_n | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_3 | AnlsGrouping_02_Sex | AnlsGrouping_02_Sex_1 | 44 | 44 | An0303Sex_ByTrtMth01_CatVar_Summ_ByGrp_1_n | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_3 | AnlsGrouping_02_Sex | AnlsGrouping_02_Sex_2 | 40 | 40 | An03_03_Sex_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_1 | AnlsGrouping_02_Sex | AnlsGrouping_02_Sex_1 | 38.3720930232558 | ( 38.4) |
An03_03_Sex_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_1 | AnlsGrouping_02_Sex | AnlsGrouping_02_Sex_2 | 61.6279069767442 | ( 61.6) | An03_03_Sex_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_2 | AnlsGrouping_02_Sex | AnlsGrouping_02_Sex_1 | 40.4761904761905 | ( 40.5) | An03_03_Sex_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_2 | AnlsGrouping_02_Sex | AnlsGrouping_02_Sex_2 | 59.5238095238095 | ( 59.5) |
An03_03_Sex_Summ_ByTrt | Mth01_Mth01_CatVar_Summ_ByGrp_2_pct | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_3 | AnlsGrouping_02_Sex | AnlsGrouping_02_Sex_1 | 52.3809523809524 | ( 52.4) |
An03_03_Sex_Summ_ByTrt | Mth01_CatVar_Summ_ByGrp_2_pct | AnlsGrouping_01_Trt | AnlsGrouping_01_Trt_3 | AnlsGrouping_02_Sex | AnlsGrouping_02_Sex_2 | 47.6190476190476 | ( 47.6) |
|
Alternatively, to aid readability, each of the identifier values could be used to retrieve and include additional descriptive information from the definitions of the analysis, operations, grouping factors, and groups:
Dataset2 |
---|
analysis_id | analysis_name |
---|
operationId | operation_label | resultGroup1_groupingId | resultGroup1_grouping_label | resultGroup1_groupId | resultGroup1_group_label | resultGroup2_groupingId | resultGroup2_grouping_label | resultGroup2_groupId | resultGroup2_group_label | rawValue | formattedValue |
---|
An03_03_Sex_Summ_ByTrt | Summary of Subjects by Treatment and Sex |
---|
Mth01_CatVar_Summ_ByGrp_1_n | n | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_1 | Placebo | AnlsGrouping_02_Sex | Gender | AnlsGrouping_02_Sex_1 | Male | 33 | 33 | An03_03_Sex_Summ_ByTrtSummary of Subjects by Treatment and Sex | Mth01_CatVar_Summ_ByGrp_1_n | n | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_1 | Placebo | AnlsGrouping_02_Sex | Gender | AnlsGrouping_02_Sex_2 | Female | 53 | 53 | An0303_Sex_Summ_ByTrtSummary of Subjects by Treatment and Sex | Mth01_CatVar_CatVar_Summ_ByGrp_1_n | n | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_2 | Xanomeline Low Dose | AnlsGrouping_02_Sex | Gender | AnlsGrouping_02_Sex_1 | Male | 34 | 34 |
An03_03_Sex_Summ_ByTrt | Summary of Subjects by Treatment and Sex | Mth01_CatVar_Summ_ByGrp_1_n | n | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_2 | Xanomeline Low Dose | AnlsGrouping_02_Sex | Gender | AnlsGrouping_02_Sex_2 | Female | 50 | 50 |
An03_03_Sex_Summ_ByTrt | Summary of Subjects by Treatment and Sex | Mth01_CatVar_Summ_ByGrp_1_n | n | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_3 | Xanomeline High Dose | AnlsGrouping_02_Sex | Gender | AnlsGrouping_02_Sex_1 | Male |
44 | 44 | An03_03_Sex_Summ_ByTrt | Summary of Subjects by Treatment and Sex | Mth01_CatVar_Summ_ByGrp_1_n | n | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_3 | Xanomeline High Dose | AnlsGrouping_02_Sex | Gender | AnlsGrouping_02_Sex_2 | Female | 40 | 40 | An03_03_Sex_Summ_ByTrtSummary of Subjects by Treatment and Sex | Mth01_CatVar_Summ_ByGrp_2_pct | % | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_1 | Placebo | AnlsGrouping_02_Sex | Gender | AnlsGrouping_02_Sex_1 | Male | 38.3720930232558 | ( 38.4) | An03_03_Sex_Summ_ByTrtSummary of Subjects by Treatment and Sex | Mth01_CatVar_Summ_ByGrp_2_pct | % | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_1 | Placebo | AnlsGrouping_02_Sex | Gender | AnlsGrouping_02_Sex_2 | Female | 61.6279069767442 | ( 61 | .6)An03_03_Sex_Summ_ByTrt | Summary of Subjects by Treatment and Sex.6) | Mth01_CatVar_Summ_ByGrp_2_pct | % | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_2 | Xanomeline Low Dose | AnlsGrouping_02_Sex | Gender | AnlsGrouping_02_Sex_1 | Male | 40.4761904761905 | ( 40.5) | An03_03_Sex_Summ_ByTrtSummary of Subjects by Treatment and Sex | Mth01_CatVar_Summ_ByGrp_2_pct | % | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_2 | Xanomeline Low Dose | AnlsGrouping_02_Sex | Gender | AnlsGrouping_02_Sex_2 | Female | 59.5238095238095 | ( 59.5) | An03_03_Sex_Summ_ByTrtSummary of Subjects by Treatment and Sex | Mth01_CatVar_Summ_ByGrp_2_pct | % | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_3 | Xanomeline High Dose | AnlsGrouping_02_Sex | Gender | AnlsGrouping_02_Sex_1 | Male | 52.3809523809524 | ( 52.4) |
An03_03_Sex_Summ_ByTrt | Summary of Subjects by Treatment and Sex | Mth01_CatVar_Summ_ByGrp_2_pct | % | AnlsGrouping_01_Trt | Treatment | AnlsGrouping_01_Trt_3 | Xanomeline High Dose | AnlsGrouping_02_Sex | Gender | AnlsGrouping_02_Sex_2 | Female | 47.6190476190476 | ( 47.6) |
|