topic Re: PROC MI - Height & Weight of obs 128 still missing in Statistical Procedures

PROC MI - Height & Weight of obs 128 still missing

drkd — Mon, 14 Nov 2022 04:53:23 GMT

Hello Gurus,

I'm trying to impute height & weight of row 128 in this dsn but not sure what I am missing.... I can't seem to impute these 2 columns in obs 128. Any ideas?

DATA HEART;SET SASHELP.HEART;RUN;
PROC PRINT DATA=HEART(FIRSTOBS=126 OBS=130);TITLE 'BEFORE IMPUTING';RUN;
proc mi data=HEART seed=12345 nimpute=5 out=HEART_mi; var HEIGHT WEIGHT;RUN;
PROC PRINT DATA=HEART_MI(FIRSTOBS=126 OBS=130);TITLE 'AFTER IMPUTING';RUN;

Thanks.

Re: PROC MI - Height & Weight of obs 128 still missing

Rick_SAS — Mon, 14 Nov 2022 15:13:18 GMT

Look at the Missing Data Patterns table:

It shows that there are two observations for which BOTH Height and Weight are missing. The imputation does not impute those records. For other records, the procedure can estimate the joint distribution of Height and Weight and conditionally impute one missing value when the other variable is nonmissing.

One way to get imputed values when both Height and Weight are missing is to include a third variable. For example, if you think that joint distribution of heights and weights might be dependent on the SEX variable, you can use

proc mi data=HEART seed=12345 nimpute=5 out=HEART_mi;
class SEX; 
var HEIGHT WEIGHT SEX;
FCS;
RUN;

Re: PROC MI - Height & Weight of obs 128 still missing

drkd — Mon, 14 Nov 2022 20:11:23 GMT

Thanks Rick! That helped.

SAS help Heart

vsandoval6 — Thu, 26 Jan 2023 05:46:52 GMT

Please help with this probelem

Tabulate the percent of observations in the SASHELP.HEART dataset that have non-missing values for all the predictor variables that you will use in later analyses: AgeAtStart, BP_Status, Chol_Status, Cholesterol, Diastolic, Height, MRW, Sex, Smoking, Smoking_Status, Systolic, Weight, and Weight_Status.

Re: SAS help Heart

Rick_SAS — Thu, 26 Jan 2023 10:58:40 GMT

Since this sounds like a school assignment, I will give you a hint rather than a complete SAS program. You can get your answer by reading the article "Count the number of missing values for each variable."

The article shows how to get counts. To get percentages also, just remove the NOPERCENT option on the TABLES statement in PROC FREQ.