Harmonized dataset summary report > Text variable summary
[Not present in mock-up, but make same changes to column names as for other variable types.]
1) Column titles and order should be:
Index
Grouping variable: adm_study_id
Variable name
Variable label
Mlstr_harmo::status
Quality assessment comment
Variable valueType
Categorical variable
Categories in data dictionary
Number of rows
Number of valid values
Number of non-valid values
Number of empty values
% Valid values
% Non-valid values
% Empty values
Number of distinct values
Most common values
Least common values
2) Change column P title to “Most common values”.
3) Change column Q title to “Least common values”.
4) For columns “Number of rows” to “% Empty values”:
Validate carefully how they are calculated and that they match the updated column titles.
Harmonized dataset summary report > Text variable summary
[Not present in mock-up, but make same changes to column names as for other variable types.] 1) Column titles and order should be: Index Grouping variable: adm_study_id Variable name Variable label Mlstr_harmo::status Quality assessment comment Variable valueType Categorical variable Categories in data dictionary Number of rows Number of valid values Number of non-valid values Number of empty values % Valid values % Non-valid values % Empty values Number of distinct values Most common values Least common values 2) Change column P title to “Most common values”. 3) Change column Q title to “Least common values”. 4) For columns “Number of rows” to “% Empty values”: Validate carefully how they are calculated and that they match the updated column titles.
See attached mock-up file for reference. summary_report_harmo_validated.xlsx