为了账号安全,请及时绑定邮箱和手机立即绑定

SAS LOCF

标签:
大数据

SAS Day 18: LOCF

Background:

Clinical trial studies often spanned several years. What happens if patients did not participate the check such as Vital Sign(blood pressure, weight) or Lab value(white blood cell count, red blood cell count) on some of the time points and caused the missing data?

The pharmaceutical industry standard method for imputing missing data is LOCF (Last Observation Carry Forward).

Definition:

LOCF is used for missing data in repeated measures that have been taken per subject by time point. The last observed non-missing value is used to fill in missing values at a later point in the study.



[caption id="attachment_1202" align="alignnone" width="750"]

webp

image

PIRO4D / Pixabay[/caption]

Example: LOCF with Lab dataset

Original Dataset:

webp

image

Solution:

  1. Fill the Missings Values by LOCF.

Key procedures: Retain, By

Code:

PROC SORT DATA=lab;
  BY usubjid lbtestcd avisitn;
RUN;

DATA locf;
  LENGTH dtype $15;
  RETAIN retain;
  SET lab;
  BY usubjid lbtestcd avisitn;  IF FIRST.lbtestcd THEN retain=.;  IF aval NE . THEN retain=aval;   IF aval=. THEN DO;
    avallocf=retain;
    dtype='LOCF';
  END;  ELSE avallocf=aval;
RUN;

Output:

webp

image

  1. Fill the missing value by LOCF except we do NOT carry the baseline value (visit 0)?

Code:

DATA locf1;
  LENGTH dtype $15;
  RETAIN retain;
  SET lab;
  BY usubjid lbtestcd avisitn;  IF FIRST.lbtestcd and avisitn^=0 THEN retain=.;  IF aval NE . and avisitn^=0 THEN retain=aval;   
  IF aval=. THEN DO;
    avallocf=retain;
    dtype='LOCF';
  END;  ELSE avallocf=aval;

RUN;

Output:

webp

image

Conclusion:

As widely as the LOCF is used in clinical trial studies, it is not the elixir for any cases, for example, LOCF leads to serious biased results in dementia drug studies.  Because LOCF ignores whether the participant's condition was improving or deteriorating at the time of dropout but instead freezes outcomes at the value observed before dropout.

As the novice techniques developed in clinical trials, there are many other methods are used for missing value imputation, such as BOCF(best observation carry forward) WOCF( worst observation carry forward), and Multiple Imputation.

Multiple Imputation is the hottest imputation method, however, we barely see it in Oncology studies, can you guess why?

**Happy Studying! **



作者:乌然娅措
链接:https://www.jianshu.com/p/6c024945d9ee


点击查看更多内容
TA 点赞

若觉得本文不错,就分享一下吧!

评论

作者其他优质文章

正在加载中
  • 推荐
  • 评论
  • 收藏
  • 共同学习,写下你的评论
感谢您的支持,我会继续努力的~
扫码打赏,你说多少就多少
赞赏金额会直接到老师账户
支付方式
打开微信扫一扫,即可进行扫码打赏哦
今天注册有机会得

100积分直接送

付费专栏免费学

大额优惠券免费领

立即参与 放弃机会
意见反馈 帮助中心 APP下载
官方微信

举报

0/150
提交
取消