Medical Data cleaning in JMP from multiple excel sheets imported into JMP?
Hello,please kindly help me to find a more comfortable solution in JMP - rather what I do know, use excel incl VBA and import this into jmp:my medical database research is usually structured like, eg (master sheet):Unique identifierAgeWeightComorbidity 1 = Heart diseaseComorbidity2 = pulmonary diseaseAA3265yesnoAX3467yesyes an excel tab usually has ICD9/10 codes, eg:IdentifierICD CodeAAQ26.4AA776....