*--RFXSTDTC RFXENDTC 受试者给药开始和结束日期;
data ec(where=(^missing(ECSTDTC)));
set raw.ec;
ECSTDTC=catx('T',ECDAT,ECSTTIM);
ECENDTC=catx('T',ECDAT,ECENTIM);
run;
proc sql;
create table ec1(label='RFXSTDTC RFXENDTC') as
select USUBJID,SITEID,SUBJID
,min(ECSTDTC) as RFXSTDTC
,max(ECENDTC) as RFXENDTC
from ec
group by USUBJID,SITEID,SUBJID;
quit;
该过程可以获取同一受试者多次给药过程中首次给药时间和给药结束时间,可参考。