Terminology and 8char limit
library(plyr);library(dplyr);library(magrittr);library(tidyr);library(stringr);library(readr);library(readxl)##
## Attaching package: 'dplyr'## The following objects are masked from 'package:plyr':
##
## arrange, count, desc, failwith, id, mutate, rename, summarise,
## summarize## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union##
## Attaching package: 'tidyr'## The following object is masked from 'package:magrittr':
##
## extractdevtools::install_github("hadley/readxl")## Skipping install of 'readxl' from a github remote, the SHA1 (3ba34ab4) has not changed since last install.
## Use `force = TRUE` to force installationurl1<-'https://evs.nci.nih.gov/ftp1/CDISC/SDTM/SDTM%20Terminology.xls'
p1f <- tempfile()
# download.file(url1, p1f, mode="wb")
# p1<-read_excel(path = p1f)
fname1='c:/q/net/SDTM Terminology.xls'
p1<-read_excel(fname1,sheet = 2)## DEFINEDNAME: 21 00 00 01 0b 00 00 00 02 00 00 00 00 00 00 0d 3b 00 00 00 00 a3 4e 00 00 07 00
## DEFINEDNAME: 21 00 00 01 0b 00 00 00 02 00 00 00 00 00 00 0d 3b 00 00 00 00 a3 4e 00 00 07 00
## DEFINEDNAME: 21 00 00 01 0b 00 00 00 02 00 00 00 00 00 00 0d 3b 00 00 00 00 a3 4e 00 00 07 00
## DEFINEDNAME: 21 00 00 01 0b 00 00 00 02 00 00 00 00 00 00 0d 3b 00 00 00 00 a3 4e 00 00 07 00fname2='c:/q/net/CDASH Terminology.xls'
p2<-read_excel(fname2,sheet = 2)## DEFINEDNAME: 21 00 00 01 0b 00 00 00 02 00 00 00 00 00 00 0d 3b 00 00 00 00 df 00 00 00 07 00
## DEFINEDNAME: 21 00 00 01 0b 00 00 00 02 00 00 00 00 00 00 0d 3b 00 00 00 00 df 00 00 00 07 00
## DEFINEDNAME: 21 00 00 01 0b 00 00 00 02 00 00 00 00 00 00 0d 3b 00 00 00 00 df 00 00 00 07 00
## DEFINEDNAME: 21 00 00 01 0b 00 00 00 02 00 00 00 00 00 00 0d 3b 00 00 00 00 df 00 00 00 07 00# p2<-read_csv('https://evs.nci.nih.gov/ftp1/CDISC/SDTM/CDASH%20Terminology.xls')
d<-p2
#combine both input sources
d<-rbind(p1,p2)
#how many are code lists?
table(is.na(d$`Codelist Code`))##
## FALSE TRUE
## 19763 591#which codelists are big?
d %>% count(`Codelist Code`) %>% arrange(desc(n))## # A tibble: 590 × 2
## `Codelist Code` n
## <chr> <int>
## 1 C65047 1503
## 2 C67154 1503
## 3 C85491 1494
## 4 C74456 832
## 5 C71620 647
## 6 <NA> 591
## 7 C85493 295
## 8 C85839 295
## 9 C85494 292
## 10 C85492 267
## # ... with 580 more rowsd %>% count(`Codelist Name`) %>% arrange(desc(n)) %>% knitr::kable()| Codelist Name | n |
|---|---|
| Laboratory Test Code | 1504 |
| Laboratory Test Name | 1504 |
| Microorganism | 1495 |
| Anatomical Location | 833 |
| Unit | 648 |
| PK Parameters | 296 |
| PK Parameters Code | 296 |
| PK Units of Measure | 293 |
| Method | 268 |
| Holter ECG Results | 227 |
| ECG Result | 225 |
| Category of Questionnaire | 174 |
| Pharmaceutical Dosage Form | 170 |
| Neuropsychiatric Inventory Questionnaire Test Code | 154 |
| Neuropsychiatric Inventory Questionnaire Test Name | 154 |
| Race As Collected | 150 |
| PK Units of Measure - Dose mg | 145 |
| ADNI Auditory Verbal Learning Functional Test Test Code | 139 |
| ADNI Auditory Verbal Learning Functional Test Test Name | 139 |
| Route of Administration Response | 130 |
| PK Units of Measure - Dose ug | 128 |
| SDTM Species | 118 |
| Alzheimer’s Disease Assessment Scale - Cognitive CDISC Version Questionnaire Test Code | 111 |
| Alzheimer’s Disease Assessment Scale - Cognitive CDISC Version Questionnaire Test Name | 111 |
| Cardiovascular Test Code | 109 |
| Cardiovascular Test Name | 109 |
| ECG Test Code | 108 |
| ECG Test Name | 108 |
| Quality Of Life Enjoyment And Satisfaction Questionnaire Test Code | 102 |
| Quality Of Life Enjoyment And Satisfaction Questionnaire Test Name | 102 |
| Trial Summary Parameter Test Code | 101 |
| Trial Summary Parameter Test Name | 101 |
| Alzheimer’s Disease Cooperative Study-Activities of Daily Living Inventory MCI Version Questionnaire Test Code | 93 |
| Alzheimer’s Disease Cooperative Study-Activities of Daily Living Inventory MCI Version Questionnaire Test Name | 93 |
| SDTM Domain Abbreviation | 85 |
| Specimen Type | 85 |
| Alzheimer’s Disease Cooperative Study-Activities of Daily Living Inventory Questionnaire Test Code | 80 |
| Alzheimer’s Disease Cooperative Study-Activities of Daily Living Inventory Questionnaire Test Name | 80 |
| Frequency | 73 |
| Movement Disorder Society Unified Parkinson’s Disease Rating Scale Questionnaire Test Code | 73 |
| Movement Disorder Society Unified Parkinson’s Disease Rating Scale Questionnaire Test Name | 73 |
| Oncology Response Assessment Result | 71 |
| Brief Pain Inventory Questionnaire Test Code | 70 |
| Brief Pain Inventory Questionnaire Test Name | 70 |
| Category of Oncology Response Assessment | 69 |
| Unified Parkinson’s Disease Rating Scale Questionnaire Test Code | 69 |
| Unified Parkinson’s Disease Rating Scale Questionnaire Test Name | 69 |
| Respiratory Test Code | 65 |
| Respiratory Test Name | 65 |
| Columbia-Suicide Severity Rating Scale Already Enrolled Subjects Questionnaire Test Code | 63 |
| Columbia-Suicide Severity Rating Scale Already Enrolled Subjects Questionnaire Test Name | 63 |
| Relationship to Subject | 63 |
| Columbia-Suicide Severity Rating Scale Baseline/Screening Version Questionnaire Test Code | 61 |
| Columbia-Suicide Severity Rating Scale Baseline/Screening Version Questionnaire Test Name | 61 |
| Columbia-Suicide Severity Rating Scale Lifetime/Recent Version Questionnaire Test Code | 61 |
| Columbia-Suicide Severity Rating Scale Lifetime/Recent Version Questionnaire Test Name | 61 |
| Patient Health Questionnaire Screener Version Questionnaire Test Code | 60 |
| Patient Health Questionnaire Screener Version Questionnaire Test Name | 60 |
| Procedure | 60 |
| Functional Assessment of Multiple Sclerosis Version 4 Questionnaire Test Code | 59 |
| Functional Assessment of Multiple Sclerosis Version 4 Questionnaire Test Name | 59 |
| PK Units of Measure - Weight g | 57 |
| Columbia-Suicide Severity Rating Scale Pediatric/Cognitively Impaired Lifetime/Recent Questionnaire Test Code | 56 |
| Columbia-Suicide Severity Rating Scale Pediatric/Cognitively Impaired Lifetime/Recent Questionnaire Test Name | 56 |
| Multiple Sclerosis Quality of Life-54 Instrument Questionnaire Test Code | 56 |
| Multiple Sclerosis Quality of Life-54 Instrument Questionnaire Test Name | 56 |
| PK Units of Measure - Weight kg | 55 |
| Columbia-Suicide Severity Rating Scale Baseline/Screening Version Phase 1 Study Questionnaire Test Code | 52 |
| Columbia-Suicide Severity Rating Scale Baseline/Screening Version Phase 1 Study Questionnaire Test Name | 52 |
| St. George’s Respiratory Questionnaire Past 3 Months Version Questionnaire Test Code | 52 |
| St. George’s Respiratory Questionnaire Past 3 Months Version Questionnaire Test Name | 52 |
| St. George’s Respiratory Questionnaire Past 4 Weeks Version Questionnaire Test Code | 52 |
| St. George’s Respiratory Questionnaire Past 4 Weeks Version Questionnaire Test Name | 52 |
| Disability Assessment for Dementia Questionnaire Test Code | 50 |
| Disability Assessment for Dementia Questionnaire Test Name | 50 |
| World Health Organization Disability Assessment Schedule 2.0 - 12 + 24-Item Interviewer Questionnaire Test Code | 50 |
| World Health Organization Disability Assessment Schedule 2.0 - 12 + 24-Item Interviewer Questionnaire Test Name | 50 |
| World Health Organization Disability Assessment Schedule 2.0 - 36-Item Interviewer Questionnaire Test Code | 50 |
| World Health Organization Disability Assessment Schedule 2.0 - 36-Item Interviewer Questionnaire Test Name | 50 |
| Health Assessment Questionnaire Disability Index With Pain Visual Analog Scale Questionnaire Test Code | 47 |
| Health Assessment Questionnaire Disability Index With Pain Visual Analog Scale Questionnaire Test Name | 47 |
| Cardiovascular Findings About Results | 46 |
| Functional Assessment of Cancer Therapy-Hepatobiliary Version 4 Questionnaire Test Code | 46 |
| Functional Assessment of Cancer Therapy-Hepatobiliary Version 4 Questionnaire Test Name | 46 |
| Functional Assessment of Cancer Therapy-Leukemia Version 4 Questionnaire Test Code | 45 |
| Functional Assessment of Cancer Therapy-Leukemia Version 4 Questionnaire Test Name | 45 |
| Mayo-Portland Adaptability Inventory-4 Questionnaire Test Code | 45 |
| Mayo-Portland Adaptability Inventory-4 Questionnaire Test Name | 45 |
| Columbia-Suicide Severity Rating Scale Children’s Baseline/Screening Questionnaire Test Code | 44 |
| Columbia-Suicide Severity Rating Scale Children’s Baseline/Screening Questionnaire Test Name | 44 |
| Functional Assessment of Cancer Therapy-Lymphoma Version 4 Questionnaire Test Code | 43 |
| Functional Assessment of Cancer Therapy-Lymphoma Version 4 Questionnaire Test Name | 43 |
| National Eye Institute Visual Functioning Questionnaire - 25 Version 2000 Interviewer-Administered Format Questionnaire Test Code | 43 |
| National Eye Institute Visual Functioning Questionnaire - 25 Version 2000 Interviewer-Administered Format Questionnaire Test Name | 43 |
| National Eye Institute Visual Functioning Questionnaire - 25 Version 2000 Self-Administered Format Questionnaire Test Code | 43 |
| National Eye Institute Visual Functioning Questionnaire - 25 Version 2000 Self-Administered Format Questionnaire Test Name | 43 |
| Tumor or Lesion Properties Test Code | 43 |
| Tumor or Lesion Properties Test Name | 43 |
| St. George’s Respiratory Questionnaire for COPD Patients Questionnaire Test Code | 42 |
| St. George’s Respiratory Questionnaire for COPD Patients Questionnaire Test Name | 42 |
| Functional Assessment of Chronic Illness Therapy-Fatigue Version 4 Questionnaire Test Code | 41 |
| Functional Assessment of Chronic Illness Therapy-Fatigue Version 4 Questionnaire Test Name | 41 |
| World Health Organization Disability Assessment Schedule 2.0 - 36-Item Proxy Questionnaire Test Code | 41 |
| World Health Organization Disability Assessment Schedule 2.0 - 36-Item Proxy Questionnaire Test Name | 41 |
| Columbia-Suicide Severity Rating Scale Baseline Questionnaire Test Code | 40 |
| Columbia-Suicide Severity Rating Scale Baseline Questionnaire Test Name | 40 |
| Columbia-Suicide Severity Rating Scale Screening Questionnaire Test Code | 40 |
| Columbia-Suicide Severity Rating Scale Screening Questionnaire Test Name | 40 |
| The Functional Assessment of Cancer Therapy-Prostate Version 4 Questionnaire Test Code | 40 |
| The Functional Assessment of Cancer Therapy-Prostate Version 4 Questionnaire Test Name | 40 |
| World Health Organization Disability Assessment Schedule 2.0 - 36-Item Self Questionnaire Test Code | 40 |
| World Health Organization Disability Assessment Schedule 2.0 - 36-Item Self Questionnaire Test Name | 40 |
| Alzheimer’s Disease Cooperative Study-Activities of Daily Living Inventory Severe Dementia Version Questionnaire Test Code | 39 |
| Alzheimer’s Disease Cooperative Study-Activities of Daily Living Inventory Severe Dementia Version Questionnaire Test Name | 39 |
| Columbia-Suicide Severity Rating Scale Children’s Baseline Questionnaire Test Code | 38 |
| Columbia-Suicide Severity Rating Scale Children’s Baseline Questionnaire Test Name | 38 |
| Functional Assessment of Cancer Therapy-Breast Version 4 Questionnaire Test Code | 38 |
| Functional Assessment of Cancer Therapy-Breast Version 4 Questionnaire Test Name | 38 |
| Michigan Neuropathy Screening Instrument Questionnaire Test Code | 38 |
| Michigan Neuropathy Screening Instrument Questionnaire Test Name | 38 |
| RAND 36-Item Health Survey 1.0 Questionnaire Test Code | 37 |
| RAND 36-Item Health Survey 1.0 Questionnaire Test Name | 37 |
| Rey Auditory Verbal Learning Test Functional Test Test Code | 37 |
| Rey Auditory Verbal Learning Test Functional Test Test Name | 37 |
| Columbia-Suicide Severity Rating Scale Since Last Visit Questionnaire Test Code | 35 |
| Columbia-Suicide Severity Rating Scale Since Last Visit Questionnaire Test Name | 35 |
| Cardiac Procedure Indication | 34 |
| Category of Clinical Classification | 34 |
| Inventory of Depressive Symptomatology Clinician-Rated Version Clinical Classification Test Code | 34 |
| Inventory of Depressive Symptomatology Clinician-Rated Version Clinical Classification Test Name | 34 |
| Inventory of Depressive Symptomatology Self-Report Version Questionnaire Test Code | 34 |
| Inventory of Depressive Symptomatology Self-Report Version Questionnaire Test Name | 34 |
| The Overactive Bladder Questionnaire Questionnaire Test Code | 34 |
| The Overactive Bladder Questionnaire Questionnaire Test Name | 34 |
| Columbia-Suicide Severity Rating Scale Children’s Since Last Visit Questionnaire Test Code | 33 |
| Columbia-Suicide Severity Rating Scale Children’s Since Last Visit Questionnaire Test Name | 33 |
| Directionality | 33 |
| Device-In-Use Test Code | 32 |
| Device-In-Use Test Name | 32 |
| Expanded Disability Rating Scale - Postacute Interview Caregiver Version Questionnaire Test Code | 31 |
| Expanded Disability Rating Scale - Postacute Interview Caregiver Version Questionnaire Test Name | 31 |
| Genetic Sample Type | 31 |
| Geriatric Depression Scale Questionnaire Test Code | 31 |
| Geriatric Depression Scale Questionnaire Test Name | 31 |
| Positive and Negative Syndrome Scale Clinical Classification Test Code | 31 |
| Positive and Negative Syndrome Scale Clinical Classification Test Name | 31 |
| Vital Signs Test Code | 31 |
| Vital Signs Test Name | 31 |
| ECG Test Method | 29 |
| Extrapyramidal Symptom Rating Scale-Abbreviated Clinical Classification Test Code | 29 |
| Extrapyramidal Symptom Rating Scale-Abbreviated Clinical Classification Test Name | 29 |
| Ethnicity As Collected | 28 |
| The Functional Assessment of Cancer Therapy-General Version 4 Questionnaire Test Code | 28 |
| The Functional Assessment of Cancer Therapy-General Version 4 Questionnaire Test Name | 28 |
| Expanded Disability Rating Scale - Postacute Interview Survivor Version Questionnaire Test Code | 27 |
| Expanded Disability Rating Scale - Postacute Interview Survivor Version Questionnaire Test Name | 27 |
| Ophthalmic Exam Test Code | 27 |
| Ophthalmic Exam Test Name | 27 |
| Reproductive System Findings Test Code | 27 |
| Reproductive System Findings Test Name | 27 |
| Screener and Opioid Assessment for Patients with Pain - Revised Questionnaire Test Code | 27 |
| Screener and Opioid Assessment for Patients with Pain - Revised Questionnaire Test Name | 27 |
| The Expanded Prostate Cancer Index Composite Short Form Questionnaire Test Code | 27 |
| The Expanded Prostate Cancer Index Composite Short Form Questionnaire Test Name | 27 |
| Hamilton Depression Rating Scale - 24 Item Clinical Classification Test Code | 26 |
| Hamilton Depression Rating Scale - 24 Item Clinical Classification Test Name | 26 |
| Revised Fibromyalgia Impact Questionnaire Questionnaire Test Code | 26 |
| Revised Fibromyalgia Impact Questionnaire Questionnaire Test Name | 26 |
| Roland Morris Disability Questionnaire Questionnaire Test Code | 26 |
| Roland Morris Disability Questionnaire Questionnaire Test Name | 26 |
| Subject Characteristic Test Code | 26 |
| Subject Characteristic Test Name | 26 |
| Hamilton Depression Rating Scale 21-Item Clinical Classification Test Code | 25 |
| Hamilton Depression Rating Scale 21-Item Clinical Classification Test Name | 25 |
| Microscopic Findings Test Code | 25 |
| Microscopic Findings Test Name | 25 |
| Extended Glasgow Outcome Scale Questionnaire Test Code | 24 |
| Extended Glasgow Outcome Scale Questionnaire Test Name | 24 |
| Short-Form McGill Pain Questionnaire-2 Questionnaire Test Code | 23 |
| Short-Form McGill Pain Questionnaire-2 Questionnaire Test Name | 23 |
| The Expanded Prostate Cancer Index Composite for Clinical Practice Questionnaire Test Code | 23 |
| The Expanded Prostate Cancer Index Composite for Clinical Practice Questionnaire Test Name | 23 |
| Craig Handicap Assessment and Reporting Technique - Short Form Interview Version Questionnaire Test Code | 22 |
| Craig Handicap Assessment and Reporting Technique - Short Form Interview Version Questionnaire Test Name | 22 |
| Craig Handicap Assessment and Reporting Technique - Short Form Paper Version Questionnaire Test Code | 22 |
| Craig Handicap Assessment and Reporting Technique - Short Form Paper Version Questionnaire Test Name | 22 |
| Modified Fatigue Impact Scale Questionnaire Test Code | 22 |
| Modified Fatigue Impact Scale Questionnaire Test Name | 22 |
| Symptom Impact Questionnaire Questionnaire Test Code | 22 |
| Symptom Impact Questionnaire Questionnaire Test Name | 22 |
| World Health Organization Disability Assessment Schedule 2.0 - 12-Item Interviewer Questionnaire Test Code | 22 |
| World Health Organization Disability Assessment Schedule 2.0 - 12-Item Interviewer Questionnaire Test Name | 22 |
| Airway Questionnaire 20 Questionnaire Test Code | 21 |
| Airway Questionnaire 20 Questionnaire Test Name | 21 |
| Cardiovascular Findings About Test Code | 21 |
| Cardiovascular Findings About Test Name | 21 |
| Chronic Respiratory Questionnaire Self-Administered Standardized Format First Administration Version Questionnaire Test Code | 21 |
| Chronic Respiratory Questionnaire Self-Administered Standardized Format First Administration Version Questionnaire Test Name | 21 |
| Chronic Respiratory Questionnaire Self-Administered Standardized Format Follow-Up Administration Version Questionnaire Test Code | 21 |
| Chronic Respiratory Questionnaire Self-Administered Standardized Format Follow-Up Administration Version Questionnaire Test Name | 21 |
| Completion/Reason for Non-Completion | 21 |
| ECG Lead | 21 |
| Quick Inventory of Depressive Symptomatology Clinician-Rated Version Clinical Classification Test Code | 21 |
| Quick Inventory of Depressive Symptomatology Clinician-Rated Version Clinical Classification Test Name | 21 |
| Quick Inventory of Depressive Symptomatology Self-Report Version Questionnaire Test Code | 21 |
| Quick Inventory of Depressive Symptomatology Self-Report Version Questionnaire Test Name | 21 |
| Rivermead Post Concussion Symptoms Questionnaire Questionnaire Test Code | 21 |
| Rivermead Post Concussion Symptoms Questionnaire Questionnaire Test Name | 21 |
| Evaluator | 20 |
| Hamilton Depression Rating Scale - 17 Item Clinical Classification Test Code | 20 |
| Hamilton Depression Rating Scale - 17 Item Clinical Classification Test Name | 20 |
| National Comprehensive Cancer Network/Functional Assessment of Cancer Therapy-Kidney Symptom Index-19 Version 2 Questionnaire Test Code | 20 |
| National Comprehensive Cancer Network/Functional Assessment of Cancer Therapy-Kidney Symptom Index-19 Version 2 Questionnaire Test Name | 20 |
| Negative Symptom Assessment-16 Clinical Classification Test Code | 20 |
| Negative Symptom Assessment-16 Clinical Classification Test Name | 20 |
| The Overactive Bladder Questionnaire Short Form Questionnaire Test Code | 20 |
| The Overactive Bladder Questionnaire Short Form Questionnaire Test Name | 20 |
| Acute Physiology and Chronic Health Evaluation II Clinical Classification Test Code | 19 |
| Acute Physiology and Chronic Health Evaluation II Clinical Classification Test Name | 19 |
| Brief Psychiatric Rating Scale-A Questionnaire Test Code | 19 |
| Brief Psychiatric Rating Scale-A Questionnaire Test Name | 19 |
| Current Opioid Misuse Measure Questionnaire Test Code | 19 |
| Current Opioid Misuse Measure Questionnaire Test Name | 19 |
| National Comprehensive Cancer Network/Functional Assessment of Cancer Therapy-Bladder Symptom Index-18 Version 2 Questionnaire Test Code | 19 |
| National Comprehensive Cancer Network/Functional Assessment of Cancer Therapy-Bladder Symptom Index-18 Version 2 Questionnaire Test Name | 19 |
| National Comprehensive Cancer Network/Functional Assessment of Cancer Therapy-Ovarian Symptom Index-18 Version 2 Questionnaire Test Code | 19 |
| National Comprehensive Cancer Network/Functional Assessment of Cancer Therapy-Ovarian Symptom Index-18 Version 2 Questionnaire Test Name | 19 |
| Biospecimen Events Dictionary Derived Term | 18 |
| Discharge Disposition | 18 |
| Oncology Response Assessment Test Code | 18 |
| Oncology Response Assessment Test Name | 18 |
| The National Comprehensive Cancer Network/Functional Assessment of Cancer Therapy-Prostate Symptom Index 17 Version 2 Questionnaire Test Code | 18 |
| The National Comprehensive Cancer Network/Functional Assessment of Cancer Therapy-Prostate Symptom Index 17 Version 2 Questionnaire Test Name | 18 |
| Brief Pain Inventory Short Form Questionnaire Test Code | 17 |
| Brief Pain Inventory Short Form Questionnaire Test Name | 17 |
| Holter ECG Test Code | 17 |
| Holter ECG Test Name | 17 |
| Hospital Anxiety and Depression Scale Questionnaire Test Code | 17 |
| Hospital Anxiety and Depression Scale Questionnaire Test Name | 17 |
| Patient Health Questionnaire - 15 Item Questionnaire Test Code | 17 |
| Patient Health Questionnaire - 15 Item Questionnaire Test Name | 17 |
| Quality Of Life Enjoyment And Satisfaction Questionnaire - Short Form Test Code | 17 |
| Quality Of Life Enjoyment And Satisfaction Questionnaire - Short Form Test Name | 17 |
| Subjective Opiate Withdrawal Scale Questionnaire Test Code | 17 |
| Subjective Opiate Withdrawal Scale Questionnaire Test Name | 17 |
| Trial Type Response | 17 |
| World Health Organization Disability Assessment Schedule 2.0 - 12-Item Proxy Questionnaire Test Code | 17 |
| World Health Organization Disability Assessment Schedule 2.0 - 12-Item Proxy Questionnaire Test Name | 17 |
| Device Properties Test Code | 16 |
| Device Properties Test Name | 16 |
| Environmental Setting | 16 |
| Geriatric Depression Scale Short Form Questionnaire Test Code | 16 |
| Geriatric Depression Scale Short Form Questionnaire Test Name | 16 |
| International Index of Erectile Function Questionnaire Test Code | 16 |
| International Index of Erectile Function Questionnaire Test Name | 16 |
| Neuropathic Pain Scale Questionnaire Test Code | 16 |
| Neuropathic Pain Scale Questionnaire Test Name | 16 |
| Position | 16 |
| World Health Organization Disability Assessment Schedule 2.0 - 12-Item Self Questionnaire Test Code | 16 |
| World Health Organization Disability Assessment Schedule 2.0 - 12-Item Self Questionnaire Test Name | 16 |
| Contact Role for Clinical Study | 15 |
| Exacerbations of Chronic Pulmonary Disease Tool Patient-Reported Outcome Questionnaire Test Code | 15 |
| Exacerbations of Chronic Pulmonary Disease Tool Patient-Reported Outcome Questionnaire Test Name | 15 |
| Hamilton Anxiety Rating Scale Clinical Classification Test Code | 15 |
| Hamilton Anxiety Rating Scale Clinical Classification Test Name | 15 |
| Medical Evaluator | 15 |
| Specimen Condition | 15 |
| Tumor or Lesion Identification Test Results | 15 |
| Units for Vital Signs Results | 15 |
| Biospecimen Characteristics Test Code | 14 |
| Biospecimen Characteristics Test Name | 14 |
| Brief Assessment of Cognition in Schizophrenia Functional Test Test Code | 14 |
| Brief Assessment of Cognition in Schizophrenia Functional Test Test Name | 14 |
| Clinical Opiate Withdrawal Scale Questionnaire Test Code | 14 |
| Clinical Opiate Withdrawal Scale Questionnaire Test Name | 14 |
| Lead Abnormality | 14 |
| Social Risk Factor | 14 |
| Abnormal Involuntary Movement Scale Questionnaire Test Code | 13 |
| Abnormal Involuntary Movement Scale Questionnaire Test Name | 13 |
| Category of Functional Test | 13 |
| Concomitant Medication Dose Form | 13 |
| Concomitant Medication Route of Administration | 13 |
| Dermatology Life Quality Index Questionnaire Test Code | 13 |
| Dermatology Life Quality Index Questionnaire Test Name | 13 |
| Exposure Dose Form | 13 |
| Exposure Route of Administration | 13 |
| Glasgow Coma Scale NINDS Version Clinical Classification Test Code | 13 |
| Glasgow Coma Scale NINDS Version Clinical Classification Test Name | 13 |
| Microscopic Findings Test Details | 13 |
| Trial Phase Response | 13 |
| Unit of Drug Dispensed or Returned | 13 |
| Alcohol Use Disorder Identification Test: Self-Report Version Questionnaire Test Code | 12 |
| Alcohol Use Disorder Identification Test: Self-Report Version Questionnaire Test Name | 12 |
| Epoch | 12 |
| Functional Activities Questionnaire Test Code | 12 |
| Functional Activities Questionnaire Test Name | 12 |
| JFK Coma Recovery Scale-Revised Clinical Classification Test Code | 12 |
| JFK Coma Recovery Scale-Revised Clinical Classification Test Name | 12 |
| Kurtzke Functional Systems Scores Questionnaire Test Code | 12 |
| Kurtzke Functional Systems Scores Questionnaire Test Name | 12 |
| Microbiology Susceptibility Test Code | 12 |
| Microbiology Susceptibility Test Name | 12 |
| Pain Relief Questionnaire Test Code | 12 |
| Pain Relief Questionnaire Test Name | 12 |
| Patient Health Questionnaire - 9 Item Questionnaire Test Code | 12 |
| Patient Health Questionnaire - 9 Item Questionnaire Test Name | 12 |
| Skin Response Test Code | 12 |
| Skin Response Test Name | 12 |
| The Oswestry Disability Index Version 2.1a Questionnaire Test Code | 12 |
| The Oswestry Disability Index Version 2.1a Questionnaire Test Name | 12 |
| Tumor or Lesion Properties Test Result | 12 |
| Clinical COPD Questionnaire 1 Week Version Questionnaire Test Code | 11 |
| Clinical COPD Questionnaire 1 Week Version Questionnaire Test Name | 11 |
| Clinical COPD Questionnaire 24 Hour Version Questionnaire Test Code | 11 |
| Clinical COPD Questionnaire 24 Hour Version Questionnaire Test Name | 11 |
| Culture Medium Type | 11 |
| Device Identifier Long Name | 11 |
| Device Identifier Short Name | 11 |
| Functional Activities Questionnaire-NACC Version Questionnaire Test Code | 11 |
| Functional Activities Questionnaire-NACC Version Questionnaire Test Name | 11 |
| General Observation Class | 11 |
| Physical Properties Test Code | 11 |
| Physical Properties Test Name | 11 |
| The Prostate Cancer Specific Quality of Life Instrument Questionnaire Test Code | 11 |
| The Prostate Cancer Specific Quality of Life Instrument Questionnaire Test Name | 11 |
| Anti-Viral Outcome of Treatment | 10 |
| Device-In-Use Response | 10 |
| Fatigue Severity Scale Questionnaire Test Code | 10 |
| Fatigue Severity Scale Questionnaire Test Name | 10 |
| Generalized Anxiety Disorder - 7 Questionnaire Test Code | 10 |
| Generalized Anxiety Disorder - 7 Questionnaire Test Name | 10 |
| Intervention Type Response | 10 |
| Marital Status Response | 10 |
| Modified Hachinski Ischemic Scale-NACC Version Questionnaire Test Code | 10 |
| Modified Hachinski Ischemic Scale-NACC Version Questionnaire Test Name | 10 |
| Schizophrenia Findings About Test Code | 10 |
| Schizophrenia Findings About Test Name | 10 |
| Child-Pugh Classification Clinical Classification Test Code | 9 |
| Child-Pugh Classification Clinical Classification Test Name | 9 |
| Clinical Dementia Rating Questionnaire Test Code | 9 |
| Clinical Dementia Rating Questionnaire Test Name | 9 |
| Concomitant Medication Dose Units | 9 |
| Concomitant Medication Dosing Frequency per Interval | 9 |
| Device Tracking and Disposition Event Dictionary Derived Term | 9 |
| Disability Rating Scale Questionnaire Test Code | 9 |
| Disability Rating Scale Questionnaire Test Name | 9 |
| Epworth Sleepiness Scale Questionnaire Test Code | 9 |
| Epworth Sleepiness Scale Questionnaire Test Name | 9 |
| Exposure Dosing Frequency per Interval | 9 |
| Functional Assessment of Cancer Therapy-Ovarian Symptom Index Questionnaire Test Code | 9 |
| Functional Assessment of Cancer Therapy-Ovarian Symptom Index Questionnaire Test Name | 9 |
| Graft Type | 9 |
| Nervous System Physiology Test Code | 9 |
| Nervous System Physiology Test Name | 9 |
| Tumor or Lesion Identification Test Code | 9 |
| Tumor or Lesion Identification Test Name | 9 |
| Action Taken with Study Treatment | 8 |
| Category of Device Events | 8 |
| Coronary Vessel Disease Extent | 8 |
| Dictionary Name | 8 |
| Hamilton Depression Rating Scale - 6 Clinician Version Clinical Classification Test Code | 8 |
| Hamilton Depression Rating Scale - 6 Clinician Version Clinical Classification Test Name | 8 |
| Laterality | 8 |
| Microbiology Susceptibility Testing Result Category | 8 |
| Microbiology Test Code | 8 |
| Microbiology Test Name | 8 |
| Paced Auditory Serial Addition Test Functional Test Test Code | 8 |
| Paced Auditory Serial Addition Test Functional Test Test Name | 8 |
| Portion/Totality | 8 |
| Reason CS/LV Lead Not Implanted | 8 |
| Relation to Reference Period | 8 |
| Units for Exposure | 8 |
| Units for Planned Exposure | 8 |
| 6 Minute Walk Functional Test Test Code | 7 |
| 6 Minute Walk Functional Test Test Name | 7 |
| Arizona Sexual Experiences Scale - Female Questionnaire Test Code | 7 |
| Arizona Sexual Experiences Scale - Female Questionnaire Test Name | 7 |
| Arizona Sexual Experiences Scale - Male Questionnaire Test Code | 7 |
| Arizona Sexual Experiences Scale - Male Questionnaire Test Name | 7 |
| Coronary Artery Dissection NHLBI Grade Responses | 7 |
| European Quality of Life Five Dimension Five Level Scale Questionnaire Test Code | 7 |
| European Quality of Life Five Dimension Five Level Scale Questionnaire Test Name | 7 |
| European Quality of Life Five Dimension Three Level Scale Questionnaire Test Code | 7 |
| European Quality of Life Five Dimension Three Level Scale Questionnaire Test Name | 7 |
| Fitzpatrick Skin Classification Response | 7 |
| Hamilton Depression Rating Scale - 6 Self-Report Questionnaire Test Code | 7 |
| Hamilton Depression Rating Scale - 6 Self-Report Questionnaire Test Name | 7 |
| Musculoskeletal System Finding Test Code | 7 |
| Musculoskeletal System Finding Test Name | 7 |
| Non-system Reason for PCI Delay | 7 |
| Observational Study Model | 7 |
| Outcome of Event | 7 |
| Pain Intensity Questionnaire Test Code | 7 |
| Pain Intensity Questionnaire Test Name | 7 |
| Reason for Treatment Interruption | 7 |
| Sheehan Disability Scale Questionnaire Test Code | 7 |
| Sheehan Disability Scale Questionnaire Test Name | 7 |
| Sudden Death Syndrome Type | 7 |
| Work Productivity and Activity Impairment Questionnaire - Specific Health Problem V2.0 Questionnaire Test Code | 7 |
| Work Productivity and Activity Impairment Questionnaire - Specific Health Problem V2.0 Questionnaire Test Name | 7 |
| Acute Coronary Syndrome Presentation Category | 6 |
| Age Unit | 6 |
| Bowel Control Scale Questionnaire Test Code | 6 |
| Bowel Control Scale Questionnaire Test Name | 6 |
| Consensus Cardiac Classification System Test Code | 6 |
| Consensus Cardiac Classification System Test Name | 6 |
| Contact Case Investigation Contact Type | 6 |
| Coronary Artery Disease Presentation | 6 |
| Coronary Thrombus TIMI Grade Responses | 6 |
| Disease Outcome | 6 |
| General Clinical Global Impressions Questionnaire Test Code | 6 |
| General Clinical Global Impressions Questionnaire Test Name | 6 |
| Impact of Visual Impairment Scale Questionnaire Test Code | 6 |
| Impact of Visual Impairment Scale Questionnaire Test Name | 6 |
| Laboratory Test Standard Character Result | 6 |
| Left Ventricular Ejection Fraction Measurement Result | 6 |
| Normal Abnormal Response | 6 |
| Race | 6 |
| Satisfaction With Life Scale Questionnaire Test Code | 6 |
| Satisfaction With Life Scale Questionnaire Test Name | 6 |
| The Body-Mass Index, Airflow Obstruction, Dyspnea, and Exercise Capacity Index Clinical Classification Test Code | 6 |
| The Body-Mass Index, Airflow Obstruction, Dyspnea, and Exercise Capacity Index Clinical Classification Test Name | 6 |
| Treatment Setting | 6 |
| Trial Intent Type Response | 6 |
| Unit of Measure for Flow Rate | 6 |
| West Haven Hepatic Encephalopathy Grade | 6 |
| Barnes Akathisia Rating Scale Questionnaire Test Code | 5 |
| Barnes Akathisia Rating Scale Questionnaire Test Name | 5 |
| Bladder Control Scale Questionnaire Test Code | 5 |
| Bladder Control Scale Questionnaire Test Name | 5 |
| Canadian Cardiovascular Society Classification | 5 |
| Cardiac Rhythm Device Failure Manifestation | 5 |
| Control Type Response | 5 |
| COPD Findings About Test Code | 5 |
| COPD Findings About Test Name | 5 |
| Coronary Artery Disease Risk | 5 |
| Coronary Artery Disease Symptoms | 5 |
| Diabetes Therapy | 5 |
| Disease Presentation Type | 5 |
| Ethnic Group | 5 |
| Intervention Model Response | 5 |
| Killip Class Responses | 5 |
| Mechanical Circulatory Support Placement Timing | 5 |
| New York Heart Association Classification | 5 |
| No Yes Response | 5 |
| Pharmacogenomics Biomarker Medical Statement | 5 |
| Procedure Urgency Status | 5 |
| Reason For Treatment | 5 |
| Reference Range Indicator | 5 |
| Risk Assessment | 5 |
| Sex | 5 |
| Stent Thrombosis, Coronary, ARC Timing Responses | 5 |
| Study Type Response | 5 |
| TIMI Flow Responses | 5 |
| Tuberculosis Findings About Test Code | 5 |
| Tuberculosis Findings About Test Name | 5 |
| Alcohol Use Disorder Identification Test-Consumption Questions Questionnaire Test Code | 4 |
| Alcohol Use Disorder Identification Test-Consumption Questions Questionnaire Test Name | 4 |
| Baseline Dyspnea Index Questionnaire Test Code | 4 |
| Baseline Dyspnea Index Questionnaire Test Name | 4 |
| Category for Disposition Event | 4 |
| Clinical Global Impression Questionnaire Test Code | 4 |
| Clinical Global Impression Questionnaire Test Name | 4 |
| Coronary Artery Dominance | 4 |
| Death Details Test Code | 4 |
| Death Details Test Name | 4 |
| Device Events Action Taken with Device | 4 |
| Drug Resistance Status | 4 |
| ECG Original Units | 4 |
| Employment Status | 4 |
| Immunogenicity Specimen Assessments Test Code | 4 |
| Immunogenicity Specimen Assessments Test Name | 4 |
| Lead Status | 4 |
| Lesion Complexity | 4 |
| Location of Most Severe Stenosis Within a Graft | 4 |
| Multiple Sclerosis Findings About Test Code | 4 |
| Multiple Sclerosis Findings About Test Name | 4 |
| Never/Current/Former Classification | 4 |
| Observational Study Biospecimen Retention | 4 |
| Observational Study Time Perspective | 4 |
| Ophthalmic Focus of Study Specific Interest | 4 |
| Priority of Tuberculosis Contact | 4 |
| Severity/Intensity Scale for Adverse Events | 4 |
| Sex of Participants Response | 4 |
| Size Response | 4 |
| Skin Type Response | 4 |
| Stent Thrombosis, Coronary ARC Grade Responses | 4 |
| Subject Status Response | 4 |
| Substance Use Never/Current/Former Classification | 4 |
| Supporting Evidence for Re-Treatment | 4 |
| Total Volume Administration Unit | 4 |
| Transition Dyspnea Index Questionnaire Test Code | 4 |
| Transition Dyspnea Index Questionnaire Test Name | 4 |
| Treatment Intent | 4 |
| Trial Blinding Schema Response | 4 |
| Unit for the Duration of Treatment Interruption | 4 |
| Urinary System Test Code | 4 |
| Urinary System Test Name | 4 |
| Vaccination Evidence Source | 4 |
| Vital Signs Position of Subject | 4 |
| BRIDG Activity Mood | 3 |
| Case Finding | 3 |
| Category for Inclusion/Exclusion | 3 |
| Drug Accountability Test Code | 3 |
| Drug Accountability Test Name | 3 |
| Medical History Event Date Type | 3 |
| Microbial Identification Certainty | 3 |
| Mode of Disease Transmission | 3 |
| Nine-Hole Peg Test Functional Test Test Code | 3 |
| Nine-Hole Peg Test Functional Test Test Name | 3 |
| Observational Study Sampling Method | 3 |
| Protocol Milestone | 3 |
| Relationship Type | 3 |
| Tanner Scale Boy Clinical Classification Test Code | 3 |
| Tanner Scale Boy Clinical Classification Test Name | 3 |
| Tanner Scale Girl Clinical Classification Test Code | 3 |
| Tanner Scale Girl Clinical Classification Test Name | 3 |
| Timed 25-Foot Walk Test Functional Test Test Code | 3 |
| Timed 25-Foot Walk Test Functional Test Test Name | 3 |
| Trail Making Test Functional Test Test Code | 3 |
| Trail Making Test Functional Test Test Name | 3 |
| Alzheimer’s Disease Cooperative Study-Clinical Global Impression of Change Questionnaire Test Code | 2 |
| Alzheimer’s Disease Cooperative Study-Clinical Global Impression of Change Questionnaire Test Name | 2 |
| ASSIGN Cardiovascular Disease 10-Year Risk Score Clinical Classification Test Code | 2 |
| ASSIGN Cardiovascular Disease 10-Year Risk Score Clinical Classification Test Name | 2 |
| Atherosclerotic Cardiovascular Disease 10-Year Risk Estimator Clinical Classification Test Code | 2 |
| Atherosclerotic Cardiovascular Disease 10-Year Risk Estimator Clinical Classification Test Name | 2 |
| Borg CR10 Scale Questionnaire Test Code | 2 |
| Borg CR10 Scale Questionnaire Test Name | 2 |
| Brooke Upper Extremity Rating Scale Clinical Classification Test Code | 2 |
| Brooke Upper Extremity Rating Scale Clinical Classification Test Name | 2 |
| CDC Classification System for HIV-Infected Adults and Adolescents Clinical Classification Test Code | 2 |
| CDC Classification System for HIV-Infected Adults and Adolescents Clinical Classification Test Name | 2 |
| Coronary Artery Dissection NHLBI Grade Clinical Classification Test Code | 2 |
| Coronary Artery Dissection NHLBI Grade Clinical Classification Test Name | 2 |
| Coronary Thrombus TIMI Grade Clinical Classification Test Code | 2 |
| Coronary Thrombus TIMI Grade Clinical Classification Test Name | 2 |
| Diabetic Kidney Disease Findings About Test Code | 2 |
| Diabetic Kidney Disease Findings About Test Name | 2 |
| Diagnosis Group Response | 2 |
| Disease Steps Questionnaire Test Code | 2 |
| Disease Steps Questionnaire Test Name | 2 |
| Eastern Cooperative Oncology Group Performance Status Questionnaire Test Code | 2 |
| Eastern Cooperative Oncology Group Performance Status Questionnaire Test Name | 2 |
| Faces Pain Scale - Revised Questionnaire Test Code | 2 |
| Faces Pain Scale - Revised Questionnaire Test Name | 2 |
| Framingham Heart Study Cardiovascular Disease 10-Year Risk Score Clinical Classification Test Code | 2 |
| Framingham Heart Study Cardiovascular Disease 10-Year Risk Score Clinical Classification Test Name | 2 |
| Gastrointestinal Test Code | 2 |
| Gastrointestinal Test Name | 2 |
| Hauser Ambulation Index Functional Test Test Code | 2 |
| Hauser Ambulation Index Functional Test Test Name | 2 |
| Karnofsky Performance Status Scale Questionnaire Test Code | 2 |
| Karnofsky Performance Status Scale Questionnaire Test Name | 2 |
| Kidney Donor Profile Index Clinical Classification Test Code | 2 |
| Kidney Donor Profile Index Clinical Classification Test Name | 2 |
| Kurtzke Expanded Disability Status Scale Questionnaire Test Code | 2 |
| Kurtzke Expanded Disability Status Scale Questionnaire Test Name | 2 |
| Model for End Stage Liver Disease Clinical Classification Test Code | 2 |
| Model for End Stage Liver Disease Clinical Classification Test Name | 2 |
| Modified Medical Research Council Dyspnea Scale Questionnaire Test Code | 2 |
| Modified Medical Research Council Dyspnea Scale Questionnaire Test Name | 2 |
| Modified Rankin Scale Questionnaire Test Code | 2 |
| Modified Rankin Scale Questionnaire Test Name | 2 |
| Not Done | 2 |
| Patient Determined Disease Steps Questionnaire Test Code | 2 |
| Patient Determined Disease Steps Questionnaire Test Name | 2 |
| Pharmacogenomics Findings Test Code | 2 |
| Pharmacogenomics Findings Test Name | 2 |
| Reynolds Cardiovascular Disease 10-Year Risk Score Clinical Classification Test Code | 2 |
| Reynolds Cardiovascular Disease 10-Year Risk Score Clinical Classification Test Name | 2 |
| Stent Thrombosis Coronary ARC Grade Clinical Classification Test Code | 2 |
| Stent Thrombosis Coronary ARC Grade Clinical Classification Test Name | 2 |
| Subject Status Test Code | 2 |
| Subject Status Test Name | 2 |
| Symbol Digit Modalities Test Functional Test Test Code | 2 |
| Symbol Digit Modalities Test Functional Test Test Name | 2 |
| Timed Up and Go Test Functional Test Test Code | 2 |
| Timed Up and Go Test Functional Test Test Name | 2 |
| Urgency Perception Scale Questionnaire Test Code | 2 |
| Urgency Perception Scale Questionnaire Test Name | 2 |
| Vignos Lower Extremity Rating Scale Clinical Classification Test Code | 2 |
| Vignos Lower Extremity Rating Scale Clinical Classification Test Name | 2 |
| West Haven Hepatic Encephalopathy Grade Clinical Classification Test Code | 2 |
| West Haven Hepatic Encephalopathy Grade Clinical Classification Test Name | 2 |
| WHO Clinical Staging of HIV/AIDS for Adults and Adolescents Clinical Classification Test Code | 2 |
| WHO Clinical Staging of HIV/AIDS for Adults and Adolescents Clinical Classification Test Name | 2 |
| WHO Clinical Staging of HIV/AIDS for Children Clinical Classification Test Code | 2 |
| WHO Clinical Staging of HIV/AIDS for Children Clinical Classification Test Name | 2 |
#excluding lab names
t <- d %>% filter(!`Codelist Code` =='C65047')
tta <- d %>% filter(`Codelist Name` =='Unit')
# knitr::kable(tta)