About drkd

drkd · ‎11-14-2022

Thanks Rick! That helped.

drkd · ‎11-13-2022

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.

drkd · ‎04-09-2019

Hi Gurus! How do I use the output of the proc sql into the next datastep? %macro m; proc sql;select distinct col1 from T;quit; %mend m; data in; set in;where col2 in (%m);run; fyi - I tried RESOLVE('%m') too. What do I need to do to make this logic work? Thanks in advance.

Online Status	Offline
Date Last Visited	‎11-15-2022 11:55 PM

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

PROC MI - Height & Weight of obs 128 still missing

output of a proc sql used in a where clause in a "data step"

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

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

PROC MI - Height & Weight of obs 128 still missing

output of a proc sql used in a where clause in a "data step"