- PROC SQL NOPRINT;
- create table tab1 as
- select 1 as id, '知情同意日期' as col1, convert(min(nicfdtc),getdate(),112) as col2, max(nicfdtc) as col3, (max(nicfdtc)-min(nicfdtc))/365.25 as col4 from bbb
- union select 4 as id, '试验历时(末次给药-首次知情)' as col1, min(ls) as col2, max(ls) as col3, (max(ls)-min(ls))/365.25 as col4 from bbb;
- QUIT;