I picked several variables along with Hb1AC and tried this. You would of course substitute variables that clinically make sense, since you are the subject-matter expert:
DESCRIPTIVES VARIABLES=S.Creatinine CrCl ALT AST TLC HGB PLT CKtotal CKMB INR TC HDL LDL TG RBG HbA1C.
About 31 complete cases. HbA1C does have some missing data.
Using MVA (the Missing Values Analysis procedure) and not MULTIPLE IMPUTATION:
DATASET DECLARE LabsWithImputedMissingValues.
MVA VARIABLES=S.Creatinine CrCl ALT AST TLC HGB PLT CKtotal CKMB INR TC HDL LDL TG RBG HbA1C
/EM(TOLERANCE=0.001 CONVERGENCE=0.0001 ITERATIONS=25 OUTFILE=LabsWithImputedMissingValues).
Little's MCAR test looks good, so I think you could include HbA1C and then use the new dataset LabsWithImputedMissingValues to do your analysis (without BUN and TROPONIN if possible).
------------------------------
Rick Marcantonio
Quality Assurance
IBM
------------------------------
Original Message:
Sent: Tue April 26, 2022 09:50 AM
From: Asmaa Saeed
Subject: Is using multiple imputation valid for this case ?
You are right the 786 on the troponin was a an entry error . looks like it got copied by mistake from the neighboring cell.
I agree that even if statistics aside it doesn't sound logical to impute that much missing data for the TROPONIN and the BUN
So if I exclude these 2 variables, what about the rest of them ?
HbA1c for exampe has 10 missing and 35 available. CK total has 2 missing and 43 available and CK-MB has 3 missing and 42 available. Is multiple imputation ,statistically speaking, valid for them ?
And as a follow up question in case it possibly is valid, Can I perform normality tests for these variables after imputation because the "explore" tab doesn't have that spiral mark indicating it's compatible with imputed values ?
Thank you
------------------------------
Asmaa Saeed
------------------------------
Original Message:
Sent: Tue April 26, 2022 09:35 AM
From: Rick Marcantonio
Subject: Is using multiple imputation valid for this case ?
The TROPONIN and BUN variables are, to me, suspect. If I look at the number of complete cases you have for analysis, it looks like about 8 if you include those variables; if you exclude them, you have 40 complete cases. Now, I don't know these data or their origin but, even if you believe that the data are missing at random, I wouldn't be very confident imputing values for either of them, especially for TROPONIN, which looks like it has a large outlier (786, the first case). I would have to understand more a lot about that value and how reasonable it is before I would include it. Could that be a data entry error?
In general - and without any expertise in your clinical area as regards the variables in question (BUN and TROPONIN) - my advice is to not estimate missing data for variables with so much missing data (as a rough estimate, say > 20% missing), especially with so few cases to begin with.
------------------------------
Rick Marcantonio
Quality Assurance
IBM